Oninit&reg; Archive

Greetings, Family. As a curiosity, and to follow up on a Perl script I never got around to writing, I wanted to see the output of onstat -g opn (open tables/partitions). The printed (PDF) manual on 12.10 (P 20-121 or 587) gives a format and explanation that could be helpful and l…

any recommendation on NONEXCLTRIG parameter?

Andreas Legner

Hi, the error you're getting (106 - non-exclusive access) does not mean " not able to obtain exclusive lock", in fact it has nothing to do with locks. Instead it means this statement is not the only one currently having this table open, and there seem to be other queries or curso…

Onlog columns documentation

Jacob, As far as I can see, the HDELETE record is documented pretty accurate. I have total 9 fields, i.e. 6 for a header, and 3 extra columns, for tblspace, rowid and slotlen. ------------------------------ Sincerely, Dennis ------------------------------…

How to restrict access for a user to Informix by IP?

Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…

Defragment sbspace

Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…

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 ------------------------------…

alter table modify lvarchar column length report -136 ' no more extents' error

Chuan: A couple of notes: If you decide to take Jacob's advice to copy the data to a new table with the new column length and partitioned in a 16K dbspace, I would recommend that instead of unloading the data and reloading it that you copy it directly from the current table to th…

INT to SERIAL in-place alter

Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…

What does ALTER FRAGMENT do extending a fragment?

Hi, Running ALTER FRAGMENT extending a fragment I notice a significant pause when the session does nothing (?) ALTER FRAGMENT ON TABLE tab01 MODIFY PARTITION tab01_0047 TO PARTITION tab01_0047 ((item_id >= 115000) AND (item_id < 120000)) -- was: item_id>=115100 AND item_id<120000…

dbs_partn_ mutex contention

Paul Watson

dbs_partn is mutex on the partition number of the database tblspace. It is the same that partition number of the tables (tblspaces).…

Want to DROP an empty rootdbs chunk

David Williams

Hi, There need to be a supported command/method to say get "system" i.e non table or index pages (e.g. exteneded reserved pages, database tblspace, tblspace tblspace pages) out of a chunk and moved to a diferent chunk in the same dbspace! Or have drop chunk be smart enough to do …

Phantom rsccompdict table

David Grove

Thank you, Andreas. I checked things as you suggested. I found that query "a" did not come back empty. Bottom line, I observed the extent in 'oncheck -pe rootdbs'. But, I can't DROP the table because there is no database in which the "table" resides. I look at the tables and s…

Clear BUFFERPOOL

John Lengyel

As Andreas said this result is not what we would have expected. It's hard to picture what would be taking the bulk of those 30 seconds if not I/O. There are many caches in shared memory that neither of these methods clears (such as the partition cache) but even if your query open…

LIMIT DELETE ROWS

Amit: You cannot do that with SQL, no. However, that's why I wrote my dbdelete utility. Note the -b flag: $ dbdelete dbdelete - Delete rows from an Informix table. Usage: dbdelete -d database -b FetBufSize -t table <-h host> <-S> <-V> <-R> <-I> <-v> <-w waittime> <-u keylist> <-o…

database exclusive access

David Williams

Hi, Use onstat -g opn to find sessions with relevant partitions open. Regards, David. ------------------------------ David Williams ------------------------------…

Spot the difference

TOM GIRSCH

At last check (admittedly it's been a while) we couldn't get the output of 'onstat –g opn' from the SMI tables. So I had to write a pretty convoluted script to see who's currently got a table open (but isn't holding any record locks). I have to parse onstat –g opn, then load it …

How to know what edition is installed ?

Mike Walker

I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…

Dropping temp table throws -242/-106

Jacques Renaut

I believe this error could also be generated within the server due to a timing problem with the drop temp table statement and another session that might be running a sysmaster query looking at partition pages (so like sysptnhdr if I remember correctly). I don't believe anything …

IDS Bug of the Day: DBINFO

TOM GIRSCH

T32768: DBINFO(DBSPACE) RAISES 727: INVALID OR NULL TBLSPACE NUMBER https://www.ibm.com/support/pages/node/6207160 ------------------------------ TOM GIRSCH ------------------------------…

Pages show as "used" in empty chunk

CASEY TAN

Below is an example of a empty dbspace. 53 pages used where dbspace:TBLSpace taking up 50 pages initially. Dbimport would have resulted in dbspace:TBLSpace to grow and allocate more extents. Even though the database has been dropped, the TBLSpace would still be there and not remo…

Informix Cluster Pro Tip!

TOM GIRSCH

One I "earned" mere hours after earning the "It doesn't matter how many chunks you throw at it if the tblspace has hit 32 GB" experience. ------------------------------ TOM GIRSCH ------------------------------…

Are there hidden gotchas w.r.t. moving sysadmin tables?

Gaurav Kumar

Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…

Fast Recovery after correct shutdown

Paul Watson

When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…

Table or index partition? Flags in sysptnhdr

That's a great start, Art. However.... ncols == 0 does not mean it has no columns. In usual Informix style (I have always chided them for confusing nomenclature), ncols is actually the number of special columns, like blob or varchar. Indeed, for the table I arbitrarily picked …

How do I determine which edition I m running?

Carlton Doe

John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…

YIKES! 12.x documentation for onstat -g opn does not match the output

Hi Folks. I'm tyink I've managed to work around my ignorance of the sysmaster tables in relation to onstat -g opn. However, I have another hurdle here. Not critical, I think, but someone need to update this. Here's the sample output in the 12.0 Administrator's Manual: Even Pau…

index exclusivity

Sergio Peres

Thanks for replies, This is an old question I have about what is being used, there is the onstat opn option for open tables but I can't find any information about the interpretation of these values and results. As I have databases that have tables with different uses in clients, …

onstat -g opn: What sysmaster tables will get me this info?

Hi y'all. I have a situation here where we are trying to track down high-impact users and what tables they are hitting. I already have a query on sysptprof that tells me (if crudely) what tables are getting hit the most but that doesn't tell me who's doing it. Here's a sample o…

ADO - activex data object

DIRK MOOLMAN

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…

TBLSpace No more extent 8GB limit

Andreas Legner

The limit that's effective here is 2**20, i.e. 1M (1048575 = 0xfffff) pages per TBLSpace TBLSpace. (The 16M limit applies mentioned earlier applies to all other non-index partitions - while pure index partitions allow up to 2B(illion) pages.) Keep in mind how a 'partnum' (partiti…

onlog output

BOB KRUSE

Hi Jacques, I did use the command format to filter by tblspace partition number "onlog -t <partnum> -l". Your explanation makes sense. One would think all transactions that do not include the tblspace filter would be excluded. Perhaps the code scans sequentially through the tran…

Locked tables over 12.10

SERGIO PERES

Hi, I am having some difficulties to identify locked tables and records over my instance. I have looked over onstat -k and onstat -g opn results, but results are not very easy to understand. Can someone give some help with some code/script to identify those situations on readabl…

IDS 12.10 - temporary dbspaces locked

SERGIO PERES

partition 'testdbs:informix.TBLSpace' no more page

LUIS MARQUES

What is the result of "oncheck -pe testdbs | grep TBLSpace" for the "testdbs" dbspace? Either the TBLSpace reached the maximum number of pages for a partition (not likely) or the dbspace run out of free pages.…

listener-thread@soc_be.c:3073: err = -25582:

KARTHIK RAJAN

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…

CLOB cloumn data not reflecting in HDR seconday

Fernando

Weird output. -pS would show the entries for the smartblobs I think: castelo@stardust.onlinedomus.net:informix-> oncheck -pS sbspace | grep "Create Flags" Create Flags 0x31 LO_LOG LO_NOKEEP_LASTACCESS_TIME LO_HIGH_INTEG Create Flags 0x31 LO_LOG LO_NOKEEP_LASTACCESS_TIME LO_HIG…

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.…

Rovoke insert permission but still can insert

RAFAEL

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…

Onunload error opening TBLspace

LARRY SORENSEN

IDS 11.50.FC5 Solaris 10 - SPARC I am trying to do an onunload on a database. I have done this numerous times on other similar databases. On this database and a second database in the same instance, when I try to do an onunload, it starts to wright to tape (disk). After a while…

Erroc when dropping a table -- how to debug?

Andreas Legner

Hi Florian, in that af file, thread 1390 (session 762), is trying to drop the qfakt=20 table (partnum 600005), running on -242/-106. Searching the file for 600005 you'll find two hits in 'onstat -g opn'=20 output, for thread 1390 having the table opened twice. So something in y…

open tables

SERGIO PERES

How can I get on readable form the results from onstat -g opn? How can identify all the open tables and involved sessions? Thanks for any help, SP…

Reorganize the 'informix'.TBLSpace to allow for fr

LARRY

Solaris 10 IDS 11.50.FC8 We have been reorganizing and cleaning up one of our databases, and we have been able to delete several chunks that were no longer needed. Chunks in which the 'informix'.TBLSpace resides have been freed up as well, however the data is spread out and pr…

detached index rebuild question

Those indexes that are not fragmented or are fragmented with a different scheme than the table itself will be dropped and recreated. Queries and transactions that have been referencing that index will not fail but may run slow using different query plans until it is rebuilt. If t…

False non-exclusive access when select a table

ROGER VILCA

Hi Andreas, onstat -g opn previously saved (namely before restart) doesn't show any records for the partnums of table's indices. The partnums (for the table and indices) are in the outputs of onstat -C all and onstat -g ppf. Thanks. Roger…

Identify tables by session

Hello Sérgio, Not sure exactly what is the problem/question. If you don't have locks what is the concurrency problem? If I recall correctly your last question you were wondering how to force all the sessions to quit so that you could change some tables. In order to ALTER a table…

Case Sensitive DB & Oncheck

JACQUES RENAUT

Original post: I was able to use the sysadmin API to get some of the table data however I have 5 indexes on this table and number of keys is 0. I have opened a PMR to look into this. thanx, dan Response: When you have detached indexes, then when you check the data partition o…

Oncheck -pt

Jorge Valenzuela

Hi, I see a warning in log saying Run oncheck -pr 3149194 I rub the command, and get an Isam record not found Error opening TblSpace for reading. How can I resolve this ? Thanks in advance. Enviado desde mi iPhone…

12.10.FC6 Mac port released

John Miller iii

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)…

Slow Bulk Loading problem

OK, see my responses in-line below: Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG…

Different output of onstat -g opn in version 11.70

ROGER VILCA

Hi, I have noticed that the ouput of onstat -g opn is different according version of informix server: Versión 11.50 (FC8) and 12.1 (FC4) show the output in the following format: tid rstcb isfd op_mode op_flags partnum ucount ocount lockmode 78 0x0000000044d76768 267 0x00060000…

Open tables and threads

Using onstat, run onstat -u and grep for the non-zero digits of the rstcb column from onstat -g opn. This will give you the session id in column 3. Using sysmaster, convert the rstcb column value to decimal and search sysrstcb: select * from sysrstcb where sid = <the decimal rs…

Stuck transaction

An open cursor on a table may prevent ALTERs... even if done in DR... but onstat -g opn and onstat -k are able to show this... I've created a script to show who's preventing an ALTER... But in a really busy system it can be a nightmare. For that I'd recommend another RFE... which…

RSS not working

CLAYTON DAIGLE

-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…

VERY slow BTS index build

MICHAEL HOFFMAN

Mark, That is the kind of response times I expect from Informix. I have no idea why these builds are taking so long. It seems as if varchar works faster than char, but they take a few hours as well. This system is a fairly idle server, used for QA mostly. When the BTS build is r…

informix.LO_hdr_partn

BOYCHO VELKOV

Hi Marcus, We had the same problem a few months ago with Informix 11.50.FC9 on HP-UX with 4 chunks in sbspace 1TB of data. We did not have a time to open PMR(Case) because our system is 24x7. We find workaround to rename the tables with BLOB-CLOB column and recreate new t…

Informix upgrade

CHANATIP LAONGSIRIWONG

Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…

when use IfxDataReader.GetIfxDateTime to NULL valu

VINCENT

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.…

Query to identify session holding lock@table

John Miller

If you set the export IFX_DIRTY_WAIT=3D3 then all users currently readi= ng data must complete and close the table in 3 seconds. This env will no= t kick anyone out, but will prevent new users from accessing the table. = All current users must exit on their own or be kicked out. …

Backup Level 1 blocking smart blob

Marcus Haarmann

Hi, We have set up a relatively large database containing smart blob data (> 500 GB). There is 3 tables in the DB, which is the only one in the instance, all with some "standard" columns and one blob column in a separate sblob dbspace, which is spread over 3 chunks. We are runni…

Re: Error 104 - File descriptor... [29399]

Complementing... The way I will use to monitor the amount of this FDs , without sure if is correct or not.... # of open Files Descriptors. $ onstat -g opn | awk '{print $3}' | sort | uniq -c | wc -l 721 Check what FDs is + shared..... $ onstat -g opn | awk '{print…

Error 104 - File descriptor...

JACQUES RENAUT

Original Post: Complementing... The way I will use to monitor the amount of this FDs , without sure if is correct or not.... # of open Files Descriptors. $ onstat -g opn | awk '{print $3}' | sort | uniq -c | wc -l 721 Check what FDs is + shared..... $ onstat -g opn | awk '{p…

DB_locale or local naming convention

SANDIP SHINDE

Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…

sysptprof table

FRANK

Hello, I want to clarify the info in sysptprof.( see attached) (1) what numbers are stored in :isreads, iswrites, isrewrites? (2) pagereads/pagewrites are pages read from/write to disk(disk IO R/W), correct? (3) any relationships between bufferwrites and pageswites? Thanks, …

load from external table howto tune...

superboer7@t-online.de

Hello All, Database 11.70 on linux Is there a way to tune loading data from an external table?? When i run the select * from insert into in express mode it writes at a rate of 24 MB / sec while onpload untuned does 36 MB a sec and onpload overtuned does 150 MB /sec I verifie…

Map temp tables to session

mmuraskiny@gmail.com

On Wednesday, December 26, 2012 2:16:37 PM UTC-5, mmura...@gmail.com wrote: > On Wednesday, December 26, 2012 1:12:14 PM UTC-5, DA wrote: > > > Hello, > > > > > > > > > > > > We are running informix 11.50.FC6X5. Is there anyway to map temp tables back to the original session tha…

Error -556 on @ reference

eferreyra

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,…

onstat g opn - lockmode

Hi , Ifx 11.50 FC9X6 , AIX 6.1 (with 1 RSS read-only synchronized) Monitoring the instance , I'm trying figure out why one stock historical table persists keep 60% of the table size into buffer pool a few days (checking with onstat -P) (60% = 10GB). So, I'm looking some histori…

242: Could not open database table

Got it. That explanation opens a couple of ideas: 1. Recreate the table with seven daily partitions. Each day add a new partition for that night's data load. On the weekend detach the oldest 5 partitions (actually you could pre-add the new partitions for the following 5 days …

Someone have a technique to alter tables with FK ?

Cesar Inacio

Hi, 11.50 FC9X6 , AIX 6.1 We suffer with one situation at our production where just not found a acceptable way to work yet... I already open a PMR (for me this is a defect) but for IBM support is just "work as design" .... so, no solution... Just a correction / better documenta…

Someone have a technique to alter tables with FK ?

Hi, 11.50 FC9X6 , AIX 6.1 We suffer with one situation at our production where just not found a acceptable way to work yet... I already open a PMR (for me this is a defect) but for IBM support is just "work as design" .... so, no solution... Just a correction / better documenta…

Re: index in use when any SQL access it...

Executing more tests, I found the reason... The index, is opened when is executed a "prepare" of one SQL over the table. Is a simple SQL, what filter 2 fields and one of them is part of the this index. When this prepare is executed , five indexes are put "in use" (the table hav…

Re: index in use when any SQL access it...

Executing more tests, I found the reason... The index, is opened when is executed a "prepare" of one SQL over the table. Is a simple SQL, what filter 2 fields and one of them is part of the this index. When this prepare is executed , five indexes are put "in use" (the table hav…

index in use when any SQL access it...

Hi, ifx 11.50 FC9X6 , AIX 6.1 I'm looking about use of indexes on some tables. The mainly objective is check if this indexes still needed and who use it. Then I using the commands bellow (in my own scripts) to try reach my objective: onstat -g opn onstat -t onstat -g ppf T…

index in use when any SQL access it...

Hi, ifx 11.50 FC9X6 , AIX 6.1 I'm looking about use of indexes on some tables. The mainly objective is check if this indexes still needed and who use it. Then I using the commands bellow (in my own scripts) to try reach my objective: onstat -g opn onstat -t onst…

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…

HDR - Alarmprogram when down

OK, so the log message on the secondary is indicating that a bad rowid in a log record could not be rolled forward. That's bad. Yes, try dropping all of the violations tables, but first you have to STOP VIOLATIONS FOR <tablename>; then you can DROP TABLE <tablename>_vio; DROP TA…

enterprise replication time to replicate data

KARL OLIVER

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 …

Informix Locks On Select count(*)

Hello, Art already explained it, but we can go a bit deeper... Short answer to your question would be "no", but that would hide how things work. Informix keeps the number of records on a table (or partition) in the partition header. When you do a simple "SELECT COUNT(*) FROM tab…

Cannot drop temp table in rootdbs

jrenaut

On Aug 22, 3:32 pm, red_valsen <red_val...@yahoo.com> wrote: > I noticed in an onstat -d output that our rootdbs, which is usually > empty, had jumped to 96% full. Using AGS's Server Studio, I could see > a temp table called username._temptable in rootdbs. I could also find > t…

Help! Broken server destroys customer demo...

Obnoxio The

On 03/08/2011 12:26, NEIL HAUGHTON wrote: > Here's some more information, the output of an oninit -v command: > > Checking group membership to determine server run mode...succeeded > Reading configuration file > 'C:\\\\PROGRA~1\\\\IBM\\\\Informix\\\\11.70/etc/ONCONFIG.ol_matdemo'…

Over 1,000 days of 24x7 database uptime!

Christian Knappke

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…

enterprise replication log usage

KARL OLIVER

my oncheck came back with error after printing 4750 lines ERROR: TBLspace number is invalid '0x2'. Any ideas on this please ?…

Setting up HDR- First Time -11.70 Innovator-C

SUNIL PAWAR

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

SUSHANT KODE

Hi All, Following is the error which we getting when we try to run the below query. QUERY: insert into op_vehicle_color (typsoacode, make_color_id, color_order_code, color_info_date) select tsaf.TypSOACode, sa_farben_id, sa_farben_bestellcode, sa_farbinfo_vom from uno_test2_ro@…

Cannot alocate Physical Log

JULIO FLORES

HI I have a 9.30FC2 instance under Solaris and after a power failure crash, I try to put on-line the instance, but it fail with the message 'Cannot alocate Physical log 50000 avalible 23650'. I check with 'onstat -d' my rootdbs chunk: 146a6e028 1 1 1 75000 68730 PO- /infx_psam…

InnovatorC Bug ?

Sounds like a bug in oncheck. Call IBM and open a case. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advance…

Tool to estimate the size of an index

JOSé LUIS CABRERA SACCO

Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…

Can't access sysindexes remotely

SHAHZAD SALAM KASI

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…

open files limit in IDS 10.00.FC9

GERARDO PADIERNA

Hi, I wanted to know the actual limit of opened file descriptors on IDS 10.00.FC9 on solaris 10. The reason is that I get error messages 211 and 101 (well the client application gets them): -101 ISAM error: file is not open. I searched around for possible causes and found this li…

Online Index Build and HDR

Davorin Kremenjas

> Any suggestions on setting the LOG_INDEX_BUILDS ONCONFIG parameter in an HDR > environment and online index builds or the ONLIDX_MAXMEM ONCONFIG parameter? If I remember correctly from few months ago on our test system (in HDR) we had to set LOG_INDEX_BUILDS to enabled to have…

TBLSpace tblspace....

WILL LANDSTROM

Hi everyone. I have a question regarding the "TBLSpace tblspace". I know that each individual chunk as a portion that is know as the "TBLSpace" that tracks the individual tables within a particular chunk..but..if you were to run the following example sql against the sysmaster dat…

Re: Drop table from temp dbspace

jrenaut

On Feb 18, 4:08 am, Jose <joseph...@gmail.com> wrote: > Hello, > > Have a situation were one temporary table is not getting dropped > automatically from the temp dbspace. Table name is start with _ > (underscore). Table name is _temptable. > > Number of extents for this table is …

Error with TBLspace

Schleicher, Keith

I ran an oncheck -cD on a database and it comes back with this: Error opening TBLspace ps_sls_rpt_ext_cs. Since it is a test system, it isn't backed up frequently. I want to do a dbexport on this database. Can I unload the data to a file and drop the table and see if it continu…

Informix Dynamic Server Software Downloads

Plugge, Joe R.

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…

Many sessions in IDS 7.31 cause problem!!

MARS CHEN

Dear All.... Thanks for all who gave me very helpful information ... After days of test , now I can figure out the real reason cause the problem .... I've a IDS called IF8 , another IDS called if12 ,both IDS are 7.31.UD8 running in RedHat , In my case , I've hundreds of esql/c …

Dropping temporary TBLspace 200464, recovering

MARS CHEN

Dear All.... I've noticed that while I onmode -ky IDS(my case,IDS 7.31.UD8) , I got the messages in online.log : Dropping temporary TBLspace 200464, recovering 8 pages. Dropping temporary TBLspace 200465, recovering 8 pages. Dropping temporary TBLspace 200467, recovering 8 page…

too many open cursors in one table

For a queue table like that, assuming the number of rows is about the same from one day to the next, I would run an UPDATE STATISTICS LOW... DROP DISTRIBUTIONS after the load at 8:30 and NOT anytime between the delete and the reload. Without distributions, IDS will use the older …

dbspace utilisation in Informix 5x

RALPH GENTRY

The manual is unclear as to how the engine goes about "checking/verifing" the chunk free list and corresponding free space and tblspace extents. If errors are encountered and the tables are updated then there will be some row locking on some of the system tables.…

OPTCOMPIND and perl

Nog

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…

Truncate Table fails with SQL error -242 ISAM -106

PRADEEP KUMAR

Thanks Uday. I didn't see any reference of the table in the onstat -g opn. Do we have any system table ( or query based on system tables ) which could display this information..? regards,…

Informix Dynamic Server Scheduler question

MARKO BATELIÄ

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 …

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…

RE: 10.XC10 - Extent size modification

Jack Parker

If you partition on a monthly basis (add one partition per month), then your problem would appear to go away? cheers j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Zachi Sent: Thursday, March 19, 2009 7:47 …

10.XC10 - Extent size modification

Jack Parker wrote: > A feature request I made shows up in this release of IDS. Going through the > documentation yesterday, the reasons for the feature are mentioned in > passing but not really explained. I thought I'd take the opportunity to do > so here. > > As you may (or ma…

Re: As the markets tank... Some Benchmark Stuff to distract you

DA Morgan

Obnoxio The Clown wrote: > DA Morgan wrote: >> Obnoxio The Clown wrote: >> >> >>> Every single piece of Oracle software has a direct counterpart in >>> open source too. >>> >> >> That it total nonsense and if you don't know that you need to find >> another profession. You will no…

use stored proc that return multiple columns in a query

brenddie

forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…

Re: As the markets tank... Some Benchmark Stuff to distract you fromthe collapse...

DA Morgan

Obnoxio The Clown wrote: > Every single piece of Oracle software has a direct counterpart in open > source too. That it total nonsense and if you don't know that you need to find another profession. You will not find open source counterparts to almost all of Oracle's features m…

[141] error: tblspace table overflow

SHAN SEAN

Hi, every body. unload data from table, but interrupt by error [141]. finderr 141 tblspace table overflow, say it can be resolve by turning The TBLSPACES parameter of the ONCONFIG file sets the limit. but in the onconfig file, I can't find the parameter TBLSPACES, and manual of I…

installing informix dynamic server in linux

jayasakthi.t@gmail.com

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…

A question about "TBLSPACE TBLSPACE"

MARS CHEN

Dear All... while I run "onmode -pe" , I see a lot of tables and their extensions , I know what "physical page","logical page","Partition partnum" means , for example, the partnum of stores7:customer is 0x200251 , it means that the partition page of stores7:customer is in dbspac…

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

Art S. Kagel (Oninit LLC)

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…

b-tree scanner tuning and expected behavior

GERARDO

Hi, I guess it's solved now: but just changing the parameters didn't stop the btscanner activity. First I had to stop all threads, then I started two threads with: onmode -C start 2 onmode -C threshold 500000 onmode -C rangesize 100 and it's running fine now for about 5 days with…

CONFIGURATION ONAUDIT-IBM Informix Dynamic Server

Liliana

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…

How to use Informix Dynamic Server

BINDU SIVAJI

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.…

drop a dbspace problem

Art S. Kagel (Oninit)

SHAN SEAN wrote: > hi, everyone, I want drop a dbspace(it have 4 chunks) use onspaces, I create > some fragment index on it before, but I drop those index later, so I confirm > there is nothing on it, but when I user SMI query : > No problem. Every dbspace is created with a TABL…

Temp table session

MIKE MAGIE

If the query is actively running and you do not know which session is creating and filling the temp table(s) you can run onstat -g opn. In this output you want to look for tables created in your temp dbspaces. For example in the below output: IBM Informix Dynamic Server Version …

Problem with extents on big table

Clifton Bean

If you have the space, Jacques, leave the table where it is and rename it. Create your new dbspaces, then perform the "create table". You might want to look into the use of RAW and STANDARD tables ... might save some hassles with the data movement. Now all you have to do is "in…

An Informix Positive Point

Ian Michael Gumby

> From: indeep@indeep.com > Having the code is a _nice-to-have_ but certainly not necessary. SE is a peer > with MySQL, therefore it follows to have it as an alternative. However, this > opportunity is fading as MySQL now has stored procs, and partitioning. The > window is cl…

foreach and open descriptor

TBP (The Big Potato)

jprenaut@yahoo.com wrote: > On Feb 18, 4:20 pm, vomari...@yahoo.com wrote: > >>hi, >>i'm executing routines containing foreach ... end foreach >>instructions. it seems that after many execution >>onstat -g opn shows a great number of lines and my session hangs. >>what's could be …

update statistics at the same time

Robert Roussey(IT)

I've done it: - I had 5 dbspaces on 5 different spindles - generate lists of tables by dbspace (partition number) - started 5 scripts to process those lists of tables in parallel Worked fine, no problems. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Rousse…

DROP chunk error.

NETSKY LIAO wrote: > Hi,all > > While I want DROP a CHUNK(/usr/informix/disk/wjfl3) from the DBSPACES,I had > drop the tables which in the CHUNK. These have > > TBLSPACE TBLSPACE 435002 50 > > FREE 435052 89235 > > report from oncheck -pe, So when use "onspaces -d <dbspace> -p <c…

oncheck -cD ERROR

Keith Simmons

On 21/01/2008, BART GROOT <bart.groot@corusgroup.com> wrote: > Hi All, > > When running oncheck -cD on our database the following error message is > returned: > > ERROR: Count of version 0 data pages 0 != pnv_pages -40 > Reset partition data? > > After entering Y and rerunning th…

Light append partition after onpload

John Miller iii

Inserts are allowed to a table which has been appended to if a successful archive has been taken after you done a light appended. Error -197 is only used once and does indicate that the server believes a light append has occurred after the last level 0 archive on this tables. If …

What is IPA abbreviation ?

andrei.onica@gmail.com

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…

IIUG TV

Tool

Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…

Re: Informix beats Oracle

DA Morgan

Ian Michael Gumby wrote: > > > >> From: Fernando Nunes <spam@domus.online.pt> >> http://www.oracle.com/database/product_editions.html >> >> And guess what... We don't get the following in EE: >> >> - RAC (obviously) >> - Database Vault >> - Oracle Advanced Security >> - Label bas…

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…

problems with Informix dynamic server 9.4 @ WIndows 2003

Kai Zhu

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: No SYSTABAUTH Record for TBLSpace ...

Clifton Bean

Never mind. I believe I simply need to add a table-based grant statement for the tables which recorded this type of error. Take care. Clifton _____ From: Clifton Bean [mailto:cbean@ctm.com] Sent: Saturday, January 20, 2007 5:20 PM To: 'ids@iiug.org' Subject: No SYSTABAUTH Rec…

No SYSTABAUTH Record for TBLSpace ...

Clifton Bean

ONLINE 5.20.UC3 AIX 5.2 I am getting several of the following type errors when running tbcheck cc this evening: ISAM error: no record found. WARNING:No systabauth record for TBLSpace root.wait_ix. TBLSpace name wait_ix Owner root TBLSpace number 4000164 Tabid 848 Row si…

RE: need help - infformix is down - restart got index failed

Sebastian, Norma J.

OK Neil, I ran an experiment....... hsap10% oninit -v ........ Initializing 127 flushers...succeeded Initializing log/checkpoint information...succeeded Opening primary chunks...succeeded Opening mirror chunks...succeeded Initializing dbspaces...succeeded Validat…

License Extension

dhaya.snidhi@gmail.com

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…

Re: tblspace tblspace extent size calculation for

ART KAGEL,

You'll need one page for each table or index fragment in a dbspace. So, if you can guestimate how many tables/indexes/fragments you will ultimately have you can figure it out fairly precisely. Otherwise, ... Art S. Kagel ----- Original Message ----- From: Peter J Diaz De Leon <i…

tblspace tblspace extent size calculation for IDS

Peter J Diaz

Does there exist calculations (or rules of thumb) for determining what the initial and next tblspace tblspace extent sizes should be for both the Root dbspace and non-Root dbspaces. Thanks Peter…

Re: Security Vulnerabilities Addressed in Informix Dynamic Server

me

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…

Security Vulnerabilities Addressed in Informix Dynamic Server

Paul Watson

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…

RE: Assert Failure

what could have been the problem Looking through the various AFs 02:10:26 Assert Failed: pthdrpage:ptalloc:bad bfget 02:10:26 Who: Session(11, root@rp4440, 0, -2132966728) Thread(200, xchg_1.9, 80db4500, 4) File: rspartn.c Line: 5408 02:10:26 …

ids 9.4 select output format

roger@star2000.com.tw

Hi informixer, I issue a SQL command in ids9.4: database sysmaster; select * from sysextents; the output look like : dbsname rootdbs tabname TBLSpace start 1048589 size 50 How can I make the ouput format like ids 7.x : dbsname …

Initialising Informix

mchivaviro@okzim.co.zw

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?

mzahidkilic@gmail.com

How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…

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/…

Fragmentation Elimination Problem

Curtis Crowson

I am on version IBM Informix Dynamic Server Version 10.00.FC4.…

Re: Informix Dynamic Server 9.30 - Shared Memory

Jonathan Leffler

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

Barry Leb

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

Ronald Schwingel

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

ch

Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…

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

mweallans@panacea.co.uk

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 …

AW: number of extents

Model-Bosch, Tilman

Bill Hamilton asked: > Should I try to get the number of extents down on system tables? > Also, on automatic indexes, when should you worry about how many extents > they are in? Art S. Kagel responded: > Not to worry. All system catalog tables are cached in the data dictionary …

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

Reddy

Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…

locating sequential scans

Jeff

Our IDS 9.21 system has developed some performance problems lately. It used to handle the load just fine, but it's really been chewing up the CPU and disks lately. It's a transactional system mostly reading/updating single rows at a time. My stats show a non-trivial number of seq…

Non-Exclusive Table Usage

Andrew Ford

Try the following script: DATABASE="$1" TABLE="$2" PIDS="" echo "session id username hostname pid" PARTNUM=`echo "select hex(partnum) || \\\\"|output\\\\" from systables where tabname = \\\\"${TABLE}\\\\"" | dbaccess ${DATABASE} 2>/dev/null | grep output | cut -d '|' -f1 | s…

IDS 10 systables missing

funderburg@gmail.com

After upgrading to 10.00.UC1, I keep getting these errors on *some* of the databases: 311: Cannot open system catalog (sysdirectives). 135: ISAM error: TBLspace does not exist Would this be because the databases didn't upgrade properly? If so, short of downgrading the data…

Re: IDS 10 Express Edition

hwang fu via DBMonster.com

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…

oncheck -cc errors

jda

I have had a script running the following command for years and since we upgraded to 9.4 I'm getting errors. We have IDS 9.40.HC3 on a HP-UX 11i 4 cpu box. oncheck -cc -q cars ERROR: informix.systabauth nextsize 664 != tblspace.nxtsize 64 TBLspace name sys…

Re: dropping chunk

Tsutomu Ogiwara

Sorry Jonathan and all. I read the release note, and mentioned as below. 1.4.2.3 Managing the tblspace tblspace You have enhanced flexibility in managing the tblspace tblspace. The tblspace tblspace is a set of pages that describe the location and structure of all tblspaces in…

Re: dropping chunk

Tsutomu Ogiwara

Sorry Jonathan and all. I read the release note, and mentioned as below. 1.4.2.3 Managing the tblspace tblspace You have enhanced flexibility in managing the tblspace tblspace. The tblspace tblspace is a set of pages that describe the location and structure of all tblspaces in…

Informix Dynamic Server information Centre