Oninit® Archive
Results for “onstat -d”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
script to check status of dbspaces & chunks
Can anyone please share DBmon (with onstat -d) script ?…
ASF connection name error during startup
Not onstat -D, Paul, oninit -D - starting the engine without replication. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
SBSPACE Chunk error
Hi please check the flags for onstat -d output here: https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=utility-onstat-d-command-print-chunk-information "Why these alerts are coming"? Informix Server does not send out any alerts per email per default. But maybe you have a…
Extending chunk capacity
Thanks for the follow up John. Just to explain my reasoning for only marking the last chunk in the dbspace for extending: Today with filesystem chunks, I usually set up clients to mark the initial chunk of a dbspace as extendable. Typically most chunks will be allocated in a sing…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
onstat -d for non-privileged users
Hi Y'all. In my Perl package DBspaces .pm I have a function that runs onstat -d. I originally wrote it while using IDS 11.5. At the time, anyone could run onstat -d, just not with the "update" option. That was fine by me. Hence, anyone could check on the status of the dbspace…
Want to DROP an empty rootdbs chunk
David: From the oncheck output it looks like this is an extended chunk table page mapping your last six chunks. The only way that I know of to clear that would be to drop those six chunks, drop this chunk, then recreate those chunks which will hopefully be able to live on reserve…
A lot of extents in temp tables
Hi everyone, I have many of tables with high extents what can I do to fix it? Follow attached print ox tables and my dbspaces (onstat -d)…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help. Arr ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
stat() failed for chunk file
HI, Check the chunk files exist. Check the permissions on the chunk files and all folders related to the chunk files. Regards, David. ------------------------------ David Williams ------------------------------…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
Undocumented logical log flags
Is it similar to the X flag on onstat –d you see when you add a mirror to a critical space and is only removed after a backup ? Cheers Paul…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
Logical Logs/Physical logs
why not just monitor the chunk writes to the phys & logi chunks with onstat -D for a definitive period of time ... should know very quickly.…
Decrease Size of Root Dbspace
If there are multiple chunks you can drop any uninhabited chunks. Other than that, you are stuck. Art…
down chunk
Informix 11.50.FC6 on HP-UX 11.31 PA-RISC We're working toward upgrading to 14.10 on Linux, but until then, we're running the environment shown above. Since 11.50 is way past EOL, we're kind of out of luck for support from IBM/HCL. If it was a production system, I might try to …
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
how to change the default location of rootdbs
I have installed innovator-c 11.7 with default settings. when I do onstat -d /usr1/Informix/ol_informix1170/dbspaces/rootdbs /usr1/Informix/ol_informix1170/dbspaces/plogdbs /usr1/Informix/ol_informix1170/dbspaces/llogdbs /usr1/Informix/ol_informix1170/dbspaces/datadbs /usr1/Infor…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
storagepool free space recovery
Hello everyone, I dropped a storagepool dbspace using 'onspaces -d' instead of the function 'drop dbspace to storagepool'. How do I return the free space to the storagepool? Is there a function to list the contents of the storagepool? Thanks, Benoît…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Moving Instance
What about chunks? Can you move them to a different directory as well?…
Chunk Files
Where is the best place to put the cooked files? In the informix home directory? This is just an Informix server we are using for training and messing around. Is there a best practice type of thing for this?…
onload questions
IDS 11.50.FC5 Solaris 10 I sent this in a couple of days ago, but I never saw it posted. --- I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace infor…
onload - onunload
IDS 11.50.FC5 Solaris 10 I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace information? How does it know to send the tables to the different dbspaces?…
Identifying dbspaces with auto-chunk addition
Hi all, Does anyone know if there is a way through the system monitoring interface, i.e. an SQL statement run against sysmaster, of determining if a dbspace can add new chunks from the storagepool? There appears to be nothing in sysdbspaces or syschunks. With 'onstat -d' this i…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
IDS not writing to online.log
for tid in $(onstat -g ath | egrep "main=5Floop|onmode=5Fmon" | awk '{print= =20 $1}'); do onstat -g stk $tid done Just in case 'crit' should be in any of these outputs, e.g. wait4critex,=20 check onstat -u for any X flags and proceed from there. 'Weeks' you're saying?? No chec…
Chunk symbolic links
Hi, I have a question about creating chunks with simbolic links: I can't figure it out how it's done. Let's assume that my chunks are on a separate storage. I did ln -s for all chunks to $INFORMIXDIR/storage/chunks but Informx doesn't start after I set the rootpath to $INFORMIXD…
storage pool doubt
Hi and thanks beforehand. Is there a way to split between raws or chunks in the storagepool new chunks added for a dbspace? I dont want all chunks added to be from same disk.…
renaming chunks with ontape?
I would like to replace a drive with a larger drive (with larger chunks). Is it legal to create larger chunks on the new drive, and then use the rename option of ontape to do a cold restore, and use the new and larger chunks, in place of the former chunks? Is it legal to combin…
Negative pages read in chunk
I have some system monitoring that captures pages read from each chunk. This is simply "select fname, pagesread from syschktab" For the most active chunk in the instance this statement returns a large negative number (-1,181,472,262). However an onstat -D returns a larger positiv…
Physical log chunks almost full
Hi, I have a physical log of 2GB, but when I do onstat -d I notice that the free colum is "1179", is it risky if that chunk is full and how can I free the space from this chunk. thanks…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
Adding a chunk
Hi, Is there a problem if I add a cooked chunk to a raw dbspace ? Thanks in advance.…
Database hanging
Hi, I have 60 chunks, one chunk is being write when I launch onstat -D but why the dbaccess mydb hangs, is that logik if there is a slow IO ?…
informix down
Hi informix is down on a backup node (clr), the logs mention a I/O error I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 the chunk number 9 is member of the log dbspace can you help ?…
Dbspace with 2 chunks
Hi, I have a dbspace with 2 chunks. The first chunk is almost full, the second has a lot of space. What will hapen when the first one is completaly full ? Informix will show a 0 on onstad -d command for this chunk ? Enviado desde mi iPhone…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
onstat -d
I am sure it must exist Does someone have a script to give a pretty layout of onstat -d ............. The dbspace, and following that the chunks belonging to that dbspace ? My company decided not to stick to naming conventions, and now I am trying to match dbspaces with chunks …
Chunks Down Help
Hi restore the dbspace from your last archive, if you don't have an archive you must call the support, they have tools to quickly bring up dbspaces.…
End chunk mirror on two serves doing er
Hello: Which one is the best way to end chunk mirroring on two database servers? Maybe, end chunk mirror for root space on slave server and them on master server? And end chunk mirror for other space as final stage. Thank you. --001a113ecbee87c9c5052616cb37…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
Locks not releasing & oncheck
Just to get a basic items out of the way, I would ensure all of your index are valid and that you have run update statistics recentlly. If for some reason the optimizer is choosing a sequential scan, then the locks could beheld much longer than expected. I would run the select b…
onstat -d
Hi, I see a line in onstat -d output that say metadata Size Free Bpages Metadata 17324 4005 17324 I see the free space was drastically reduced when I run cdr commands. My question is, what will happened with that space if it gets empty ? Thanks in advance. --001a11c11a8c11f…
dbspaces corrupted
We have Version 11.70FC4 sitting on a Red Hat 5.9 server that is, in turn virtualised. All dbspaces are on cooked file systems. We had a process that blocked the server using "onmode c block" followed by a level 0 backup using "ontape s L 0". At some point during the backup,…
Offline a chunk
Hi, How to offline a user space/chunk created. I have tried, onspaces -s testDB1 -p /tmp/testDB1 -o 0 -D. But no use. Flags still shows it online. 45ff1028 13 13 0 1046575 1044760 PO-B-D /tmp/testDB1 I am checking restore scenario using onbar.…
Root db space fills up
The instantiated view is approximately 160 MB and the dbspace added is 2GB. It seems that the database doesn't even try to use the new dbspace. I've looked at what is in the different dbspaces during execution of the select query against the view and the temp table appears in the…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
consolidating dbspaces
HP UX B.11.31 U 9000/800 IDS 11.70.FC7GE Good Day, I want to consolidate a number of 2gb chunks into a single chunk. Can anyone advise me on how to do that ? Thanks…
Dropping a chunk
Hi, Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now I like to drop the chunk in this way: onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 What am I doing wrong? Thanks in advance. Enviado desde mi iPhone…
Onstat -d
Hi, Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs has from 2 to 8 free pages less. Why this happend? Enviado desde mi iPhone…
Problem dropping dbspace
A little more information, in case it is helpful. The cause of the corruption is that the raw devices were accidentally allocated to a second instance while still allocated to this instance. Both instances have flagged these devices as offline. The original plan was to drop thes…
onload question
When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the database came from dbspace 1, write it t…
RE: onload question
Solaris 10 - Sparc IDS 11.50.FC5 When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the databa…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Chunk Size
Hi we are running 11.70.FC7 on Solaris 10 and we just got new storage for our database. For the first time our storage admin asked what size chunks we want for our raw DB storage. HIstorically we have always had 2 GB chunks. Any suggestions on a good chunk size for an OLTP system…
Chunk Size
Hello Group, Do you have a recommendation on what to set the raw chunk size? Currently we are using raw devices and are split into 2GB chunks. Our storage admins would prefer to give us larger chunk sizes for future disk allocation and want us to recommend a chunk size. Is there…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Error: DR: Couldn't send add dbspace/chunk request
hi, 92 % occupied - 8 Gb free (maybe a week). Today I run again the command and suddenly it Works (WT?) DCCPLD02:/ifxpld02/chunks$ onspaces -a datos00 -p /ifxpld02/chunks/datos00_16 -o 0 -s 4096000 Verifying physical disk space, please wait ... Chunk successfully added. Now w…
RSS and BLOBs
Shouldn't the L flag not be present in onstat -d output then? 7000000226fd870 10 0x40811 27 2 204800 NLBB informix db Infocenter says L is Being logically recovered.…
onstat -d display negative value
Hi, OS: HP-UX 11v2 PA-RISC, IDS 11.50.FC8 After I done partitoned table my onstat -d on one chunks display -2289488 , what's wrong ? I done oncheck -cDI database:table_name, restarted instace and no result ... ..... Chunks address chunk/dbs offset size free bpages flags pathnam…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
server migration from windows to linuxu
hello: my doubt is about chunks. can i copy chunk files from windows to linux? can linux manage right chunk files from windows? my doubt is about to export data fully with two informix v11.7 from windows 2008 64b to linux 64b. thank you and regards. --047d7bb04cf2188a3904d02c…
Adding chunks ISAM error 137
Chunk table overflows are virtually impossible to occur in v11 unless you have over 32k plus something chunks allocated. Sounds to me like there is some corruption in the Informix reserved pages , run on oncheck -cr to see if all your chunks are listed/any errors reported and che…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
LRU Queues - more or less
onstat -F shows 0 LRU Writes 8314165 Chunk Writes…
location of physical log/dbspaces
Hi all I have a situation here where the previous DBA leave the company and do not document any setting. Checking with onstat -d command does not give us any clue where the actual physical log location. I been using onmonitor -->Parameters-->Physical Log to check for actual lo…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
onbar dbspace restore with fragmentation
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver halted at a checkpoint. When I forced it to continue, the instance remained online but an entire dbspace with constituent chunks …
how to get all the instance's chunks free space
I created several informix server on a host. To monitor each server's chunk space,I have to setup environment parameter then run 'onstat -d' to check the chunk's free space. Anyone can write a shell script that get all informix server's information ( like 'onstat -g dis' do) and…
onstat -g ath
if ! kaio && ! auto aiovp then check to see if you have enough aiovps configured. onstat -g iov , the last few should not be relatively busy (< 1.0 i/o per sec.) usual suspects : check for hot spots on disk (onstat -g iof; onstat -D). check for seq scans (onstat -g tpf | awk '…
dbpaces
hi, i want to copy using sql a table from 1 dbspace to another dbspace . Is this operation possible with ids 11.50? exemple: insert into dbpace1.database1.table1 from select * from dbspace2.database2.table2 thank's for your help…
LOGSIZE change not being picked up
LOGSIZE is the default size when creating logical logs. Once the logic= al logs are created you must drop and re-create them if you want to change their si= ze. John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) (Emb…
Informix 10.00.TC5 CKPT REQ Logica Log Full
My ONCONFIG file has already DYNAMIC_LOGS set to 2 so I expected that Informix creates more logs when necessary. But It's not working. I supposed that my logical log DBSPACE was full but onstat -d says 97997 free on the last chunk, each chunk is 500000 sized. Thanks…
how to calculate the label 0 backup file size
How can I know the backup file size after running 'ontape -s -L 0' . Can it tell from output of 'onstat -d'. Or select some information from sysmaster .…
Drop DBSpace
Hi experts, I want wo drop a dbspace, which we have been using for some byte columns as blob store. Now, we added a smartblob space and copied all the values to a blob column. The whole table was copied and access to the new table works good. Old table was dropped now. We want t…
Onbar's Handling of "Empty" Chunks
How does onbar handle "empty" chunk files during backup and (especially) restore? Is it intelligent enough to determine that a chunk contains no data at all and can be handled differently (perhaps more efficiently?) than one that contains user data? Or is this an irrelevant co…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
Performance Issues
Just a few thoughts, the answer to your question is here: 1. You are on HPUX which has some unique property. First is its abilit= y to downgrade a process if it deems a process is consuming to much cpu cycles. Since Informix has one process for many many users the Informix cpu v…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
ontape -p/r with changed ROOTPATH
Thanks Paul, that worked The previous time I was trying -rename option I somehow missed the note that I have to specify all the chunks instead of just the first ... Is there a way of getting a list of the chunks from L0 file or should I create it using onstat -d on a source (liv…
need to know when was a dbspace went down.
Hi All, I would like to know when my dbspace went down... I didn't find from the log... is there a way i can find from the systables? 70dc0318 10 10 0 524287 0 PD-- /chunks/chunks024_device0000 70dc0498 11 10 0 524287 0 PD-- /chunks/chunks024_dat0102 70dc0918 14 13 0 512048 0 P…
dbspace planning
Hello, I have only 4-300GB SAS 10K RPM drives that are mirrored across 2 channels. I'm using RAW devices. Any suggestions as to optimal dbspace layout in this IDS 11.7UC1GE instance on RHEL5.5 32-bit for OLTP? I'm planning layout below: disk 1. rootdbspace, phys log, logical …
syschunks.nfree and 'onstat -d' free column
Hi over there, Can someone explain why the 'select' statement on sysdbspaces,syschunks gives different value than that on free column of 'onstat -d', knowing siglobdbs1 is a lob dbspace (see below) select name[1,9] dbspace, chknum, chksize, nfree from sysdbspaces d, syschunks c…
Performance advantage: fragment across dbspaces vs. in single space
Is there any advantage to fragmenting across multiple dbspaces instead of simply fragmenting in the same space? Aside from performance, are there any other reasons to fragment across dbspaces? Using IDS 11.50.FC4 on HPUX 11.23.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
onunload dbspace handling
Does onunload/onload handle variations in dbspaces? That is: 1) If I onunload a database which resides in 2 dbspaces, can I onload it into another instance with differently named dbspaces? If so, what is the command line syntax? 2) Can I onload a database which resided in 2 d…
Number of dbspaces
Hi, I have a database of 250 GB of user data. How many dbspaces is suitable for optimal performance: - For OLTP transactions ? - For queries ? - For backup using onbar ? Currently, I have 30 dbspaces configured. Is there any strategy or tip that I can use? Please, provide any i…
IDS v11.10 hang: no error / logicalLog not full
What's the output from onstat -d and onstat -D? If you have ONDBSPACEDOWN = 2 set in your onconfig, and a dbspace fails, the engine will hang until the device is available again. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Be…
HDR secondary move
Dear All, We are moving a server having Informix secondary server from one data centre to another. It is a 5 day process. Version 7.31 , OS HP-UX 11.11 While bringing up the Secondary instance I will check the following: 1) Check for last logical log in the secondary (in onli…
Cannot open chunk ''
The errno - 2 says there is a chunk that does not exist. Try oncheck -pr. It will either point you to which onw it is or fail if it is the 1st chunk.…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Raw Devices
Currently we are using our database on IDS 11.50.FC6 and our dbspaces are on UFS file system.Can we transfer our existing dbspaces on raw disk and how we do it , Also how much down time is expected.…
Extent and DBSpace
Hi, I have a database space issue due to the 2Gb limit on a DBSpace. How do you force the next extent of a table to be on another DBSpace. Thanks Andrus…
SMI table to read the 'onstat -P' information from
Hi all, I was wondering if there's a way to read the 'onstat -P', i.e. the 'Print partition buffer summary' information from a SMI table? I wrote a script to print out the contents of the buffers, but it would be more elegant to be able to do everything on SQL, instead of having…
How to calculate page size + chksize into bytes, m
chknum smallint Chunk number dbsnum smallint Dbspace number nxchknum smallint Number of the next chunk in this dbspace chksize integer Number of pages in this chunk offset integer Page offset of the chunk in its device or path pagesize integer Page size (in units…
Dbspace recovery
Hi, I have started testing revovery of a singe dbspace or all. The senario is that the server that the IDS was running on is completely gone and we have to restore a backup from the backupsystem (we use Veritas NetBackup) to a new server/host running the same IDS version (for ti…
RE: corrupt index dbspace on IDS 9.4
I've never seen that, no. Art=20 -----Original Message----- From: LARRY SORENSEN <lsorensen25@msn.com> Sent: Wednesday, February 24, 2010 3:17 PM To: ids@iiug.org Subject: RE: corrupt/space down index dbspace on IDS 9.4 [19119] So, has no one ever run across an index dbspace g…
onbar restore hanging
Hi, Do onstat -g iof moving or not on individual chunks? rgds schillache…
Re: On Dropping chunks
Reorg the tables in this dbspace so that all of the free space is in the last chunk which should not have any TABLESPACE entries in it. Then you can drop the last chunk and add it to the other dbspace. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board o…
On Dropping chunks
Hi there. I have the following question. Can I drop a chunk which is not the initial for dbspace, but it's not the last one either? Because I am in this situation: the second of three chunks on the same dbspace is empty according with Server Studio, but with TBLSpace entries …
chunk offline
Hi All, We had a situation were a non-critical chunk went offline. This was a cluster setup and during some testing/disk alignment by Unix, this chunk went offline. It was marked PD. This chunk contains only a portion of one Index.( Checked before using oncheck –pe ). Used onspa…
how can i delete a bad chunk??
ids9.4/linux32 after a chunk bad,i want to delete it i try $ onspaces -d dbs02 -p /spsdb/chunk202 -o 0 WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: Chunk not empty so how can i delete this bad chunk force??…
Re: Large chunks versus small chunks.
> > I'll see if I can rustle up the disk testing tools because it would be > interesting to see the results from contemporary machines or arrays. I can't find my stuff - stupidly entrusted it to a geocities hosted web page which has been absorbed by Yahoo and now thrown away. H…
Large chunks versus small chunks.
All, I would like gauge opinion on whether or not it is better, worse or does not matter if you use fewer larger chunks or more smaller chunks. I am trying to find out if you have any experiences or better still evidence that chunk size matters. I not over concerned about the am…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Raw devices softlink to dbspaces were lost
You have an onstat -d output? then you have the link paths... unless I am misunderstanding you. MM…
Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx…
Curiosu about a message in bar_act.log
What does this message mean in bar_act.log? "n percent of [dbspace name] has been backed up."…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
what is the 0x40000 meaning
0x040000 means Blobspace contains Big Chunks…
Re: Moving dbspaces to larger chunks
Hi Kagel, Is it possible to move/migrate rootdbs(root chunks) also from small chunk to large chunk? rgds schillache…
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
WARNING: Next backup of DBspace rootdbs must be le
Hi, thanks for answering, yeah we add chunks to dbspaces, but we had not added chunks to rootdbs y physical y logical logs dbspaces. For example today and May 26 i added chunks to normal dbspaces and we didnt get the WARNINIG NEXT backup message. What other reason it could cause …
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
Adding BLOB Chunks to DBSpaces
>My question is I added the following chunk to a dbspace using the following command. > >onspaces -a dbspacename -p /dev/mapper/rawpartition -o 8 -s 5120000 > >How come now when I run onstat -d update it shows the chunk as half the size? 2560000 KB. > >Size Free >185f9328 9 5 4 2…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Informix page cleaners (w/ a SAN)
James, are you experiencing any issues, long checkpoints maybe? You have 90ish chunks and 128 CLEANERS. During checkpoint each cleaner gets assigned to one chunk (in the order of chunk creation) so you're on the safe side there, the extra cleaners should just idle. Regards Dav…
how to save the removed chunks by mistake
Someone want to drop a dbspace and remove the chunk file by mistake. Server can not restart owing to the down chunk. Can not drop dbspace or chunk by 'onspaces' or 'onmonitor'. Any way to solve this problem ?…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
rename chunk's
Hi all: I need to change the PATH of all my chunks in my body. For this I must do the following: 1. backup online full: $ ontape-s-L 0 2. rename file to create chunks: -- sintaxis: old_chunk old_offset new_chunk new_offset archivo_rename.txt: / usr/informix/devices/chunk1 0 …
temporary table display problem in 'onstat -g sql'
Please provide the output of onstat -d from these two instances…
ontape -r suddenly very slow
During the restore, using onstat -D, see if you can determine a specific dbspace/chunk that is having issues. Mike…
Dbspace creation
Hi, I have 3 hard disk partitions hda5, hda6, hda7. I would like to create dbspace in each of this file system partitions. hda5 - dbspace1 hda6 - dbspace2 hda7 - dbspace3 We wish the dbspaces to have the size equivalent to the partition size. I have created the dbspace1 usin…
How can I resize a chunk?
Hello, is it possible to resize a chunk? I know i can do it the long way by exporting the data, drop tables, drop the chunks, create new chunks of smaller size, recreate dropped schema, import data. However this is a very long, convoluted and error prone process. So does anyone …
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
onstat -d output for mirrored dbspace
To All, Wondering what the normal onstat -d output is for a rootdbs that is mirrored? The flags for the primary is: "PD-" and my understanding was that "D" was a down chunk, but don't know if that's normal in a mirrored env. There are no errors in the online.log for a down chunk…
Script to build dbspace from onstat -d output
I was wondering if anyone has a script that will take the output from a onstat -d command and a output script of onspaces commands to build a new instance. Running Informix 9.4.FC9 OS- Solaris 8 Thanks for any information Bruce Simms Data Base Services TALX Corporation 2330 Ba…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Re: Copy Informix Chunks using dd ?
> Jarrod, > How can I change the status of Mirror chunk as Primary > chunk ? > -- D mirror the whole dbspace in question. bring down the chunk you want to move using onspaces.(primary) relink the chunk to be moved to a new unused raw device.(make sure permissions are o…
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Migration to a new storage
We will use a new storage for dbspaces. How I can migrate data from old storage to new the new storage. Can I use ‘dd’ for it? I will move dbspaces by ‘dd’ and re-link my dbspaces on new storage.…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Is there a downside to creating large chunks?
I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 tables. I want to spread these across 8 dbspaces. Is there a disadvantage or advantage to creating 1 chunk per dbspace initially? Thanks, Andy…
Analysis of activities during checkpoint.
"If you are using a few large chunks instead of a larger number of smaller chunks, you will have only one flush thread per chunk running at checkpoint time. More chunks means more flush threads means less time to flush." Dang, is this still true as of 10? We may have caused our …
Re: Do You Use blobspaces?
We have experimented with various sizes, but lately we have been making them the default size simply as it makes the onstat -d update much easier to look at. Not a real great reason, I know. > > What is the page size of the blobspace ? > > Cheers > Paul…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
Full Proof way to determine if ontape is restoring
Onstat -D or onstat -g iof are the only ways to monitor the progress of a restore, unfortunately. Art S. Kagel Oninit On Mon, May 12, 2008 at 3:47 PM, WILL LANDSTROM <willlandstrom@yahoo.com> wrote: > Hey sorry for this basic question. IDS 9.4 databases. When I run ontape -r >…
understanding oncheck -pp
Yes, chunks can be shared by multiple instance on same machine. I tested that IDS supports it. My machine is on local disk and there is no chunk sharing. Thanks to you and apologies to Art. vartika.…
chunk is down
My box is aix 5.3 , ids 10 FC3R1. I start my ids and run 'onstat -d' 700000031d801c8 14 10 0 512000 0 PD-B /dev/ rtmpdb1 tmp dbspace is down. $ ls -l /dev/rmptdb1 crw-rw---- 1 informix informix 10, 20 Feb 25 13:39 /dev/rtmpdb1 owner , group name…
Real simple onspaces question?
I have a very simple onspaces question. I know, newbie here. I did try finding out the answer in some manuals and books I have but believe it or could not find a definitive answer. Anyway....with IDS 9.4 to bring up a Primary chunk that is offline the syntax is.... onspaces -s DB…
onstat -g prc
Thanks John. We haven't got to those good stuff of version 11 yet, the customer resists the change -- guess we're a little behind. Now you are openning to another discussion: OpenAdmin Tool, how hard is it to use it? any quick document to look at? Kern -- ----- Original Message …
IDS11 startup problems
Are you getting anything in your o/s system messages? How about in '/usr/local/ids/tmp'? The 'oninit -yv' output shows your informix DUMPDIR in onconfig is set to '/usr/informix/tmp' which the output says does not exist so it is using '/usr/local/ids/tmp' as DUMPDIR. Maybe there …
determine current transaction buffering mode?
Run the following script will list all database and their logging mode dbaccess sysmaster -<<END select * from sysdatabases order by name; END OUTPUT of script =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Database selected. name stores_demo partnum 1048799 owner jmiller c…
Re: Monitor sessions
>> onstat -g tpf | tr -s " " | sort -nr -k 16 | head > onstat.tpf.out >> for i in `cat onstat.tpf.out|cut -d " " -f1` >> do >> if [ $i -gt 0 ] >> then >> echo "------ LOGICAL LOG $i START" >> user_add=`onstat -g ath|grep $i|tr -s " "|cut -d " " -f4` >> if [ `…
Detecting unujsed indexes *NM*
Also might want to look at onstat -C part This will tell you how many times the index was used by the engine to position on a specific value along with how many compresses and splits have been done. I like onstat -g ppf like art mentioned but it will only work if you have detac…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Moving a chunk from one logical Volume group to another.
I need to move a chunk from one logical volume group to another. I am running IDS 7.3 on HPUX 11i. My chunks were created using links to logical volume groups. Is there a command I can use to move the chunk.…
IDS 9.4 and Indexes
Richard: They pieces of information I find useful when looking at indexes are: 1. sysmaster:sysptfprof or onstat -g ppf this will tell you how many locks and how many items have b= een read from this index. It currently will not tell you how m= any add or deletes. 2. onstat …
Rename Dbspaces
Hi All: I can rename logs dbspaces online ??? Thanks _________________________________________________________________ Regístrate en el nuevo Windows Live Messenger beta. [1]¡Haz click aquí! References 1. http://g.msn.com/8HMAESAR/2734??PS=47575…
Chunk not dropped. ISAM error: No such chunk
I've performed this drop chunk command and process several times in the past, but this time I'm receiving an error. Do you see anything wrong or is there a bug. Hopefully the chunk will still be written to once the main chunk is full: IBM Informix Dynamic Server Version 7.31.UD8…
Fragment by partition
Version: Informix 10 I have couple of questions regarding fragment by partition in same dbspace: 1. Is there any limitation as to how many partition a dbspace can have. 2. Is partition name unique to dbspace or unique to index/table. Logically it should be unique to dbspace as …
Informix on iSCSI
That is, having the chunks on an iSCSI device. Any thoughts?…
HDR - Adding chunks
You need to add chunk only on primary. But make sure that the chunk path exists on machine where secondary reside. For better performance you should also grow the file on secondary to required size before adding chunk on primary.…
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
ontape or IDS problem
> - Adding over 3 TB of chunks to the blobdbs. potentially it does something really inefficient trying to locate blobs in empty blobspace chunks. how many of those 3TB chunks are empty?? Suppose you have 20 empty chunks, i would drop in that case 18 chunks and look if your pro…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
chunks overlapping?
Yesterday our system went down with the log file showing this below: quote 16:18:33 Informix Dynamic Server Version 7.30.UC6 Software Serial Number AAC# J540938 16:18:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. 16:18:35 Physical Recovery Started. 1…
renaming a chunk
Hi, We are using IDS10.0FC5 We would like to rename a chunk to satisfy a link checking script that we have running on startup. It seems that the recommended ( apparently only available ) way is to do a rename during restore. That is not an option for us. I was wondering if it wo…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Adding new chunk/free up used chunk
Hi, I am currently having a table that is stored in rootdbs and it almost used up all the available pages inside that space. So I decided to add a new chunk to it but it was unsuccessful. The error given is: Cannot add a new chunk to the DBspace. ISAM error: no free disk space …
Adding a Chunk
I was wondering, when you add a chunk to a dbspace that is already using part of the raw device and need to specify an offset is the offset expressed in pages or kilobytes? Thanks…
Dbspace script
Hi, Is there a script or utility that can review your current layout of dbspaces and then create a script of "onspaces" commands to duplicate the environment?…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Anybody seen a very fast wild cat out there?
On 18 Feb, 18:41, Fernando Nunes <s...@domus.online.pt> wrote: > d...@smooth1.co.uk wrote: > > > Yes, can we get these in the documentation? And a way to view all > > this information via onstat/SMI? > > Check onstat -g iof and onstat -g ckp (new option). I believe (may be wr…
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
Listing all the tables in using a dbspace in Informix
Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V…
Primary/Mirror Issues
Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this ag…
Lost my database
Have you run dbaccess to see if actually if yours databases are GONE ? What are the status of chunks in dbspaces bring the result of : onstat -d…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Determine which tables and indexes are in which dbspaces
I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the indexes are in the same dbspace. I know have some indexes in dbspaces that have tables in other dbspaces and want a query that will sh…
temp dbspace
Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or …
Onstat Reference
It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11 changes will be in place when the V11 Beta goes public. I'm happy to be told where they are wrong. If you like it then use it, if you …
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
mirroring dbspaces
Hi all, anyone having experience with mirroring ? I inherited an informix config from a former collegue, and it looks very strange and insecure to me. In short : system running Solaris 8, 2 disks. All slices EXCEPT slice 6 (used for Informix raw-devices), are mirrored with Sol…
record locked
a combination of onstat -k and onstat -u…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Can't drop down dbspace
I've been restoring a development database from very old backups (long story). Due to errors doing a full DB restore, I restored the critical dbspaces and 1 user dbspace. Logical restore of the next dbspace fails in the same logical log, probably due to a corrupted index. So that…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Quick Ontape -r rootdbs question
Hi, If you attempt to use the ontape -r with redirection of the chunk names parameters for a specific database, is there any effect on rootdbs for the other databases? In other words if we have a 2 server set up described below and restore one dbspace, will ontape also restore th…
TEMP DBSPACE
Hi we have two quries like below create temp table tmp_table_no ( sl_no serial, lang_a char(2), lang_no char(14), rec_cnt integer) with no log second one is insert into tmp_table_no (lang_a, lang_no , rec_cnt) ", select distinct language_a, lang_no, count (lang_no) from ti_lang…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
who locks a record?
onstat -k followed by an onstat -u…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: Long checkpoint woe
Make sure the KAIO is working. onstat -g ath | grep -i kaio will show if kaio is working, you should have I kaio thread for each NUMCPU defined in your onconfig. Does onstat -g ioq show any values in the "len" and "maxlen" for any gfd's? Post it if unsure. Post onstat -d and ls…
Chunk space
Hi, Sorry for my poor english. And yes, im newbie width informix. I run this: copy nul filechunck.000 onspaces -c -d namedbs -p c:\\infxData\\infxserver\\filechunk.000 -o 0 -s 2000000 .... and all is ok. But when ... oncheck -pe ... Chunk Pathname …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
RAID 5 hardware and different dbspace ?
Is there a interest to separate tables on different dbspaces if disks are managed by a RAID 5 hardware…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
drop a chunk in v10
I understand that enhancements have been made to V10 so that you can control the tblspace tblspace and thereby reduce some of the situations which lead to not being able to drop a chunk. But is that all situations? What about if some extents of one of the system catalog tables …
Increased extent size, but still hit max extents
The table is in a DBSPACE of related tables. Other "schemas" are in their own dbspaces, and each dbspace has its own group of chunks. Can I infer from your question that if Informix can't find a 20M contigous area, it will just choose the next larger? Which would imply that I ne…
Re: Informix questions
What he said.... I believe onstat -d shows an S against smart blob spaces.…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
dbspaces/tempspace shows up with a "B" flag
The database server has been enabled to use chunks >2Gb. These dbspaces probably use large chunks (greater than 2Gb).…
Temporary dbspace
Many of my current systems have just one temporary dbspace. Is there any mileage to be gained by adding a second temporary dbspace on a multi-processor system but with only 2 disks which are mirrors of each other? Some reports and queries are not performing as well as they did …
Chunk Not empty
Hi, I am trying to drop a dbspace (named conversion). That dbspace originally was consisted from 10 chunks (conv_dat.000 to conv_dat.009). I have dropped successfully up to conv_dat.005 chunk. When I try to drop conv_dat.004 chunk (using the onspaces -d conversion -p E:\\\\IFMX…
Re: ipload hangs
Possibility for errno = 36 in online log could be an operating system error message OR the database server exited without shutting down properly OR a chunk(s) down. Run oncheck -pr and check the chunk reserved page to determine if any chunk is down. Hari…
Relocate Informix database from Raw slices to filesystem
Thats sounds promising. So effectively add a mirrored chunk to each dbspace using onspaces and then drop the original chunk. Can you do this for the rootdbs dbspace too...? Matt…
Re: Failed Import, ISAM 172 Error, Corrupt Indexes
well you are getting I/O read errors on chunk 9... onstat -d ...what is chunk 9? What platform? Can you do dd if=<chunk 9 path> of=/dev/null bs=1024k count=10 ? Are the permissions on chunk 9 ok? Owner informix group informix, mode 660…
Maximum number of chunks in 9.40, 2047 or 32766?
Hello everyone, 1) Version 9.40 still limits to 2047 chunks (onstat -d shows this figure), that is true, my test has confirmed that. 2) When issue onmode -BC 1/or 2 -- onstat -d shows 32766; however, my test of adding chunks always fail when the number of "active" from onstat -d …
Long checkpoint duration
During the checkpoint, do you see activity from the flushers? Does onstat -F show them active. Do you see write activity for those guys with onstat -u? Do you see chunk writes with onstat -D? What's your checkpoint interval? lru max dirty? lru min dirty? How big is your phs…
Chunks down
Hi, I have a dbspace named calms13_dbs and a number of chunks in that. SOme of which have become down with status PD. I have 3 databases in that dbspace .I have some questions here. 1. How can i know reason for the chunks going down? 2. When i drop the database in that dbspace, …
Error Dopping Temp DB Space
How does it show up on 'onstat -d update'?…
Re: Change chunk name
on 7.31? thought you could only drop chunks on 9?…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
One Chunk vs. Many Chunks
Hello All We finally upgraded from 9.21 to 9.40. We are planning to add two 50 GB dbspaces to an instance. There are already many dbspaces in this instance and most are around 50 to 60 GB. One dbspace is 256 GB and we are trying to rearrange the data so we can reduce the size of…
Database and no dbspace
Help. The dbspace is drop but now the database can't be drop. How do I drop/remove the database. I have created the dbspace but no luck. error: 311: Cannot open system catalog (systables). 135: ISAM error: TBLspace does not exist…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Transaction Rollback
onstat -x…
how to find a dbspace for a table
Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. T…
large chunks
Is anyone running IDS 9.4 on a SAN with large chunks? Is performance satisfactory? sending to informix-list…
large chunks
Is anyone running IDS 9.4 on a SAN with large chunks? Is performance satisfactory? sending to informix-list…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
dropping chunk
Hello all, IDS9.40.FC4 HP-UX 11.11 I have successfully dropped an empty chunk from the database and tried to allocate it to another dbspace (after a Level 0 Archive) I am getting the message "The chunk specified already exists.". However, when looking for the chunk using "onsta…
onstat -D output
Hello, We have a table that we know has has no less that 10k rows added to it since yesterday. Yet, when I do an onstat -D on the chunks that the table is stored in, it shows zero writes. Is there some bug I don't know about ? Or is there any way that the stats could have been ze…
chunk access
Hi, The chunks are created with user and group informix. Theoritically only users in this this group should be able to access the chunks. But i have created a user "dummy" which is not in informix group. THis user is still able to access the data in the database. How is this poss…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Complete Backup on Windows NT
> Quick question, after adding new chunks, do I have to do anything to > ensure the database server uses them? After you add chunks with onspaces server will use then when needed. You can not really control which chunk will be used by server. Best regards, V.K.…
RE: semaphore tuning
This is a multi-part message in MIME format. ------_=_NextPart_001_01C4FF55.C0AA05EA Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Floyd, =20 >>Informix9.4-UC4 on Solaris 9 =20 =20 UC4?... that's a 32Bit version. you did not…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
Big Chunks vs Small Chunks
Hi, All We just upgraded our data warehouse database(1TB) from 7.31FD2 to 9.40FC2, the instance is running on a partition of HP Superdome attached to EMC storage with 8GB memory cache. There over 500 2GB raw logical devices allocated to the instances with in 66 dbspaces right now…
RE: script to rebuild dbspaces from onstat -d
here is the script to generate the onspaces statement from an existing = instance, hope it helps FILE=3D/tmp/spaces dbaccess sysmaster <<! set pdqpriority 0; select d.name, d.is_temp, d.is_sbspace, c.fname, c.chksize * 2 chksize, c.offset * 2 offset, c.mdsize * 2 mdsize from sys…
Re: script to rebuild dbspaces from onstat -d
sumGirl wrote: > > I need to duplicate my production environment on a new system. Anyone > know of an easy way to take the output of my onstat -d (or maybe > something else I dont know about) and setup my dbspace structure on > the new system prior to my restore? The very good S…
Re: script to rebuild dbspaces from onstat -d
On 14 Oct 2004 16:14:50 -0700, emebohw@netscape.net (sumGirl) wrote: >I need to duplicate my production environment on a new system. Anyone >know of an easy way to take the output of my onstat -d (or maybe >something else I dont know about) and setup my dbspace structure on >the…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: any way to know the progress of a level1 (or level0) ontape save?
"sumGirl" <emebohw@netscape.net> wrote in message news:a5e13cff.0409151450.245785df@posting.google.com... > Just wondering if anyone knows of a way to check the progress of an ontape backup? If you zero out the stats with onstat -z then do an onstat -D you can see which chunk it…
Warning: Invalid (non-existent/blobspace/disabled) dbspace listed in DBSPACETEMP: 'dbtemp4'
Also, check onstat -d and look for flags col to see "T" against dbspace. As Jonathan advised you might be using dbtemp4 either in ONCONFIG or in env. variable. Possibily dbtemp4 has not been created as TEMP dbspace ( -t switch with onspaces). If you don't need this then remove it…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
virtual memory segments added
onstat -g mem displays the pool names (first column) onstat -g afr <poolname> displays the allocated fragments by address. If you run onstat -g seg, you get the logical address of the shared memory segments. Somthing like... for f in `onstat -g mem | cut -d ' ' -f 1 ` do o…
How to find the creation date of a chunk ? (not a dbspace, a chunk ?).
--0-2003821237-1092088394=:10165 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Tha…
onspaces -m ... -f parameter
Found it myself - by trying a guess at the format, if you are wrong it tells you what the format should be. For every chunk in the dbspace to be mirrored you need a line like this: primary-chunk-path offset mirror-chunk-path offset…
dbspace down
I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore the database and make the engine online. Any inupt is highly appreciated, thanks Mukund sending to informix-list…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
How to find the creation date of a chunk ? (not a dbspace, a chunk ?).
--0-504143858-1091557308=:68591 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Than…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Logical logs from rootdbs to own logspace
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?…
Adding chunks
I'm a long-time developer who has suddenly been handed a DBA hat to wear. I understand I should make a link to some raw disk space and use onmonitor to add the chunk. What I'm unclear on is allocating the raw space, and I apologize in advance since this may be more of an OS (AI…
Down chunks
Client is suffering from chunks being marked down due to incorrect ownership and permissions on some of the chunks. Some meathead must have gone in and changed them. Will they be able to get the data back once this has been corrected? Any clues how? (It didn't work when I tried …
Sizing a database
Quick easy question ... I presume.... We are looking to migrate a database from one server to another - what is the easiest way to determine the size of the current database? Is it as simple as 'onstat -d', adding up the number of pages for each chunk & multiply by the page size…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
RE: Performance advice
On Thu, 22 Apr 2004 03:00:06 -0400, Willem Roos wrote: > I've been led to believe that all logged temp table activity goes to rootdbs > and all unlogged activity goes to temp dbspaces. Yes, no? <SNIP> If there are no 'normal' dbspaces listed in DBSPACETEMP then logged temp tabl…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Do I need more KIO's
You've got virutally no buffers, only 6000. Without knowing how much memory you have in the box I look at running this to 50000, or even 100000 and see what happens I'd set the tapeblk to 1024 instead of 16 Do you really want your logs to be thrown way? ltapedev = /dev/null I'd…
Informix data files interchangable btw Unix & Win?
Hi, What kind of Data Files ? (DB Chunks ?). If DB Chunks, it's not possible. Try DBEXPORT and FTP to Windows and DBIMPORT or (table level) Unload to file Load from file or (replicate transactions) Use Replication (CDR)…
Onstat -D / onstat -u mismatch
IDS 9.21.UC6, Solaris 2.8 building an ETX index, into logged smartdbs, onstat -u shows the nreads column ticking up. The nwrites is remaining at zero. Onstat -D shows heavy reads on one smartdbs where the data is, and heavy writes on smartdbs where the index is heading. onstat…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? Thanks.…
move a chunk
hi, we have to move location of all chunks (root, tmp, data,...), how can i do that ? thanks…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
dbspace destroyed
Hi! On one machine dbspace was destroyed by unwary sysadmin who repartiioned disk with informix chunks on it (raw devices). Now, informix can be started (it complains about missing chunks though). What is the procedure for removing staled information for chunks? I should remov…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Dropping a dbspace
I have a bad dbspace I wanted to drop (and recreated). But I have some problem. Here is the output form onstat -d: 5010c7d8 1 0x20001 1 1 N informix dbroot_test3 5020dcb0 2 0x20005 2 1 ND informix dbdata 5020de00 3 …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux
"Colin Bull" <c.bull@videonetworks.com> wrote in message news:btmcr4> That will make it a lot tidier, should be able to use a case statement. > I will revise next week sometime. > http://www.smooth1.demon.co.uk/ifaq06.htm#6.33 6.33 What status codes does onstat return? On 21st …
What is in my dbspace
Try oncheck -pe. This will report the contents of all dbspaces/chunks.…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Re: chunk removal
TBP wrote: > > Geezer From Freezer wrote: > > I've added a chunk which I think may be too big. Now the chunk "new" chunk is > > part of an existing dbspace. It seems that 3 blocks are used (this always seems > > the case when adding a chunk anyway) and no other data has been allo…
RE: chunk removal
Yes, this chunk can be removed without corrupting the dbspace. When you add a chunk to the system 1 page is allocated for chunk free list page and 2 pages are reserved. sending to informix-list…
chunk removal
I've added a chunk which I think may be too big. Now the chunk "new" chunk is part of an existing dbspace. It seems that 3 blocks are used (this always seems the case when adding a chunk anyway) and no other data has been allocated to this chunk. Can I remove this chunk without c…
Re: IDS 9.4 onstat -d output
Hi roger. Your chunk can not exceed 2GB. If you will execute onmode -BC [1|2], then your chunk can execeed 2GB. More detail. http://publibfi.boulder.ibm.com/epubs/pdf/ct1syna.pdf (3-34) http://publibfi.boulder.ibm.com/epubs/pdf/ct1ucna.pdf (1-9) -- Tsutomu Ogiwara from Tokyo J…
IDS 9.4 onstat -d output
Is anyone can tell me, when I issue 'onstat -d' on IDS 9.4 It display like this: Expanded chunk capacity mode: disabled what it means.…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
moving the physical log
According to the IDS 9.4 docs, I can move the physical log like this: set IFX=D:\\IFMXDATA\\ol_bronco copy nul D:\\IFMXDATA\\ol_bronco\\physpace.001 onspaces -c -d physpace1 -p %IFX%\\physpace.001 -o 0 -s 8192 onparams -p -s 8192 -d physpace1 -y ontape -s -L 0 The IDS bitches o…
onstat -d anomaly
Yesterday I upgraded a server on 9.4 demo to the actual 9.4 . I had backup up the spaces to another disk(root,data,physical,logspace,tempspace). (This is cooked space on win2000.) I let the install replace all files. Then I restored the spaces with COPY. Then I changed ONCONFIG …
IDS 7.3* - Long long long checkpoint !
I've noticed very long checkpoints in the online.log file. What does IDS do in a checkpoint that can take so long ? Environnement: IDS running on NT 2000 or Linux (even SCO !) with at least 128MB RAM, monoproc. IDS is usually the only big apps running on the box. "Small" databas…
chunks down
Hello, I am using Solaris 7 (sun4u sparc SUNW,Ultra-4) and running Informix Dynamic Server 2000 Version 9.21.UC1. In the period from 22nd Sept to 3rd Oct 6 chunks went down - fortunately Informix mirroring switching seamlessly to mirrored chunks (which are now online). Among th…
big dbspace
Hello, I need a very big dbspace (at least 15Gb) for my database (IDS 9.4) but the limit for a single dbspace is about 2Gb. How can I increase this limit? thank you…
DROP Chunk
Hi, We added some weeks ago - successfully, thanks to you all ! - a new chunk to a dbspace. We tried to drop this chunk using "onspaces" command but he said "no such chunk !" ... :-( It seems the corresponding file has been removed in between : is it possible to drop the chunk i…
break one dbspace in to two dbspace
Hi all I have one dbspace where I have all data and indexes I wanted to created one more dbspace one dbspace has the data in it one dbspace has the indexes in it how do that ? regard sending to informix-list…
Mirrored Chunks ....
I need to change my Primary Chunks to Mirrors and vice versa, to get my primary chunks on faster disks. I can always archive, change device links and restore. Is there an easier way? Thanks.…
Dropping chunks
Hi, I have created a copy (gemsnew) of a database (called gems), renamed the = gems database to gemsold and renamed gemsnew to gems. Thanks for your = help. They reside on different dbspaces, protodbspace and gemsdb1. I now = want to drop the chunks from gemsdb1 and also the dbs…
Re: Multiple Temp dbspaces
You might want to check your DBSPACETEMP entry - it looks from your post like there's white space between the dbspace names - Informix will stop parsing at spaces, tabs etc. and will only pick up the first dbspace listed. HTH -- Phil@oninit.com…
Onstat -d output for 32bit 9.40 version (9.40.UC*)
Can someone provide me the output of the onstat -d command for a 32 bit version of 9.4? Thanks in advance.…
Re: dbspace ?
Where do we all begin? A dbspace is an area where databases, tables, etc can be stored. It is not just one file, it is more likely to be a number of files or more likely devices. When a database is created it will have a base dbspace where all tables will be created unless othe…
dbspace ?
Hi, Sorry, I am a little bit new in Informix. We need to modify the structure of a table, and the system allways answer that the disk is not big enough. They say it's because the dbspace is too small. Questions : - is the Dbspace a file or just allocation ? - is there ONE dbsp…
ontape - All pages or just used pages
To calculate the size of a dump, do i take all pages on all chunks or just used pages in chunks ?…
Resizing chunks
Ok I have 6 chunks on a system that use only 25% of an available disk partition. I want to resize to use all of the disk partition Can I do this without interrupting the data. Note: each disk partition is only being used once at the moment. OR do I have to backup, delete, recr…
Is there a 2gb dbspace limit NT 4.0, IDS 7.3?
Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?…
Re: Disks for informix
Mark, According to onstat -d, none of the other chunks have an offset (well they do but it's 0).…
Rename a dbspace
Hi, Does someone know an easy mean which permit me to rename a dbspace contening just a separated index ? Thanks in advance. Best Regards Fred…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Reg: Max size allowed in creation of dbspace
Hi , I need to create a dbspace of abt 5-6 GB. on using onspaces to create the dbspace i am limited in size to about 2.09 GB is there a way to create a dbspaces of about 6 GB or is there a size restriction ? Thanks for any help Sudhir sending to informix-list…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
RE: Changing the path of a chunk from onstat -d output.
Yup, you are right, you must use the same chunk name. I am easily confused and was thinking of new device names. I will go back to slinking in the corner. Colin Bull Neil Truby wrote > "Colin Bull" <c.bull@videonetworks.com> wrote in message > news:<be0s1m$9e4$1@terabinaries.…
Re: Changing the path of a chunk from onstat -d output.
"Colin Bull" <c.bull@videonetworks.com> wrote in message news:<be0s1m$9e4$1@terabinaries.xmission.com>... > Why not create a mirrored chunk(chunks), drop the original > crate a new chunk with corrct name, > drop mirrors > > Mirroring is you friend :-) How's that going to work th…
RE: Changing the path of a chunk from onstat -d output.
Why not create a mirrored chunk(chunks), drop the original crate a new chunk with corrct name, drop mirrors Mirroring is you friend :-) (This assumes mirroring is available on this version and you have enough disk to mirror the db dpace ) Robert White wrote > Hopefully this h…
Re: Changing the path of a chunk from onstat -d output.
Bob: Yes you can make the change in path of a chunk. Please follow the below procedure to do it. Contact Informix tech support engineer and provide the details of the chunk information. Informix engineer has to login into your server, they analyze the server configuration and …
Changing the path of a chunk from onstat -d output.
Hi Hopefully this hasn't been covered before as I couldn't find the answer in google. We have certain naming standards here for chunk names on a given server. We base some scripted infrastructure around these standards. Unfortunately a chunk has been added to a server whereby t…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Adding chunks
Hey all -- Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3 chunks totalling 120MB. Plenty of space now. I have also successfully added several 1GB and 2GB chunks to my dbspaces. But now when I try to continue adding chunks to my dbspaces, I am getting this mes…
Dbspaces access
Hi All, Does anyone know how to obtain a report of a dbspaces more accesed, read / write, by sap or informix I really need this information, thanks in advance!! Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
delete down dbspace
Hi, I have a down dbspace, I am not able to do anything with it, there is no needed data inside, how I am able to delete this dbspace. (the dbspace has one chunk). Thanks Sven…
finding the tables within a chunk
hi all, how can i find the names of tables within a certain chunk? Simply, i = want to find which tables or table fragments a chunk contain?is there a = sql statement for it? Thanks in advance.…
Re: database current size used.
Get my package, utils_ak, which contains dbsavail.ec and dbsavail.sh either/both of which report totals by dbspace. Dbsavail.ec is an executable and so can be faster and can run on monitoring machines which do not have onstat installed, however, it installs a stored procedure the…
database current size used.
IDS 7.31uc7 AIX 4.3.3 I know that onstat -d gives the current size allocated and free in pages....but it doesn't give any totals. Is there an easy way to get the total size that is actually being used? Silvana…
Migration of Chunk
Hi all, Current I have informix 7.31 running with about 10 active chunks. How to I migrate those chunck to new and faster harddisk space on the same server instead of doing import/export and load/unload. Thanks and Regrads, Tham.…
onstat
Hi all. I was told by our DBA that onstat has different exit codes depending on the engine's mode (or mood). So, if I test $result (in C shell) or $? (Bourne / Korn shell), I should get a numeric value. My tests show 1=Quiescent, 5=On-Line. Does anyone know what these values …
Re: informix problem about deleting records
onstat -d shows the amount of space allocated to tablespaces, not the amount actually used. So, if a table has 10GBytes allocated to it, and you delete all the rows from it, the tablespace will still have 10GBytes allocated and onstat -d will show no difference. In order to inf…
chunk transplant
> I thought Robert said his server OS mirrored the chunks, so if the > hardware fail, he has other server with the same configuration and > hardware able to bring on-line a new Ifx server by using the mirrored > chunks. It works, but if the IDS get a unrecoverable crash, this sch…
chunk transplant
We have been investigating ways to keep data current on a local and identical backup server. We are aware of IER and HDR. My boss suggested that we keep a mirrored chunk on a cross mounted drive that resides on the backup server. Then in the event of a failure of the primary se…
question on how to list tables in a DBSPACE?
Hi, Does anyone have some type of scripts that list All DBSPACE for an Informixserver, and all tables in each DBSPACE + how much bytes they take? Thanks!…
Tables for a chunk
Hello, I need to find the tables for a chunk. Is it possible with SMI tables? Regards Enrico Sent via Deja.com http://www.deja.com/…
RE: location of logs
From: "Carlos Kobashikawa C." <ckobashi@luzdelsur.com.pe> > >Easier. Column "begin" of onstat -l . Erase the last five digits; the rest >is the chunk number (hexadecimal). >Chunk number - chunk device relationship is in onstat -d output. This must be some new meaning of the word…
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
bad primary chunk?
I keep encounter this message "Bad primary chunk /s7/mysblobs" when i do a onmonitor mode -> startup or oninit -s. I also noticed that the bad chunk (/s7/mysblobs) is offline. What could cause a chunk to offline? How do i bring the chunk up/online? YFWoi…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Dropping a dbspace
Hello All, Can somebody please help me with this. When I try to drop a dbspace, it says can not drop it. db space not empy. How do I find out what is there in the dbspace. Please help. Regards Aboo…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
��� ������ ������ ����?
�����������! ����������, ��� ������ ������ ���� � ����������� �� ����� � dbspace-�. ______________________ With best wishes, Kirill Solomko, JSC Protoka…
dbspace is down ...
When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstest WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
DBspaces and IECC
I have installed IECC on an NT4 machine with a 36 gig hard drive. I have created a dbspace on the D drive that is currently 7Gig. The D drive has 24 gig of free space, but Informix is not seeing it. When I try to add space to the dbspace it tells me that there is no free space…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Put on line a dbspace
Hi, a client of mine has compressed some of his chunk:) so the dbspace and the chunk where put down. I have taken on line the chunk (onsapces ....) but now I have the dbspace down. There is a way to force it online? Many, many thanks.…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Down chunk
Il s'agit d'un message multivolet au format MIME. --------------7D33438D52CB1F419DA8B8A5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Recently I had a disk failure on my HP-UX server, and the chunk file of my Informix db went down. I tried …
What's onstat -d flags of 1002 for rootdbs mean?
In the first section of onstat -d, I have a system that shows a flags value of 1002. I cannot find what the "1" means. Any ideas? Jon…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Creating Dbspace
I am trying to create a new dbspace with a size of ~2Gig. When I specify the path to the cooked file to use it tries to verify the disk free space and always fails at around 1 gig. I know that I have plenty of free space on the disk so I can't figure out what the problem is. I…
Add chunk.
Hello, I am a newbie. Working with AIX 4.3.2 and IDS 7.30 UC7. After adding a second chunk to a dbspace I got the error message: extents overlap(oncheck -ce). Chunk was successfully added and onstat -d shows the new chunk. What is the problem? Thanks in advance, Fredo David…
Altering DBSPACE
Hello group, We have created all of our tables in dbspace "st_ux01_001". Now the "dbadmin" want to move all of our tables to dbspace "st_ux01_002". In Informix dokus we didn't find any command to alter a dbspace. The only way we know to alter the dbspace is, to export all data…
DBSPACE by table
There is a table in sysmaster who contains dbspace for every table. Thanks in advance. -- Francisco Gaspar SISTEL (Servicios Inform�ticos de Software y Telecomunicaciones, S.L.) Avda. Los Jarales, 4 03010 Alicante Tel: 96 593 00 80 Fax: 96 593 01 53…
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
Onstat
Hi all, I recently installed Informix dynamic server 7.31.UC6 on HP UX 11.0 I am getting an error while running onstat. "Changing data structure forced command termination. " can someone interpret this message for me and tell me the action to be taken. Thanks, Srini…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Restore Granularity with onbar
I am using Informix 7.31 on Solaris 7. If you have a dbspace with 50 chunks, you lose three chunks, so they are now marked down by informix, when you restore from tape (using onbar) will it only restore the 3 down chunks or all 50 chunks for that dbspace? Thanks…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
Problem removing chunks ...
Christian Kondo wrote: > > Hi guys ! > > I´m in curious situation, but very critical for me. > Last weekend was dropped one dbspace, but your chunks wasn´t... And now ? > How can I drop this chunks ? > I can´t use onspaces, ´cause it needs the dbsname... > Look my onstat -d: Wha…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
Re: Problems With ESQLC on HP/UX 10.20
From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >The only use for HTML output from onstat I could see would be WAP, but >then what DBA is going to administer their database servers using a PDA >or cell phone? :-) Funny you should say that... _____________________________…
onstat -d question
When running onstat -d we often see the "1001" value under "flags". It goes away after a short time. I can't find anything in the doc's but I assume it might be cleaners working Anyone know for sure?…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Dropping a chunk by force
how do u drop a chunk by force in IDS 7.31…
Bad Chunk
Hi, When I am trying to initialize the shared memmory using oninit -s. I get the following message in the online.log: shmget: [EEXIST][17]: key 526a4801: shared memory already exists 00:11:21 mt_shm_init: can't create resident segment 00:11:38 shmget: [EEXIST][17]: key 526a…
TEMP dbspaces
Hi I have peculiar problem with temp dbspaces on IDS 7.22 UC1 and HP-UX 10.2. We defined tempdbs1,tempdbs2 as TEMPDBSPACES and 50000 pages for each dbspace. This system was configured two years back and using for development. This IDS server never be shutdown until necessary. …
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Recover a bad chunk
Hi If one chunk goes bad, what are the various methods to recover the chunk or how to copy one chunk to another. Any suggestions? regards usman musman@iffco.com Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
Chunks and Offset.
Hi Gurus, I have a query, what will happen if I add another chunk (cooked file) and the offset is not zero. Regards. Jojo…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Dropping a chunk
I want to drop the chunk featured below, but it has a phantom tblspace in it. Does anyone have a foolproof method of eliminating the recalcitrant tblspace, with recourse to informix Tech Support? thanks Neil Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size …
When IDS need reinstall.
My IDS on sco .My chunk is use raw disk.no backup.When My IDS need reintsall ,How can I reuse the chunk,restore the data? Sent via Deja.com http://www.deja.com/ Before you buy.…
Recalculate onstat -d (free space of smartblobspace)
Hi, I must write application that calculate free space of smartblobspace ,anyone have idea where find information of free page of smartblobspace ??? In the output of onstat -d this information is readable. This is a query that I use on sysmaster db : SELECT sysdbspaces.name, s…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
What do IOSTATS, SQLSTATS, TABLESPACE_STATS?
Hi *, I´m using IDS 7.31 on Solaris 7 and did a strings oninit. I found the configuration variables IOSTATS, SQLSTATS and TABLESPACE_STATS. I´d like to know witch Statistics I can trun on or off with theses variables. And how can I see these statistics? onstat -g ? Thanks in …
DBSPACE / DBSIZE
I am forced to inherit and maintain and Informix database for now. I studied the Informix book(s) over the weekend and have yet to find what I need. I hope to be a master some day as well, but for now I need immediate help with these questions: How do I determine the c…
onstat -d question
I get the following when I do an onstat -d INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:34:15 -- 10544 Kbytes Dbspaces address number flags fchunk nchunks flags owner name a2aa100 1 2 1 2 M informix rootdbs a2ab288 2…
onstat -d flags
Has anybody seen a dbspace flag of 1001 with ODS 7.20 on HP-UX 10.20? The Administrator's Manual gives definitions for 0001, 0002, 0004, 0008, and 0010. This was seen during a period of heavy updates that appeared to hang the engine but did eventually continue without error. T…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
dbspace not empty
Hi Thanks for all the suggestions about the database reorg - when I finally managed to export all the data I ran an oncheck -pe and 5 of my chunks had data in them and they weren't related to any of my databases - see attached oncheck -pe. Any idea how to clear them out as I ca…
Re: move dbspace/chunks on NT
Jay Walters wrote: > Is there any way other than backup/restore to move a chunk on NT to > another disk. Can I move the root dbspace this way? > > TIA, Sure. Save data from the dbspace containing your chunk (dbexport, unload, onunload). Remove all data from the dbspace. Drop …
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
DBSPACE Problem.
Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Restore to different chunk-paths?
Art S. Kagel wrote in message <37F28C5D.377EF0BE@bloomberg.net>... >I suppose Informix could give us an option to recreate the chunk list >using some file containing the new chunks ... Well, quite! But thanks for the reply. Neil…
Size of the database
Hi, I have two databases in a single dbspace and I wanna know the size of the database.When I do onstat -d I get only the size of the chunk and pages free. Any one who has done this .Please mail me Regards Shiller…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
which tables are in a specific dbspace?
Hello! How can I get, which tables are in a specific dbspace? thanks Gabor…
dbspaces on NT
Hello, somewhere I read :-)) that IX DBSPACE is limited to 2GB and NTFS to 4GB. I have 10GB HDD for Informix only (IDSWE 7.30) and PII server. Exists better solution than 5x 2GB NTFS? Thanks Leos…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
altering DBSpaces
I will be adding some chunks to a BLOB space this evening. In the past I had been told by Informix to run an oncheck command after changing DBSpaces but I cannot recall what flags for oncheck. Can anyone help me out?…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
# of chunks for a dbspace !
Hi Users, In an Informix IDS 7.3 / SAP 4.5B environment what is the maximum number of chunks that can be assigned to a growing dbspace. Thanks in advance Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Contentets of a chunk
Hello, we are working with IDS 7.24.UC7 for AIX4.1.5. We use DBSPACETEMP=temp different of root dbspace. We have a problem with a chunk in root dbspace. Sometimes it grows until: chunk/dbs offset size free flags 6/1 0 25000 377 PO- a…
onstat
Hello after executing an onstat following message appears in the first lines: "Changing data structure forced command termination" What does this mean? Why does the Profile (as in a normal onstat) not appear and the onstat view only shows me the sessid? Regards André…
dbspace sizes
I am configuring a 7.3 IDS engine on a SUN box. I configured a 4 GB volume on 1 disk. I created a dbspace on the volume with the first chunk at offset 0 and a size of 2 GB (approximately). I try to add a second chunk, with an offset of 2GB and a size of 2GB but Informix won't …
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Drop chunks.
How can i drop a chunk. regards.…
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
RE: onstat -d showing PD and MD Flags
Robert, Have any links been removed that were pointing to the device names for these chunks? Or any permissions changed? Jamie Kohm -----Original Message----- From: Robert Moayedzadeh [SMTP:Moayedzadeh@email.msn.com] Sent: Wednesday, June 16, 1999 5:43 PM To: informix-list@ii…
RE: onstat -d showing PD and MD Flags
Unlikely to be a false reading, but .. Are there tables in those chunks? Can you access those tables? You can try to bring them up with onspaces aka onspaces -s dbspacename -p chunkpath -o chunkoffset -O -y Murray Wood -----Original Message----- From: Robert Moayedzadeh …
onstat -d showing PD and MD Flags
I am running HPUX 10.20, It is not showing disk failure for the disks that have the PD and MD flags... could this be a false reading? I am running IDS 7.3 UC5. What else could it be?…
Sequencing chunk population in dbspace
Tom Smith wrote: > > I am using IDS 7.23 on Solaris 2.5.1. I have defined a dbspace with > three chunks and create a table in that dbspace. I then proceed to load > the table using a migration utility. How will the engine decide in > which chunk to store the data? It begins u…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Down Chunk
Gentlepersons: My understanding of Down Chunks is less than complete! I would invite comments or further explanations. On p. 13-15 of 7.3 Admin Guide, it says "You can prevent the database server from markng a dbspace as down while you investigate disabling I/O errors." 1) Ho…
No primary chunk
Hi, When restarting Informix, I received the following message, no primary chunk / bad primary chunk Does anybody know what the problem is? What procedures do I need to recover the data in the database? Many thanks. Sunny…
dbspace and the table
How can I identify in which dbaspaces the table is located?…
DBSPACE
Author : T.Jalaludeen E-mail : jala@hpsgm99.sgp.hp.com Hai, I created a database in INFOMRIX 7.23 - HP UX. I created tables also. But later I found thatthe transaction logging has not been turned ON for this database, so droped the database and created using "CREATE DATABASE <d…
Re: DBSPACE
"T.Jalaludeen" wrote: > > Author : T.Jalaludeen > E-mail : jala@hpsgm99.sgp.hp.com > > Hai, > I created a database in INFOMRIX 7.23 - HP UX. > I created tables also. But later I found thatthe > transaction logging has not been turned ON for this database, > so droped the databas…
Deleting a chunk
Dear Jonathan, Art, and Informix list friends: I saw a recent post to the list regarding deleting a chunk. My situation is this. We decided not to use a certain table in a dbspace any more. The dbspace now requires much less space. How do I get rid of a chunk or two? or is there…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
DBSPACE size
It is possible to create a rootdbspace during instalation larger than 30 Mb ?…
Cleaners
Please forgive me if this is posted twice ----------------- Online 7.24UC3 Solaris 2.5.1 Given that Cleaners are assigned to chunks in the order that the chunks are created (and I don't know the order) how can I determine which cleaner from onstat -F) is assined to which chunk? …
DBA problems
How long have you been a DBA Mukund??? The mirrored chunk always takes up the entire allocated size of the primary chunk, regardless of how much free space exists in the primary. You never look at the mirrored chunk for space usage metrics, use the corresponding primary chunk. …
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
follow up-- rename chunks
What do mean rename chunks? Do you want a new path for a chunk? The supported way of doing this would be to empty the chunk and then drop it and create a new chunk. Any other way could be dangerous leading to some corrupted chunk information. Brandon David Grove wrote in mes…
change chunk name
Could one change chunk name by editing the appropriate reserved pages (primary and mirror chunk pages-- 8th, 9th, 10th, & 11th reserved pages, I believe). David Grove…
Rename Dbspaces
Does anyone know of a safe way to rename a dbspace? I can't drop and recreate the dbspace, because it's the "home" for a database, and the database is too large for dbexport/dbimport.…
Dbspaces and indexes
Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI …
Chunk writes
Hi, I am in the process of creating the layout for a database. I will have 6 physical disks to work with (plus another 6 for mirroring). I understand that CLEANERS should be set to the number of disks, in this case 6. I also gather from messages that this scheme would perform op…
Empty dbspaces.
When I clear a dbspaces, solely in use for tables from tables with "alter fragment ...." then I see with onstat -d that the dbspace isn't completely empty however looking in the sysfragments tables for the datbases I found the dbspace isn't in used. Also oncheck -pt shows me that…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Rename a dbspace
v7.24 UC6 on HP-UX 10.20: Does anyone know if this is simple? The reason I want to do so is that I need to move a large database from one server to another, with onunload/onload. There is a (glaring) bug in onload whereby you must load the database into a dbspace with the same…
tables in dbspace
Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
onstat -t
Hello, Is there anyway to tell what the actual tablenames are when you execute a onstat -t ? I know that tblnum is the tablespace number, but what can this be related too to tell me something useful? Thank you david.tamburin@protegrity.com david Tamburin…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Offline Chunks
Besides a bad spot on a disk what are others reasons for an informix partition to be put offline? Thanks -- Kenny Broezell Motorola Cellular Support Center e-mail: broezll@cig.mot.com 1501 Shure Drive phone : (847) 342-5633 Arlington Heights IL. 60004 …
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Create DBSpace...
Hi folks, We're trying to automatize our database installation throughout hundreds of sites and it is straightforward to use onspaces command to create desired dbspaces. In an NT 4.0 (SP3) box with Informix 7.23 TC1, a 500 MB of dbspace can be created in as long as 20 *MINUTES*.…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: onstat -d flag
Jacques is correct 0x1000 means a table in the dbspace was dropped since the last checkpoint. This flag affects physical logging. In case you did not know, 0x0001 means Dbspace is not mirrored, so flag 1001 means that a table was dropped in a non-mirrored dbspace. Jacques P Ren…
Re: onstat -d flag
I'm not at work to check for sure, but I believe the 0x1000 flag means that a table was dropped in that dbspace. I believe it will be turned off after the next checkpoint. Jacques James McCallum wrote: > > Has anyone got an idea what the flag 1001 is for a dbspace from the > o…
onstat -d flag
Has anyone got an idea what the flag 1001 is for a dbspace from the onstat -d command like the following Its the flag set on dsa13. INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 02:00:38 -- 548776 Kbytes Dbspaces address number flags fchunk nchunks flags owner…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
Re: Informix DS 7.24 Missing DBspace/chunk
Jim Will wrote: > > When I try to create a DBspace by running the following command: > onspaces -c -d ccbdbs1 -p /opt/informix/dev/chk25a -o 0 -s 250000 > The following message is returned: > The chunk specified already exists. > > So then I try to drop the chunk with the…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
unloading a dbspace
I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database which has tables spread across 9 dbspaces and two of them are smart blob spaces. What I would like to do is to unload each dbspace, copy the file to another instance of online to restore into a dbsp…
Re: Cooked Files
Go ahead and specify the offset. The additional chunk will overwrite neither files on the existing file system nor the tables in the existing cooked files so long as the chunk you are adding is for the same instance of Informix that you created the initial cooked file. Rene…
Re: Strange error in Informix
Try to put the name of the chunk in big LETTERS. Pascal…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
Adding a Chunk
We are doing the rather mundane task of adding a chunk to a dbspace. Unfortunately we have very little experience with Informix because we only use it for one application called Permits by Sierra. Additionally since Informix runs so well, we rarely have any problems and we only h…
chunk permissions
Hello Everyone, Im getting the following message in my server log, but the file permissions are set to informix, informix. Any ideas ? The chunk '/u3/GAP/informix/dbspaces/rootgapdbs' must have owner-ID and group-ID set to informix. -rwxrwxrwx 1 informix informix 0 S…
Re: Moving Chunks
Perhaps a "hindsight". I use Unix/AIX llinks for all my chunks, including root space. Then If I need to move, you only have to change the link after physically moving the chunk. Works great for cooked space.…
Moving Chunks
I have an Informix Database on cooked disk space. Now I would like to change the path to the chunks (datafiles). Is there any way except unload/load the whole data? Yours Sigrid Ehrenreich seh@carus.de…
Chunk down
The Online Admin guide for Informix says that if a chunk is down, to "Use UNIX utilities to determine what is wrong with the down chunk and then to correct the problem and bring the chunk back to on-line mode." Can someone expand on this and suggest what UNIX utilities are perti…
Re: rearranging chunks
In article <6rjg9i$obl$1@news.uni-lj.si>, zdravc@fe.uni-lj.si (Zdravko Balorda) wrote: > Hi, > > is there a way to rearrange disk partitions and > chunks once dbspaces are initialized and data > loaded? I am not quite happy with what i did. > I want to, say, copy a chunk to ano…
rearranging chunks
Hi, is there a way to rearrange disk partitions and chunks once dbspaces are initialized and data loaded? I am not quite happy with what i did. I want to, say, copy a chunk to another one so that the first one could be dropped. Or is this chunk layout frozen, once you created i…
onstat -D vs onstat -g iof
Informx gurus: --------------------------- This is a copy of a post that I previously send, however seems that because of the problems with the informix-list not many people had the opportunity to read it. I am sorry if you already read this message. ----------------------------…
onstat -D vs. onstat -g iof
Informx gurus: Could some one explain the output of onstat -D and compare it with the output of onstat -g iof? On my online 7.23 running on AIX 4.2 I get the following for onstat -D: address chk/dbs offset page Rd page Wr pathname .... 400382c8 2 2 1 40261 303…
Move chunks
Hi all, I have IUS 9.x on an Ultra 1 box, running Solaris 2.5. I want to move the chunks of all of my dbspaces to another disk. Chunks are stored into cooked files. I thought that if I move them to my new disk and create some symbolic links (with same names as the original cooked…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
dbspace question
Currently my dbspace is spread over 5 different chunks on several small and slow hard-disks. After replacing these disks with a larger and faster one, is it a good idea to merge the small chunks into one large chunk ? If yes, is there an easy way to do that ? Detlef Liem…
Down Chunk
Is there a way to drop a down chunk from a dbspace which has only one chunk? The down chunk is a cooked file which has been removed from the file system. When I tried to drop the dbspace which contains only one chunk, onmonitor returns with an error (ISAM error: Unexpected inte…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Coalesce Chunks
Hi, A dbspace has 3 chunks.These three chunks are on different disks.I want to place the three chunks contiguosly on another disk.How to go about doing this ? Dbexport/Dbimport works at Database levels only i believe. TIA, Sathish _____________________________________________…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Sizing dbspaces
Does anyone have any recommendation or guidelines we can use in determining a base sizing strategy for rootdbs and physicaldbs. I am most conerned about physicaldbs. I used the formula in the Admin guide to determine a size for physicaldbs but I am not sure if the result was in…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
corrupt dbspace
I am running Informix ODS 7.22 on AIX V 4.1. I accidentally removed a file from AIX that Informix ODS had listed as a chunk in a dbspace (that I was about to remove anyway). I don't back the system up since it is our test system. All I want to do is remove the dbspace and all…
Create Index Problem.....
Hi, I've created one databse in a perticular dbspace with one table. If I create an index on that table using 'in dbspace' clause, sysextents table in sysmaster database reports it But if I create the same index without 'in dbspace' clause, it doesn't report it. Why ? ? Abhay …
dbspaces question ....
Hi, Environment : OSD 7.23uc4 HP-UX 10.20 We have all 2Gb disk chunks ( told by Unix Admin to me ). I tried to run onspaces command for the size more than this and I found that I can allocate 2.048Gb Also existing allocation of disk space leaves gaps of few Mb in be…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Dbspace Question ----
Hi, If there are 2 informix servers on one machine and I create a dbspace for the first server which overlaps one of the dbspaces for the second, what will happen ? Does it gives error or I'll loose the data ? Thanks in advance. Abhay Mannur.…
Re: How can I create DBSCAPES in 20GB RAW partition
: Anyway a dbspace can have as many chunks as needed and the 7.xx engines : support 1024 chunks or 2TB. Chunks can be less than 2GB and the actually, the limit is much larger. i'm not sure that there is one. as you allocate more chunks, the system allocates more pages to the…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Database DBSpace
I have a database created in a non-root dbspace. I would like to relocate the database, not any tables, to another dbspace without unloading/exporting the database. Is it possible to relocate a database to another dbspace? Mark Baumgartner Cardinal Health…
chunk archiving
hello everybody!! i've got the very common problem of archiving out of date data, let's say the production data older than 3 years. my plan was like this: grouping the data onto yearly changing dbspaces like ar1997, ar1998 ... each dbspace is designated to a distinct chunk, whic…
onstat counter size
Could anyone tell me at what value the onstat counters wrap. I am particularly interested in the following: onsta -D page I/O for chunks onstat -g iof disk I/O for chunks onstat -p server profile (I/O, ISAM, CPU) onstat -g glo virtual processes From observation…
Re: informix mirroring
Robert Higgins wrote: > i am having a problem with disk i/o - i am currently utilizing an ibm ssa > with 8 disk (4x4) with informix mirroring > when i run an iostat (aix) it shows my hardest hit drives are the ones that > are mirrored. i have hardly any hits on the regular disks…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Re: the new bie with the share memory problem
SaTriGuy wrote: > > Is the chunk's name /work/data or /work/data/root_chunk ? > Madison Pruet Can you 'dd' this chunk as informix?…
Re: the new bie with the share memory problem
Is the chunk's name /work/data or /work/data/root_chunk ? Madison Pruet…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: onstat -d,onstat -D
I believe 1001 indicates that the dbspace is a blobspace. I know that 2001 indicates that the space is a temporary dbspace. "Tony_Reynolds(Accounting & Purchasing System") wrote in message <67972r$caj@cssun.mathcs.emory.edu>... >Can anyone tell me the difference between a dbspa…
Re: onstat -d,onstat -D
I believe it in indicates that table in dbspace has been dropped. -Lin "Tony_Reynolds(Accounting & Purchasing System") <tr-2959@mail.necgroup.co.uk> wrote: > Can anyone tell me the difference between a dbspaces address with a > flag of 1 and a dbspaces address with a flag of 100…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Chunk Writes
Hi, I have been reading the "online Dyn. Server Sys. Adm 1" training mtrl -by Cindy Lee Dowling,Elizabeth Suto. Chapter 10 -270 which discusses Chunk Writes. it says " All modified buffers are flushed to disk.The page cleaner threads read thro' the buffer headers looking for…
Deleting Chunk..
Hello Everybody., We are working on Informix Online 5.03 on HP-UX 10.10. I have a DBSpace which has a chunk. I need to remove this chunk from the DBSPACE. Is there way do that. -------------------------------------------------------------------- RSAM Version 5.03.UC5X1 -- On-Lin…
invalid dbspace
I have been receiving this message for awhile..it hasn't seemed to affect normal functionality...but, I still would love to know what this message means: Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. lrwxr-xr-x 1 informix informix 19 Oct 16 1996 tmpdbs -> /d…
Script to convert onstat -d to onspaces commands
#!/bin/sh #=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= # copy_spaces.sh -- A program to convert dbspace/chunk information # available from the [on|tb]stat -d command into onspaces # …
Re: Changing size of RAW space
Curt Narvesen wrote: > > I inherited an Informix database that has a large chunk of space allocated as > raw. Is there any way decrease the amount of space allocated as raw without > unloading the database? I am running version 7.1 No there is no way to reduce the size of a sing…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Tables on a particular chunk.
I'm looking for a query which will list all the tables which spill over onto a particular chunk. I am able to list all tables on that dbspace, but this dbspace has two chunks to it, and I want to know which tables are on the second chunk. Any help would be greatly appreciated. …
RE: Assert Failed: Internal Error - Bus Error
Yakov, I recommend you to update your Informix database server. We have to upgrade one of our customers site from 7.13 to 7.20 on a=20 Digital Machine ( Alpha with DGUX 4.0 ). We experimented that kind of Assert Failures. Jeff Craig is right, Informix has a bug with numeric-stri…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Error -130
The creation of a database in a Sbspace fails with ISAM ERROR -130: no such dbspace, although the Sbspace exists according to onstat -d . The oncheck-utility doesn't report any error too. (Informix version is IUS 9.10.UC1 for Solaris) Thanks. Klaus…
Re: Droping an unused chunk
Hi Chris, Winson Kwok wrote: > > Dear Gurus, > > If I have a chunk that's not used (but added to the dbs) is it possible > to drop it to free space. Starting with version 7.x there is a way to drop unused chunks, if the chunk to be dropped is not the primary chunk of a dbspace …
Where is dbspace?
On a raw disk(instance product) I created a database test. On other instance(training) on the same raw disk and fisical area other database with thehe same name was created. I deleted the second database and dbspace but on the first instance I can't access, drop the database tes…
Patching Chunks
I am looking for a tool or utility that informix seems to have. I need to be able to patch chunk headers on the raw devices. Platform: DEC ALPHA os: 3.2G db: On-line 7.12uc1x8 Please email me : mdeegan@logistix.com -------------------==== Posted via Deja News ====-------------…
Re: Cleaners-Mirror and Temporary Chunks
Milan Vesely wrote: > > According to Informix chunks should be added to system > in a successive way - to be cleaned correctly by > CLEANERS. The number of CLEANERS should be the same > as the number of disks to be cleaned. > But: How to consider TEMPORARY and MIRROR chunks? > …
Re: 48 out of 58 chunks down
Is it possible that the CHUNKS paramater in your tbconfig file got changed to 10 during the upgrade? This parameter sepcifies how many chunks the instance will support. HTH, Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com…
root dbspace
I have a test machine running Online 7.1. On performing a VERY large query I received an error message saying that there was no free disk space to write sorted rows into a temporary table. On examining the space available in the rootdbs 32252 pages remained out of 575000. I sh…
Dropping a dbspace.
We are trying to drop a bad chunk. The chunk is a cooked file and is the only chunk in that dbspace. When I try to drop the chunk I get the following message. % onspaces -d ch_dbspace1 WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
RE: Table io rate
Sean Wong wrote: > Can somebody give me answers on following questions: > >1. How can I find out disk io, e.g. read/write access for a given table >2. How can I find out disk io, e.g. read/write access for a process Jon C. Vemo (jvemo@cyberspace.com) replied: ------------------…
creating a chunk
system: sco unix 3.2.4.whatever db: informix online 5.03 usage: testing system Problem: system had recent disk problem. Reinstall started but no recent system backups could be located - at least not complete. root filesystem pieced backed together. Now missing cookedspace…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
Re: Online V7 and Parallel Queries
> > Is it true that PDQ, parallel queries in OnLine V7.x will use both > primary chunks and mirror chunks to retrieve data concurrently when > performing a query expected to return large volumes of data??? > It is true Michael Strother…
Drop db chunk
At one time, I accidentally add a chunk to a wrong dbspace. Is there a way to remove this wrongly added chunk so that the chunk may be allocated to the right dbspace? Edmund To an Informix novice Chinese University of HK…
AW: What happens when ?
Hi, One possible solution is to dump the correct dbspaces with dd on tape. After restoring the correct archive, it might be possible to overwrite the restored dbspaces by dumping the dbspaces back.(This works with Infomix 5, maybe with 7) Robert…
Re: Oninits Running Amok...
OK - got some more info...it looks like the only time the CPUVP's run amok is when our Powerbuilder client connects across a slow (dialup) IP link and is downloading client code changes from a table (Select...) that contains updated app code in BLOB's. This would explain the lac…
Re: Oninits Running Amok...
In article <31D9457E.5C90@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> writes >We have 7.13.UC2 running on Solaris 2.4 w/ 2 Sparc CPU's. I occasionally >see both CPU VP's chewing CPU like crazy, yet there's few if any Buffer >Reads or any other evidence of productive work goin…
Fraged Tables/Onunload 7.13uc1
If a table is fraged across multiple dbspaces, and the indexes are created in a different dbspaces of its own, will onload work successfully if the table was droped and then reloaded? I know I can specify the dbspaces in which I want to load the table on the command line, but wh…
Used Pages Informix/Online 7.1
Hello, if I query at different times the pages used by chunks (with onstat -d) and query the pages used by tables (with oncheck -pt) and then compare the values of the two difference-values I get very different difference-values. An example: DBSpace (onstat -d): Difference bet…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: flag values in onstat -d
Mickey Mestel (mickey.mestel@etak.com) wrote: : hi, : does anyone recognize the flag values here of 4001? what do these : mean? my dbsapces are unmirrored, online, and fine, and this does not match : any of the flag values in the book. : anyone know? : mickm : ----------…
Re: Informix v7.x Problem on Digital Unix: 2GB Limit
I think that you can solve the problem by creating a dbspace composed by 2 or more chunks of 2 Gb. Then, when you create the database you must specify this special dbspace. The load of the information will work fine! Bye Paulo Nunes (p.nunes@mail.telepac.pt)…
flag values in onstat -d
hi, does anyone recognize the flag values here of 4001? what do these mean? my dbsapces are unmirrored, online, and fine, and this does not match any of the flag values in the book. anyone know? mickm ---------------------------------cut here-----------------------------…
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
Re: Freeing logical logs
In article <347cc$f3014.14d@news.leg.wa.gov>, fry_ja@leg.wa.gov (Jason Fry) says: > >. This is the output of the onstat -l command > >address number flags uniqid begin size used >%used >88d988 1 U-B---- 16 203acd 5000 5000 etc ..... …
Re: Primary chunk - a misnomer
Keith Fang (fang@netcom.com) wrote: : >The chunks are known as primary chunk for the first chunk : >in a dbspace and secondary chunk for any additional chunks added. : >(This is not an exact quote, to avoid possible copyright infringements.) : > : >Bunk. Bull. Incorrect. : > : >…
Primary chunk - a misnomer
I was reading in the "Informix Systems Journal" dated July/August 1995. In particular, I was reading the excerpt from Joe Lumbley's book in this issue. He makes the following claim: The chunks are known as primary chunk for the first chunk in a dbspace and secondary chunk for an…
Re: Online 5.1, How to remove a chunk
Hi, You have to drop the dbspace in order to free up the chunk and the dbspace has to be empty when you drop it. Thanks Ryan…
Re: Online 5.1, How to remove a chunk
You can't remove a chunk in version 5.x. This is possible in version 7.x. If the chunk is in a non-rootdbs dbspace, you could remove all data from the dbspace, then drop the dbspace to reclaim chunks.…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
down chunks
Dear Calvin, About your question below. I have had a similar thing happen when a chunk was marked as down due to the UNIX file table overflowing. I was able to change the chunk status using dd and writing over the reserved pages. Hope this helps. But - this should only be done …
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Find names of all databases in a DBSPACE
Is there a way to get a list of all of the databases in a dbspace? My dbspace is very dynamic and I need a way to get this list. Using Informix Online 5.x on Sun Sparc SunOS 4.1.3c David Clough…
dbspace Q
i am looking for any pgms that might help monitor "space hogs". it would be nice to be able to get a listing of databases found under a specific DBSPACE along with its owner and size. i thought i saw a news thread along this topic a few months ago. thanks, jim ________…
Re: Mirroring
Ti Lian Hwang writes: |We have a new HP9000 machine with 2 fast SCSI disks and 2 slower |disks. | |We are using informix mirroring on them. | |Is there advantages or disadvantages if the mirror copies are both |in the in the slow disks, or a mix of slow and fast disks ? | |I mea…
Mirroring
We have a new HP9000 machine with 2 fast SCSI disks and 2 slower disks. We are using informix mirroring on them. Is there advantages or disadvantages if the mirror copies are both in the in the slow disks, or a mix of slow and fast disks ? I mean Disk A (slow) Disk B …
remote dbspace
Is anybody define a dbspace on a remote machine...!!! with online 5.0. Thanks...…
mirrored chunks
Help please. We are running Online 5.02 for Interactive Unix. All of our database chunks (we have 11) are mirrored. Twice in the past four months, chunks have gone off line and we have had to restore from tape. Why would the mirrored chunk not have been used instead? When the c…
pathname of chunk
I recently changed the disk array which makes up my 1 raw device (1 chunk) with my rootdbspace and another dbspace. The chunk is slightly bigger than the one it replaced. 2 gig now instead of 1.8 gig. I dbexported the database before replacing the disk array, then re initialized …
dbspace lost
Platform: Everex 486 running Interactive 3.2 and Informix Online 4.00.UE1. Recently, we took a power hit that caused some damage to our file system. Specifically, the device file Informix writes to was lost. Should I reinstall Online or can I just re-create the device file? Al…
Prevent users from creating databases?
Is there any way to prevent users from creating databases? Or at least to prevent them from creating databases in the system dbspace? Or even a way to change the default place for databases from system dbspace to another dbspace? Thanks in advance. -- Rick Hamel Database Admi…
tables in dbspace (Online 5.x)
Is there a simple way to find which tables are in a dbspace? (Or, what dbspace a table is in?) -Brian ------ brena@hcia.com…
DBspace Question
I'm looking for a way in a sql statement to have on-line return me based on a given table name the dbspace name that the table is located in. The following sql statment returns the dbspace number the table is located in but what I need is the actual dbspace name. select h…
dbspace for database
Yes I know I have antique software, and yes I am sure you've answered this before...but I need to know now, and cannot find it in Walt's excellent archives... On a UNisys 5000 platform, running Turbo with 2.10.03G SQL... 2 databases were created. tbmonitor shows rootdbs, and 2 o…
Default dbspace?
This has probably already been discussed to death, so please reply by e-mail. Is there a way with OnLine v4.0 or v4.1 to make the default dbspace something other than the root dbspace? Thanks. -- +--------------------+-------------------------------------------------------+ |…
Re: Performance in chunk vs. chunks?
>From: uunet!neptune.dsc.com!jbh (J. B. Hendrix) >Message-Id: <jbh.705287859@neptune> >Subject: Performance in chunk vs. chunks? >Date: 8 May 92 01:17:39 GMT >X-Informix-List-Id: <news.1216> > >My boss from the old school is concerned that a heavily used >DB spread across multipl…
Performance in chunk vs. chunks?
My boss from the old school is concerned that a heavily used DB spread across multiple chunks on separate partitions in the same disk will suffer performance degradation as compared to a single chunk for the whole DB (obviously a large chunk, about 150 Meg). My cohorts and I hav…
dropping a chunk
>A client of of ours was playing with OnLine, and created a chunk on the >cooked file system. When he was done, he decided "Okay, I'm through." >and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace >inside of OnLine. So now he has a dbspace that OnLine thi…
Cooked dbspace...
A client of of ours was playing with OnLine, and created a chunk on the cooked file system. When he was done, he decided "Okay, I'm through." and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace inside of OnLine. So now he has a dbspace that OnLine thinks …
Dropping a dbspace
Hello, I am currently using the Informix Turbo engine. I tried to drop a dbspace the other day and couldn't do. Does anybody have info on how to do this? Thanks ! Brian MacWilliams USAMC - SIMA LEAD CHAMBERSBURG PA…