Oninit® Archive
Results for “TBLTBLNEXT”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
script to check status of dbspaces & chunks
Hi All, I need to write a shell script to check the status of all dbspaces & all chunks of an instance & send an email if any of dbspaces/chunks got corrupted/dropped/inconsistent etc Can any body help me in this regards? Regards…
Table Extents
Happy New Year to One and All !! Chit-chat over, on with the problem !! OnLine 7.24.UC5 HP-UX 11 Its that time of year when DBA's accross the world are establishing how fragmented our systems are and whether or not its worth re-jigging a few of the big tables. I am no exceptio…
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
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 ------------------------------…
Large memory segment vs smaller ones
No ONCONFIG changes are required. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
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 ------------------------------…
Want to DROP an empty rootdbs chunk
Ahh, OK, got it. So, here is what I know: A rootdb chunk may be non-dropable for one of two reasons: The first being there are databases or tables defined in it or having extents there (but residing initially elsewhere). If you have verified (using oncheck -pe) that there are not…
A lot of extents in temp tables
No, there isn't. Is the large number of extents causing a problem? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
nb of extents ?? dbschema vs oncheck
John: The reason is extent compression. If a new extent is contiguous with an existing extent they are combined into a single extent. But the next size only doubles after 16 extentsat the current size. Art ------------------------------ Art S. Kagel, President and Principal Consu…
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…
Table Extent Size calculation
Hi Amit, While a formula has been provided for you, it might be worth pointing out that there is little benefit in spending loads of time on this, unless you use version 11.50 or earlier. Some of the advice given above would appear to relate to these older versions. In recent ver…
IDS Bug of the Day: DBINFO
T32768: DBINFO(DBSPACE) RAISES 727: INVALID OR NULL TBLSPACE NUMBER https://www.ibm.com/support/pages/node/6207160 ------------------------------ TOM GIRSCH ------------------------------…
Table and index defragment
Hi Art, My problem are tables with too many non-contiguous extents and their reorganization. SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------…
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…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
Fragments and Extents
Hi, I am facing some problems with some tables that are growing fast and getting fragmented. I have looked for some kind of procedure to identify and correct this. Can someone give me some help to solve this problem? Thanks in advance, SP…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
onlog output
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…
IDS 12.10 - temporary dbspaces locked
Hi Luis, Thanks for your reply, I am using this SQL code: select owner, username, hostname, dbsname, tabname, type from syssessions s, syslocks l where sid = owner and tabname not like "sys%" it return this: 34015|bduser|joaomendes.dominio.local|tempdbs|TBLSpace|IX| 34015|bd…
Table extents differences on recreate
Original post: When I recreate a table using the 'create table....as select from...' syntax, the new table gets created with the extent size/next size of 16/16. The original table has 13 extents, however, the new table is in 2 extents. This would not surprise me if the original …
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…
partition 'testdbs:informix.TBLSpace' no more page
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:
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…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
CLOB cloumn data not reflecting in HDR seconday
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…
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…
Onunload error opening TBLspace
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…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
CREATE INDEX from a HUGE TABLE
Kern: FYI, since v11.70 the limit on the number of extents has virtually vanished. That limit was imposed by the fact that prior releases had to store all of a table's details (special columns, extents, attached index keys, row and page counts, etc.) on a single page. So extents…
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?…
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 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
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…
Reorganize the 'informix'.TBLSpace to allow for fr
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…
Informix limitations
Hi to All please, where to find different informix versions limitations (nb max of pages, extents...etc ? thanks in advance…
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Check list to Add a new instance
Just two more things: 1. set SERVERNUM to a unique number (at least unique on that machine). 2. Set ROOTPATH to a unique file 3. Create the ROOTPATH file 4. Optionally set the TBLTBLFIRST and TBLTBLNEXT parameters in the ONCONFIG file to set the extent sizing for the tablesp…
Oncheck -pt
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
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)…
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.…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
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,…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
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…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
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…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
virtual segment question
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
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…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
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?…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
Warning: The storage pool is out of space
Aren't these purely to control the tablespace tablespace, leaving them at zero means the engine will control the tablespace tablespace extent sizing/growth Cheers Paul > But I have read in the documentation that if both TBLTBLFIRST & TBLTBLNEXT > parameters are set to zero, the…
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.…
repack
In IDS11.5 , I want to to do reorg. if a table has 2 extent,Do repack can reduce the extent to 1? thanks for your time.…
How to set up temporary space per session
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
recover SQLHOSTS file
Do the onconfig files also have that info?…
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
server1 - Informix Database Space has exc
Hi, In case you run into a TBLSPACE out of extents, there is no way to reorganize this but to put databases into a different tablespace using dbexport/drop/dbimport. You cannot create new tables/databases in this dbspace when the limit is reached. Check your extents using the f…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
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,…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
Re: help with informix on windows oncheck -pr erro
ok sounds like silly question but how do i find out what ONCONFIG variable is on windows ? which is likely to be correct set ONCONFIG=oncfg_apecert.0 ::set ONCONFIG=ONCONFIG.apecert…
dbimport logging how to stop
yes extent sizes being used extent size 600000 next size 60000 lock mode row;…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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…
Out of extents. But ...
IBM Informix Dynamic Server Version 11.50.FC8X3 on HP-UX 11.31 We have a table that has run out of extents. And indeed it has; the last 11 added have been absolutely tiny. Until those last few the extent size kept doubling until the last 11. Then they were tiny. We would like t…
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 …
Informix inserts get slower
Hello, We are running 11.50.FC8 on SunOS 5.10. We have a application which writes to 2 instances of Informix, one instance is a simple standalone server while the other instance is on HDR and has a Secondary and RSS attached to it. The problem is with one table (lets call it tqh…
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
RE: Re: Extents problem
Set TBLTBLFIRST to the number of pages currently in the TBLspace partition and TBLTBLNEXT to about 25% of that. Art On Jan 9, 2012 11:30 AM, "Marcus Haarmann" <marcus.haarmann@midoco.de> wrote: > Thanks for your input, is there a formula to calculate the first/next > size of a …
Extents problem
Please define proper TBLTBLFIRST and TBLTBLNEXT parameters if you initialize your instance. Regards. On Mon, Jan 9, 2012 at 4:20 PM, Art Kagel <art.kagel@gmail.com> wrote: > You have to unload all of your databases, initialize the instance and > recreate all of your chunks, log…
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 …
extents size
hi, Knowing the size of a row and the number of rows, is there a method to appreciate the true value of the extents' size of a table ? thank's…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
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…
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…
TBLTBLFIRST/TBLTBLNEXT
Hi, Which scene do I need to set TBLTBLFIRST/TBLTBLNEXT parameter from IDS 10?…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
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…
enterprise replication log usage
my oncheck came back with error after printing 4750 lines ERROR: TBLspace number is invalid '0x2'. Any ideas on this please ?…
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
Jack Parker Wrote: ================================================================================ Not sure if you noted that you also need to change your $ONCONFIG = ROOTPATH to point to what is on the backup image. j. ==========================================================…
Cannot alocate Physical Log
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…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
Problem with ONBAR: unusually slow on IDS 11.50.FC
Thanks Art, I did suspect the tablespace tablespace. It is true that there are a lot of dbspaces (around 150 dbspaces). This is historical. Since it is in production and the sizes are large, we will try to reorganize the appropriate dbspaces to shorten the downtime. The client…
Table size and extent mgmt.
I have a table that is as follows; -------------------------------------------------------------------------------- Table Information -------------------------------------------------------------------------------- table name: rsddstataggrdef dbspace: psapstab rows: 12612601 …
Physical Log Size
How did you "increase" the size? You can only do that song onparams. You cannot do that just by changing the Onconfig file Art On Jan 25, 2011 12:10 PM, "KENT GRUNDEN" <k.grunden@hoogwegtus.com> wrote: > IDS 11.50.FC4WE Windows Server 2008 64bit > > I keep getting the message wh…
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 …
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…
rootdbs size
The problem, as someone already mentioned, is that you cannot position the physical log in a different dbspace during server initialization since only the rootdbs will exist at that time. Change PHYSFILE to something rather small (less than 300MB) and remove the no longer support…
Re: Calculating extent sizes
On 2010-11-15, JonnyTDI@Usenet-News.net <JonnyTDI@Usenet-News.net> wrote: > > Extent size "doubling" ... i.e. you loaded a table which had an initial > extent size of 131072 ... extent 1 filled up and then the server > allocated a new extent and as it was able to allocate contigu…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
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…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
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…
Re: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
TBLSpace tblspace....
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: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
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-claim un-used space
Hi, How can we re-claim the unused space in Extents/Chunks ? Hence, why the database allocates 6 Contiguous Pages for an Extent ? Does allocation of new pages in an Extent require 6 Contiguous Pages required everytime ? Thanks…
How to Change sysdistrib tables extent size?
Hi, How to Change sysdistrib tables extent size during creation of a database or instance itself? FYI.Checked already sysmaster.sql.…
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
alter table modify next size and update Statistics
Hello all after altering the next extent size of a table, is it recommended to run update stats over the table? thanks tom…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
Extents Calculation
Hi, IDS 11.10 FC3 on Solaris 10 I am doing a Reorg activity on few tables for which i need to calculate the first extent size. I tried the calculations below & got it right for some tables and not so accurate for others. ROWs to be inserted in new table to be created: 73462 M…
table Extent
Hi All, I run oncheck -pt command & found that in few of the tables we have more 15 extents, moreover I have found that in one table we have 211 and some them having 35+ extents. Is tables with too many extents can have a negative impact on Informix response times since data is…
Extents Monitoring
Hi, We are using IDS 11.50.FC3W1. I would like to know what is the correct method to identify the number of extents allocated/remaining for a particular table / index ? Does the page size effect the calculation for the extents ? Is there any relation between index and extents a…
Error with TBLspace
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…
Extents Monitoring
Hi, We have a critical situation in our production db as far as remaining extents for a table is concerned. The error message shows that there are no more extents remaining in a table. Problem Statement: ------------------- According to the above mentioned formula, it means that…
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…
Dropping temporary TBLspace 200464, recovering
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…
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…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
Create index errors
Sorry - bad bit of reading on my part! Could it be number of extents/extent size for the index?…
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."…
dbspace utilisation in Informix 5x
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
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…
Buffer Turnover Rate question
How does one go about 'estimating' this? The performance documentation says to "set the value of buffers to between 20 and 25 percent of the number of megabytes in physical memory." - since I have 8Gb total physical memory, if my math is correct, that means between 819200 and 102…
myschema and extents
Have to migrate an IDS 9.30 from Debian over to an 11.50 on Suse. Lots of tables have more than 20 extents so i thought it would be a good idea to reorganize them during the migration. Played with Art-s myschema hoping it would issue CREATE TABLE statements with appropriate exten…
Data Compression
Sorry, I forgot to mention which you must check the next extent size and the first extent size of the table, and modify them with "alter table x modify extent size yKB" and "alter table x modify next size yKB" for the first and next extent size. Thanks Again!…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
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.…
Free pages count does not increase after deleting
Hello, Thank you for your fast response. You were right, after an 'ontape -s -L 0' to /dev/null, the free pages count increased. However, I have been purging old data whilst new data is still being inserted. As such am I right in thinking the cleared pages will only be marked a…
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 …
Buffer Turnover Ratio (BTR)
The Outputs are as follows onstat -g iov IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 20 days 02:38:57 -- 1548288 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors tempops msc 0 i 0.7 1147469 0 0 0 1144991 1.…
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 ?…
sysdistrib extents reach max
Hi, Found that database.sysdistrib table extent numbers reach max.How its possible to reduce the extent numbers? Thanks in advance.please advise. rgds Raja…
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…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
ER Error Enterprise Replication
bozon wrote: > Enterprise Replication is giving the following message when I do a > simple cdr list server > > ndl12:ndl12a common_reporting$ cdr list server > SERVER ID STATE STATUS QUEUE CONNECTION > CHANGED > --------------------------------------------…
Poor Performanc with Multiple DB's in one Instance
2009/1/30 ANEES AHMAD <aanees@i2cinc.com>: > Hello, > > Please see my comments below. > > What OS and what versoin of IDS are you using? > [Anees Ahmad] We are using SunOS CA-MCPDB2 5.10 Generic_125100-09 sun4v sparc > SUNW,Sun-Fire-T200 and the IDS version is 10.0. It's a 6 core…
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
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…
consolidate extents
Hi all, - To consolidate the extents of the table: ALTER FRAGMENT ON TABLE name_table INIT IN name_dbspaces_new - To consolidate the extents of the indixes ALTER FRAGMENT ON INDEX name_index INIT IN name_dbspaces_new My query is to know the advantages and disadvantages of th…
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…
[141] error: tblspace table overflow
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
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…
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
A question about "TBLSPACE TBLSPACE"
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…
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…
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…
drop a dbspace problem
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 : database sysmaster; select dbinfo("DBSPACE", pe_partnum) dbspace, dbsname…
Out of extents
Hi, on our development system, we get an out of extents error when altering a specific table (add a column). I have queried for extents in sysmaster:sysextents and get a strange result: dbsname HASHTEMP tabname th_overflow_ffffffffffffffff (count(*)) 710 dbsname sysadmin tabnam…
How to get total number of extent size for a table
What command can be used to obtain total number of extent size allocated for a table?…
Heavily fragmented indexes
The database I am loading is suffering a huge amount of index fragmentation in spite of all the data fitting comfortably into one extent per table. The problem seems to be exacerbated by the schema having a large number of VARCHARS, such that the size of the data (and hence the e…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
DROP chunk error.
Hi Netsky, The tblspace tblspace entries are not tied to databases, but rather dbspaces. Any database object, for any database in that dbspaces is represented in the tblspace tblspace. As you get more datbasee objects, you get more tblspace tblspace entires, which eventually lea…
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…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
Extent DB
After reading a lot in the docs I did'nt find an answer and try to get an answer here. I have an IDS10 with one dbspace on a single disk with one database in it. What can I do if the disk is full ? As far as I know I can't resize a dbspace nor span a dbspace on more disks ? Is th…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
Too many extents
it will recount the extent size and next size for tables when you execute the dbexport command.…
Re: Strange error when initialising (long)
i guess file /informix/data/ returns a directory oninit: Cannot open chunk '/informix/data/'. errno = 21 > ROOTPATH /informix/data # Path for device containing root dbspace -----------------------------------------^^^^^^ should be a file or better a char mode raw dev …
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…
Free Extents
I am running IDS 9.40 on a Unix box. I have a dbspace configured with 5 chunks. In this case we will call them Chunk #5,6,7,8 and 9. This particular dbspace is dedicated to one large table. I recently deleted millions of rows from this table. My question is, how do I determine …
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 …
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
shared memory not initialized
Please try disable randomization of the virtual address space. On CentOS and RedHat 5 this can be done for a new shell: setarch i686 -R sh or setarch i686 -R -L sh from which IDS can be started. On some CentOS and RHEL5 systems users reported shared libraries are loaded near…
oninit -i failure
Found the problem I had $ONCONFIG=/opt/informix/etc/onconfig. Should have been $ONCONFIG=onconfig On Aug 8, 2:03 am, tom.pri...@gmail.com wrote: > I'm trying to startup informix for the first time on a CentOS 4.5 > server. When I run oninit -i , I get the following error: > > …
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…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
RE: Extent size limit (again)
modify your NEXT EXTENT size to something smaller…
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…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
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: Mapping cpuvp's to IBM virtual processors on p
On Thu, 2007-02-22 at 16:35 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > Your assumption is partially correct. You don't NEED all 6 CPU's allocated to > CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to > CPU > VPs as needed so it's possible that one …
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…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
RE: No SYSTABAUTH Record for TBLSpace ...
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 ...
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…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
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 …
Freeing Extents
Hello, Is there any way to free extents allready claimed by a table after removing data from said table? Running out of disk space for a table and I wish to delete an ammount of data. IFX 10.0UC5 Thanks for the advice, Tam.…
Re: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Fragment by expression and extent size
Hi, When I try to fragment a table, how to specify the extent size and next extent size. Thanks Sven…
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…
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Extents resizing
On 4 Oct 2006 19:37:18 -0700, calyanram@hotmail.com wrote: >Hi > >i am able to create the extents what i need but >if specify first extent as 5000 it is taking as 2500 , >if i specify 6000 it is taking as 3000 > >why > >and what is the reason? When you specify extent size in db…
Re: Not able to increase the extent size?
calyanram@hotmail.com wrote: > I am not able to increase the extent size , next size beyond a > particular > level even if specify more number > > what to do? > example > create table test (with 200 columns ) extent size 3902 next size > 1858692 > > > what to check? > Actual siz…
Re: Not able to increase the extent size?
On 3 Oct 2006 03:57:09 -0700, calyanram@hotmail.com <calyanram@hotmail.com> wrote: > I am not able to increase the extent size , next size beyond a > particular > level even if specify more number > > what to do? > example > create table test (with 200 columns ) extent size 3902…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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…
dbimport EXTREMELY slow
Quman said: > > I am doing dbimport with IDS 10UC5 on AIX 5.3. > > Watched, > > large number(100,000+) of dirty pages were SLOWLY written to disk. > > piece of online log, > > 20:08:47 Maximum server connections 0 > 20:08:47 On-Line Mode > 20:15:15 Fuzzy Checkpoint Completed: dur…
Maximum Extent size
I am using IDS 7.31 and I have a big table which is now 22gigs in size. It now has 60 extents and I need to unload and recreate the table again. What is the maximum extent size I can create and the next size of the extent.…
Re: tblspace tblspace extent size calculation for
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
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…
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…
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
Re: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
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…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
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…
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
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
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 …
Extent Query
Is there any (simple) way to find when an extent was created, or which extents were created on a particular date? TIA Gary March Unix System Administrator NIB Health Funds Limited 384 Hunter Street Newcastle NSW 2300 PH. 02 4921 2466 Fax 02 4925 3548 Mobile 0418 412 390 E-mai…
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?…
How do it get writes form the lrus in V10
Thanks to everyone for our response. I now understand that having all chuck writes is ok. Nilesh Ozarkar wrote: >> I think I should be getting LRU writes. >> > > Why ? does checkpoint takes too long to complete ? or checkpoint duration > is affecting transaction response time ? …
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/…
Can't INSERT blob into specific blob space using JDBC
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
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: Extent allocation
"Why did it not allocate the 2nd next extent as 25000 and so on? " There was not enough contiguous free space in the dbspace when the new extent was allocated. I assume a large enough amount of contiguous free space was available when the last new extent was added.…
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!…
Extent allocation
Could someone please help to explain the pattern below from an oncheck -pt: Yes, old OS, old Informix..... Initial extent size is: 115000 Next extent size is: 25000 After the first next extent it allocates 3X8000 extents and 6X4000 extents and then the final added extent is 25…
Re: MAX EXTENTS
Size your extents properly.…
MAX EXTENTS
Hi... Is there any way to set maxextents for a table in informix to maximum? I know that theres a formula to calculate the maxextents but can't that be bypassed and the extents set to unlimited? Regards, Akshay…
Re: drop a chunk in v10
Yes. In fact I'd like a move extent feature. onspaces -me (move extent) -p <oldpath>... -o ...<old_offset> -ne (new extent) -p <newpath>... -o ...<new offset> [ -s <number_of_pages> ] Move extent at offset old_offset in chunk old_path to offset new_offset in chunk newpath. Wor…
AW: MAXEXTENTS on Informix 7.3
No - you can't change the max number of extents for a structure. It's a function of the partition page for that structure, and the room left on slot 5 for the extent list. Which version of 7.31 are you using? Thanks - Mark Scranton IBM…
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 …
MAXEXTENTS on Informix 7.3
It depends on how close you are to the maximum number of extents. If you are already out of extents it is too late, but if you still some extents available then you can increase ALTER TABLE ttttt MODIFY NEXT SIZE nnnnn…
Re: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
RE: number of extents
Bill asked: > If you drop a referential constraint and re-add it, will the new index be in > one extent, or will IDS just snag the first free blocks it comes to? My understanding is that the behaviour is different in 9.4 than previous versions. It seems to take a lot more space…
number of extents
This is on IDS 934 TC2. A partial output of this query follows ... database sysmaster; select count(*) as numext, sum(pe_size) as totsize, tabname[1,32] as tabnam from systabnames, sysptnext where partnum = pe_partnum and dbsname = 'team' group by 3 having count(*) > 1 order by …
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: ids10.force to drop a chunk
Hi, Here is a snippet of release note of 10.0.UC3. 1.4.2.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 a given dbspace. Use …
RE: ids10.force to drop a chunk
Hi, Here is a snippet of release note of 10.0.UC3. 1.4.2.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 a given dbspace. Use …
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.…
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 …
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
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: fragmentation factor
Is that because new extents were being created in the load?…
Re: fragmentation factor
just get the tablename and number of extents per table...sort by number of extents decending... a simple report like that allows you to see problems...…
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
Re: Config for OLTP system
Neil Truby wrote: > IDS 10.0 v3 on Solaris 9. > > I'd be grateful for any comments on this OLTP system onconfig about to go > live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 > extrenal disks fo the 60GByte database server. I've striped the database > …
RE: Config for OLTP system
Neil, You are using /usr/informix and /opt/informix PA_PAGES and RA_THRESHOLD are blank Is 1Mb logs big enough, I use 100Mb and we can fill a log in <15 mins when busy, you won't need 819 of them if you make them bigger LTAPEBLK = 32 are you sure? seems a tad small to me SHM…
RE: Config for OLTP system
> -----Original Message----- > From: Bill Dare > Sent: Thursday, August 11, 2005 8:44 AM > To: 'Neil Truby'; informix-list@iiug.org > Subject: RE: Config for OLTP system > > BUFFERPOOL > size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=1 > 0.000000 > Maybe spe…
RE: Config for OLTP system
BUFFERPOOL size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=10. 000000 Maybe spending too much time flushing 8% of the LRUs when LRU writes kick in? Might try lowering lru_max_dirty. Shorter checkpoints and your LRU writes should be spread more evenly over t…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
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…
IDS 10 systables missing
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: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
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: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > Hi: > Let me begin by saying thanks to all of the frequent posters to this group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiem…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para…
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…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG par…
figuring out extents
Hello, Does anyone have a script to be able to figure out the storage parameters ( first extent and next extent sizes ), based on a table schema, number of expected rows, and growth ? Thanks, floyd…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
RE: oncheck -cc errors
Update systables ? I wouldn't recommend that, unless you have Tech Support sitting on the other side of a telephone line, instructing you to do it .......... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of superbo…
RE: oncheck -cc errors
Superboer & JWC To my knowledge no one updated the systables directly. It is possible someone has in the past updated them directly to get larger next sizes trying to minimize the number of extents on these tables. We have had this database in IDS sine 1997 I believe maybe 1996…
Re: oncheck -cc errors
do you have a test system?? if so restore a backup of your system onto it and start hacking... > ERROR: informix.systabauth nextsize 664 != tblspace.nxtsize 64 > Next extent size 1328 it sounds like the info on the partition pages are not the same as what is …
oncheck -cc errors
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…
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…
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
Re: dropping chunk
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
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
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
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…
error message from check consistancy
When doing a consistancy check on our database we got the following error - WARNING:No sysdepend record for TBLspace informix.tablename What are some causes for this. We are running IDS v9.40.FC3 Tom Wallin…
Index extents
All, Is there a way to size the index extents if they are detached? I'm seeing alot of extents allocated to indexes (150+ extents). -Terrence…
"no more extents" error
Hello, Maximum extent size is 2 GB. Informix setting next extent as 2 GB. When informix adds 16 extents then at the 17th time it doubles the size of next extent. In your case system is trying to add 18th extent of size 4 GB. But it is not possible to create extent of 4 GB. Sout…
Re: tblspaces with bufreads but no isreads
Dave: In general you will find the this tblspaces contains a detached or semi-detached index. Since there is no data in this tblspaces there will be no isreads, isdeletes,... calls on this tblspace. John Madison Pruet wrote: > You got ER turned on? > > > "Dave Kosenko" <dko…
Re: tblspaces with bufreads but no isreads
Dave: In general you will find the this tblspaces contains a detached or semi-detached index. Since there is no data in this tblspaces there will be no isreads, isdeletes,... calls on this tblspace. John Madison Pruet wrote: > You got ER turned on? > > > "Dave Kosenko" <dko…
Re: tblspaces with bufreads but no isreads
Dave: In general you will find the this tblspaces contains a detached or semi-detached index. Since there is no data in this tblspaces there will be no isreads, isdeletes,... calls on this tblspace. John Madison Pruet wrote: > You got ER turned on? > > > "Dave Kosenko" <dko…
Re: tblspaces with bufreads but no isreads
Dave: In general you will find the this tblspaces contains a detached or semi-detached index. Since there is no data in this tblspaces there will be no isreads, isdeletes,... calls on this tblspace. John Madison Pruet wrote: > You got ER turned on? > > > "Dave Kosenko" <dko…
Re: tblspaces with bufreads but no isreads
Dave: In general you will find the this tblspaces contains a detached or semi-detached index. Since there is no data in this tblspaces there will be no isreads, isdeletes,... calls on this tblspace. John Madison Pruet wrote: > You got ER turned on? > > > "Dave Kosenko" <dko…
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 …
How to change next size on 24x7 table
I have a table which is over 200 extents - already had problems with it. It was orginally defined with first extent = next extent = 16. I want to do ALTER TABLE...MODIFY NEXT EXTENT (before I do the ALTER FRAGMENT...) and set it to about 100000, but I keep getting 242: Could n…
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'?…
tblspaces with bufreads but no isreads
Wonder if anyone has noticed this before and/or has any idea as to why this is the case. Monitoring my databases via sysmaster (sysptprof in particular), I see a fair amount of bufreads activity on tblspaces with no corresponding isread (or iswrite, etc.) activity. What sort of…
Re: Calculating BLOB space table size
Steve N. wrote: [snip] > Maximum row size 86 > Number of special columns 1 > Number of keys 0 > Number of extents 155 > Current serial value 1 > First extent size 8 > Next extent size 4096 You…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
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…
RE: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
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…
how to keep an eye on extents
Hey all. Anyone have a good query that will list by table the number of extents that table is using and the number of extents left to it before error?…
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?…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
Re: Are Deadlocks function of extents number ?
Five Cats wrote: >> of extents in the table. > > > Only that the tables with most extents are probably the most active ones > so the most likely to experience deadlock... > I don't think that follows. Extents are a function of what the DBA has set as first extent and next extent…
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
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…
Number of extents and remaining extents
I have a script in stored procedure which calculates, among other things, the number of extents allocated to a table and the remaining number of extents it can take before it errors out "no more extents". In version prior to 9.40, this is how I calculated:- for number of extent…
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…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? 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…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
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…
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…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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.…
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…
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…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
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…
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…
table extents
Alarmed by the extent discussion some days ago, I checked the number of extents of all "my" tables in all databases. The result was terrifying: there are a lot of tables with over 20 extents and even some tables with more than 100 extents. So, what can I do to get rid of fragmen…
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…
Re: What's in my buffers script
"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.08.22.14.29.29.722621.10594@bloomberg.net>... > On Fri, 22 Aug 2003 11:18:08 -0400, Kristofer Andersson wrote: > > Yup, my 9.4 wasn't up when I tested the script. New version with an > option to filter out the …
Index extents
Using IDS 9.30FC2 on an HP-UX 11.0 box. in creating detached indexes, I have noticed that sometimes the index has multiple extents in a particular dbspace. For example: prddwh:'dw_admin'.fl_keylinks 943776 40 prddwh:'dw_admin'.fl_keylinks_n1 139338 8 prddwh:'dw_admin'.fl_keylin…
Re: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
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?…
Extents and table
Many thanks to all that replied to me, oncheck -pe helped me identify the table in question. I should have known this myself. Thanks Steve…
Extents and tables
I know I have done this before but can't for the life of me remember how to now. I have recently added a 2G chunk and it has been used in full within a day, this is not expected. Onece before I had this and what had happened was a table was low on available extents so as soon as …
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…
Querying free extents through sysmaster
Is there anywhere in sysmaster that holds a list of free extents? Or do you have to look for the 'holes' in sysextents? Andy Kent Bristol UK…
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: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
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…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
Extents Sizes
This is a multi-part message in MIME format. ------_=_NextPart_001_01C329CF.49F1D842 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi =20 Is there a rule for creating extent size and next extent size. =20 Kind Regards Johnny ------_=…
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…
Extent number
Hi all, I have a couple of tables with 20 extents, does it hurt the performance of my database if i need to search those tables very often??? I read an article that extent number for a table should be kept 8 or below, is that ture??? What can i do?? drop the table with a bigger e…
Checking extents
Dear all, Ran oncheck -ce today against my rootdbs, and the word "ERROR" appeared. Output below. Should I be worried? The dB it mentions - efacdb - resides in a different dbspace. Validating extents for Space 'rootdbs' ... Chunk Pathname Size Used Free 1 /dev/infdisk1 125000…
RE: initial size of tblspace?
I concur. cheers j. > -----Original Message----- > From: Phillip [mailto:tienp@wholefoods.com] > Sent: Monday, February 05, 2001 11:35 AM > To: informix-list@iiug.org > Subject: Re: initial size of tblspace? > > > I believe tablespace tablespace is 50 pages. > > sudhakar wrote:…
initial size of tblspace?
hello, can any one answer this question When Informix configures a new DBSpace on disk, it initializes a section called the tblspace tblspace for keeping track of all tables within that DBSpace. What is the initial size of the tblspace tblspace in pages? bye sudhakar -- Posted …
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!…
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…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
RE: Dropping Temporary Dbspaces
Thanks, Mark! I went ahead and built the instance without the tempdbs. I'll migrate the tempdbs chunk later in the week when I have the planned downtime. Best regards, Edmund Nigel Gall <-- Making IT happen! --> Senior Information Systems Specialist Process Plant Services Limi…
Re: Dropping Temporary Dbspaces
Nigel Gall wrote: > > Hi! Can I drop a temporary dbspace without re-initializing the instance? > > In reviewing the manual for IDS 7.3, on page 14-19 it states that one should > run oncheck -pe to examine if any logs or tables reside in the dbspace > before removing. When I run…
Dropping Temporary Dbspaces
Hi! Can I drop a temporary dbspace without re-initializing the instance? In reviewing the manual for IDS 7.3, on page 14-19 it states that one should run oncheck -pe to examine if any logs or tables reside in the dbspace before removing. When I run it, I get the following for …
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…
Extent size when rebuilding a table
Hi! I'm trying out ways to reduce the number of extents for tables. The method I've used is the "ALTER INDEX my_index TO CLUSTER"-method. When allocating contiguos pages for the table, informix uses just the number of pages needed. Is it possible to set the size for the first ex…
sql:unused extent space
Hello everybody! Is there a SQL to find out the total unused space in all the extents? thanks regs savio…
Extents management
Hi, Does someboby knows if it is legitim to eliminate interleaved extents in the SMI tables as we do in the user tables? To eliminate these extents in a user table, we reorganize with UNLOAD table, DROP table, change PRIMARY EXTENT and NEXT SIZE, LOAD table. Can we do that on SMI…
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…
Date Stamp of Extent
As informix creates new extents for a table when needed, is there a diagnostic like oncheck or something to show the date it was created?…
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 …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
Deletes/extents
We have gone through an update of Informix from 7.24 to 7.31 UC6 over the past week. Since the upgrade, we have run into an issue with deletes. When deleting whole tables, the extent size does not clean up, therefore filling dbspaces. Only way around this is to drop table and …
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…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
Extent Allocation
Is there any way, either through SMI tables or otherwise, that I can find out the datetime when a table extent was allocated? Sent via Deja.com http://www.deja.com/ Before you buy.…
dropping a dbspace apparently empty (IOWS 7.20.UC2 )
Hello I am trying to drop a dbspace on my IOWS 7.20.UC2 on a SCO Openserver 5.0.2: >---< #onspaces -d pcl WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y Cannot drop the DBspace/BLOBspace. ISAM error: DBspace is not empty >---< the Admin guide sa…
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…
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
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…
RE: Dropping dbpace in ODS 7.2
You need to get Informix Support to drop it for you. (A bug fixed in later versions). MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Graeme Muirhead Sent: Tuesday, July 25, 2000 8:35 AM To: informix-…
Re: Dropping dbpace in ODS 7.2
Was this part of a TEMP dbspace? If so temp tables are not always dropped physically until the engine is shutdown and restarted. Also there are a few versions with bugs that will NEVER clean up SOME temp tables, but you did not post your exact version and platform. Art S. Kage…
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
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…
Re: Extents
"COOPER, Joseph" wrote: > > > I have one table that is 70,000,000 records & we feel will grow to > > 90,000,000 > > It is in it's own dbspace and has additional chunks allocated to it. > > > > I had a problem with it yesterday (Error 136) and had to unload, drop, > > rebuild, & r…
Extents
Hi it's me again.... with a different question.... I've read the posts on extents but I don't feel this question has been answered... I have one table that is 70,000,000 records & we feel will grow to 90,000,000 It is in it's own dbspace and has additional chunks allocated to …
Extents and Fragmentation
Hi guys, I'm a pretty new DBA, so if I sound ignorant, forgive me. In one of my busiest databases, we have a 40 million row table with 212 extents (about 3 MB)and several 4-10 million row tables with close to 200 extents. From what I read read in the past two weeks, this is a v…
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…
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…
extent allocation of alter fragment
Roger Xu wrote: > > Hi, > > Can someone tell me how does "alter fragment" allocate extents while doing > the following: > > alter fragment on table <tablename> init fragment by round robin in > dbspace1, dbspace2, dpspace3 The same as every other Informix command that alloc…
dbimport and extents
When running DBIMPORT to import a previously DBEXPORTed database, does Informix recalculate extent sizes?? The <database_name>.sql doesn't appear to refer to extent sizes but systables shows fextsize varying from table to table - ie not the default and nextsize is 10% of fextsi…
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.…
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…
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 ---------…
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…
Extents Sizing
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_01BF98D8.B0B1BF60 Content-Type: text/plain; charset="iso-8859-1" BRAIN FART! I know that I have seen a formula that c…
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: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
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…
Extents: Reality and Myth
"Victor Glass" <vglass@mailbox.bellatlantic.net> wrote in message news:38CF84F9.C095042E@mailbox.bellatlantic.net... > I am in the process of re-sizing a database, and revisited the topic of > extents. We are running IDS 7.30 UC7, RS/6000 w/8 cpus, AIX 4.3, and we > use a disk vo…
Re: extents
From: "OOO" <O.Kotov@vaz.ru> > >How to get number of table extents in database oncheck -pe | grep tablename? select * from sysextents in sysmaster? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
extents
How to get number of table extents in database…
Re: Index question
From: "Farmer, Byrd G - CFC" <Farmer.Byrd@cfwy.com> > >I have one table that has its indexes in a separate dbspace. I cannot find >anywhere in the documentation that says I can allocate extents to an index. >Does anyone know if there is a reason as to why I cannot? 7.24UC3. I …
Index question
Farmer, Byrd G - CFC wrote: > I have one table that has its indexes in a separate dbspace. I cannot find > anywhere in the documentation that says I can allocate extents to an index. > Does anyone know if there is a reason as to why I cannot? 7.24UC3. Please do not post MIME…
tblspace errors
Info: IDS7.31uc4 HP-UX 11 PeopleTools 7.56 I was experimenting with the utility onunload/onload. I copied a small peoplesoft database (aud752) with it. The utility worked fine, but I noticed that the database was stored in the rootdbs. I dropped it and went on with life. Ano…
tblspace problems
Info: IDS7.31uc4 HP-UX 11 PeopleTools 7.56 I was experimenting with the utility onunload/onload. I copied a small peoplesoft database (aud752) with it. The utility worked fine, but I noticed that the database was stored in the rootdbs. I dropped it and went on with life. Ano…
calculating extents
Hello. Does anyone know of a utility that will allow assist in recalucating extent sizes, so I can plug in my variables and the utility will do the calcuating? Thanks, Michele…
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…
extent problem
hey all: Trying to load a table, having the following problem: 271: Could not insert new row into the table. 136: ISAM error: no more extents 847: Error in load file line 59770. hmm, what does this mean? and how can I fix it? I don't even remeber setting up exten…
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…
Informix extents
Hello Gurus, I have a fragmented table with approx 10 million records ( 20 fragments) . Data portion of the table has only one extent per fragment after i did the reorg. But the indexes extents look so weird .. One of the unique index has got 17 extents in one of the fragments. …
Re: Dropping a chunk
June Tong wrote: > > Mark D. Stock wrote: > > > Darin Tracy wrote: > > > > > > You will not be able to drop this chunk. This chunk is obviously not the > > > first chunk of a dbspace. It is a secondary chunk within a dbspace. > > > The tblspace tblspace had to extend into this …
Re: Dropping a chunk
Mark D. Stock wrote: > Darin Tracy wrote: > > > > You will not be able to drop this chunk. This chunk is obviously not the > > first chunk of a dbspace. It is a secondary chunk within a dbspace. > > The tblspace tblspace had to extend into this chunk and because of this > > yo…
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…
Re: Dropping a chunk
You will not be able to drop this chunk. This chunk is obviously not the first chunk of a dbspace. It is a secondary chunk within a dbspace. The tblspace tblspace had to extend into this chunk and because of this you will now not be able to drop this chunk. Darin June Tong wr…
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 …
number of extents
I think I remember reading somewhere that with newere versions of IDS you did not need to worry about the number of extents. Is this correct? I have some tables with over 100 extents and I suspect that they are severely fragmented. I am formulating a plan for fixing this situat…
extent sizes
Does someone have a methodology for calculating extent sizes?…
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…
Extent in 8.3
I've just started and new to 8.3 datawarehousing. I started monitoring / maintaining Ifx 8.3 datawarehouse on Sun solaris 2.6. How can I find the extent interleaving, in which dbspace they are lying etc.? TIA Mukund…
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…
RE: Extents
Steve Yes, much better. ALTER TABLE tablename NEXT SIZE whatever; ALTER FRAGMENT ON TABLE tabname INIT IN your_dbspacename; This will rebuild the table. You cannot alter the primary EXTENT SIZE without dropping the table. This allows you to create a table with 2 extents -…
Extents
IDS7.3 I need to expand the extents for most or all of our tables in our db. What would be the best way to go about this? The only obvious idea I have for now is to do a dbexport, edit the output to reflect larger extents, drop all tables and then do a dbimport? We are talking…
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…
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
Tablespce Limits
Yes it does. You can also hold off the limit by detaching indexes so that they get their own tblspace as well. Art S. Kagel Thomas Mieslinger wrote: > > Hi *, > > I read in article by Art S. Kagel that a Tblspace contains > the data- and Indexpages of a Table. A Tblspace is li…
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…
Re: LONGTX in Non-logged DB
Yes, that is exactly what was happening. Since the engine was still able to compress the new extents into the original one extent - extent doubling did not kick in. Art S. Kagel David Grove wrote: > > A thought occurred to me... > > Could it be that a new extent is allocated, …
Detached index extentsize formula
Last year an Informix Corp. engineer posted this formula to calculate (detached) index extent size: (keysize + 9 / rowsize) * extent size which I take to mean: Add 9 bytes to the column size of the table in question's primary key; divide it by table rowsize; multiply this b…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
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…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
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…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
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?…
Inserting BLOBs (and rootdbs)
Hello All, We have come across a situation where the rootdbs is filling up with TBLSPACE TBLSPACE entries when inserting BLOBS into a table via a stored procedure on a remote system. Do Blobs flow through the rootdbs (on there way to the blobspace maybe)? Is there a way to have…
Inserting Blobs (and rootdbs)
Hello All, We have come across a situation where the rootdbs is filling up with TBLSPACE TBLSPACE entries when inserting BLOBS into a table via a stored procedure on a remote system. Do Blobs flow through the rootdbs (on there way to the blobspace maybe)? Is there a way to have …
Inserting BLOBS (and rootdbs)
Hello All, We have come across a situation where the rootdbs is filling up with TBLSPACE TBLSPACE entries when inserting BLOBS into a table via a stored procedure on a remote system. Do Blobs flow through the rootdbs (on there way to the blobspace maybe)? Is there a way to have …
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…
Large extents
I have reorganized some of the tables to reduce no of extents. Following is an excerpt of oncheck -pT on one of the table. See the free space summary and please advise if I should change it. If yes what are the commands I can use for the same. TBLspace Report for ola:db.lppas_tra…
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…
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…
More questions about extents
Having established the next extent size for a table (thanks group) I tried to reduce this by alter table modify next extent. I then updated stats on that table, but still the next extent size is showing as large as ever (oncheck -pT shows 360000) Looking at systables the next ext…
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.…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
RE: lost tblspace help
Restore from archive after correcting the problem that caused the chunk to go down. OR initialise the instance and start again. Murray Wood -----Original Message----- From: jandspaul@my-deja.com [SMTP:jandspaul@my-deja.com] Sent: Thursday, June 03, 1999 9:07 AM To: informi…
Re: lost tblspace help
jandspaul@my-deja.com wrote: > > our 5.x informix systables got hosed somehow. using > dbaccess, informix sees the database, but we can't connect > to or drop the database because of a tblspace does > not exist error. the primary chunk is also down (not mirrored). > tbcheck won…
lost tblspace help
our 5.x informix systables got hosed somehow. using dbaccess, informix sees the database, but we can't connect to or drop the database because of a tblspace does not exist error. the primary chunk is also down (not mirrored). tbcheck won't work because the tblspace doesn't exis…
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…
oncheck -cc problems
Whenever I run oncheck -cc i get following error message for most of the tables. Validating database ola Validating systables for database ola ERROR: db.statapps nindexes 12 != tblspace.nkeys 11 + detached keys 0 ERROR: di_nkeys 11 != systables nindexes 12 - detached keys…
Number of extents for table SYSPROCBODY
Hi, I have 272 extents for table "SYSPROCBODY". How can I reduce number of extents for system tables? Andrzej Kurowski…
oncheck -cc error message
Whenever I run oncheck -cc i get following error message for most of the tables. Validating database ola Validating systables for database ola ERROR: db.statapps nindexes 12 != tblspace.nkeys 11 + detached keys 0 ERROR: di_nkeys 11 != systables nindexes 12 - detached keys…
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…
Re: extent size questions again ...
From: Wu <wuyf@tm.net.my> > >Is there any restriction on the extent size, and will there be any >performance impact, if :- > >1. First extent size is greater than the next extent size. > >2. Next extent size is greater than the first extent size. > >3. Both first and nex…
extent size questions again ...
Is there any restriction on the extent size, and will there be any performance impact, if :- 1. First extent size is greater than the next extent size. 2. Next extent size is greater than the first extent size. 3. Both first and next is same size. thanx for your inpu…
Questions on extent ...
1. How to retrieve the number of extents used by a table from any of the sysmaster tables or sysXXXX table ? 2. Is there a maximum number of extents for a table ? 3. Is it TRUE that whenever a table has more than 8 extents (regardless of the size of the extent), the ac…
Re: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
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 ?…
Re: TABLE UNWANTED FRAGMENTATION
I'm afraid there isn't much you can do about the extents on the system catalogs. I wish there were. It shouldn't affect performance TOO much, because the catalogs are typically being cached anyway. As for the temporary dbspace, you may consider dropping and readding it. There …
TABLE UNWANTED FRAGMENTATION
I did an oncheck -pe and I get the following on the temporary db space. Is this normal. Why is the temporary db space fragmented if there are no tables in it? Is this affecting performance? Chunk: 12 /informix/symlinks/tempdbs1 Size Used Free …
How to drop a bad dbspace?
I've got a dbspace (actually a blobspace) that was corrupted and I need to drop it. I've created a new blobspace and transferred all of the data into the new one. The primary chunk in the old corrupt blobspace still contains references to an invalid tblspace. therefore, onspaces …
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 …
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…
Extents
Hi folks. For as long as I can remember I've looked at the nextns column in sysptnhdr to get the number of extents in a table. But sysextents shows many more extents than this for the same table. Can anyone settle the argument I'm now having please?! Which is right? My assumpt…
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
Extents.
Teneis algun programa que calcule el tama=F1o de los extents inicial y = siguientes que necesita un tabla (diciendole el numero de filas iniciales = y el numero estimado de las proximas filas). O informaci=F3n relacionada con esto... Muchas gracias. jhernandez@geuropa.com =20…
Extents.
Teneis algun programa que calcule el tama=F1o de los extents inicial y = siguientes que necesita un tabla (diciendole el numero de filas iniciales = y el numero estimado de las proximas filas). O informaci=F3n relacionada con esto... Muchas gracias. jhernandez@geuropa.com =20…
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…
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…
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
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.…
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…
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…
Re: Question on tblspace tblspace
Pingu !!! Guess Who !! I have done a little research into this little baby and found the following:- tblspace tblspace is assigned by the server as and when required and adds 50 pages at a time ( default ) whenever a tblspace tblspace needs to be increased. As you have found ou…
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: Question on tblspace tblspace
ethump5724@my-dejanews.com wrote: > I'm currently installing a Online 7.30 system for a client and loading around > 10Gig of data into two databases. At the moment I'm not specifying extent > sizes on the tables because I'm letting Informix handle it with it's "extent > doublin…
Question on tblspace tblspace
Hello Informix World I'm currently installing a Online 7.30 system for a client and loading around 10Gig of data into two databases. At the moment I'm not specifying extent sizes on the tables because I'm letting Informix handle it with it's "extent doubling" capabilities What…
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 …
Alter Fragment ... init ...
Hi all: After I realized there is a table with too many extents (32), I did the followings: 1) increase the next extent size 2)use 'alter fragment ... init ...' command to reorg this table Everything looks fine except the output from 'oncheck -pT' command: number of extents: …
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…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
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.…
Re: Detached Indexes...Multiple Extents
"MS CARLEEN C AVANT" <cavant@safecen.navy.mil> offerred: +Can anyone explain the significance of a detached index requiring a high +number of extents? Even when the associated table is fully resident within +one extent, I find it's detached indexes each spanning multiple extents…
extents of tables
From an Informix newbie: Can someone tell me how to get a report of the number of extents per table (not just system tables but data as well)? I know about onstat -t but this output seems kinda cryptic... I am running 7.24.UC5-1 TIA -----------== Posted via Deja News, The Dis…
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…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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…
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:…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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 "…
Re: dropping temp TBLspace
WF Software wrote: > > I wonder if this explains why onmode -ky can leave network connections in > a FINWAIT and an onmonitor shutdown doesn't. Could be. > When did this functionality appear? See below. David Williams wrote: > > Huh? What!! When did this change? YOu mean I …
dropping temp TBLspace
In article <6tlcvh$ju6$1@news.xmission.com>, Mark D. Stock <mdstock@informix.com> writes > >Allen Jantzen wrote: >> >> Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following >> appears in $INFORMIXDIR/online.log on the way back up > >What commands do you use to 'bo…
Re: dropping temp TBLspace
In article <6tlcvh$ju6$1@news.xmission.com>, mdstock@informix.com (Mark D. Stock) wrote: [cutting] > This is probably due to a little known change in the functionality of > some onmode options. Specifically the k option, which used to rollback > transactions for you, as in the …
Re: dropping temp TBLspace
Allen Jantzen wrote: > > Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following > appears in $INFORMIXDIR/online.log on the way back up What commands do you use to 'bounce' the engine? > 13:45:23 Dropping temporary TBLspace 300061, recovering 96 pages. > 13:45:2…
Re: dropping temp TBLspace
In article <35fd15f0.70581570@kiosk>, allenj@ndr.com (Allen Jantzen) wrote: > Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following > appears in $INFORMIXDIR/online.log on the way back up > > 13:45:23 Dropping temporary TBLspace 300061, recovering 96 pages. > 13…
Re: dropping temp TBLspace
Allen Jantzen wrote: > > Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following > appears in $INFORMIXDIR/online.log on the way back up [SNIP] > 13:45:23 Dropping temporary TBLspace 300127, recovering 8 pages. > ..................and so on > > Can anyone tell me w…
Re: dropping temp TBLspace
On Mon, 14 Sep 1998 15:16:35 +0100, "Neil Truby" <ntruby@netcomuk.co.uk> wrote: > >Allen Jantzen wrote in message <35fd15f0.70581570@kiosk>... >>Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following >>appears in $INFORMIXDIR/online.log on the way back up >> >>13:…
Re: dropping temp TBLspace
Allen Jantzen wrote in message <35fd15f0.70581570@kiosk>... >Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following >appears in $INFORMIXDIR/online.log on the way back up > >13:45:23 Dropping temporary TBLspace 300061, recovering 96 pages. ... >13:45:23 Dropping …
dropping temp TBLspace
Everytime I bounce my 7.22 ODS HP-UX server, a *LOT* of the following appears in $INFORMIXDIR/online.log on the way back up 13:45:23 Dropping temporary TBLspace 300061, recovering 96 pages. 13:45:23 Dropping temporary TBLspace 3000c0, recovering 176 pages. 13:45:23 Dropping t…
Re: altering extent sizes
Kate_Tomchik@homedepot.com wrote: > > What does it mean to alter fragment init? The command: ALTER FRAGMENT ON <tablename> INIT IN <dbspace>; will move an existing tables extents to another (hopefully smaller) set of extents on the same or a different dbspace. It is the faste…
onstat -ce reports error. What to do?
What to do if my Online 7.2 repors errors. oncheck -ce results: Validating extents... ERROR: Extents overlap oncheck -pe results : DBspace Usage Report: rootdbs Owner: informix Created: 01/20/98 Chunk: 1 /opt/informix/DB/IFMXDATA/ol_hera/ROOTDBS.000 S…
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
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 …
monitor tables - how to ?
Hi, How to find out how a table is spread out across a chunk in a dbspace ? 1) If the dbspace has one chunk in it but many tables ? 2) If there are more than one chunks in the dbspace ? The onstat -t output shows only one entry for a tablespace and the address it shows is the s…
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…
Re: Tblspace Tblspace/Dbspace bit map page
"Sadagopan, Sathish" <sadagop0458@att.com> offerred: +What is the difference between the Tablespace Tablespace bit-map page and +the Dbspace bit map page ? There is no such thing as a dbspace bit map page. You may be thinking of the chunk free list page, which contains info on …
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: Tblspace Tblspace/Dbspace bit map page
Sadagopan, Sathish wrote: > > Hi, > > What is the difference between the Tablespace Tablespace bit-map page and > the Dbspace bit map page ? Why the hell are you interested in such a tender subject ? Don't you agree that this stuff is only necessary for incurable nerds ? > Is …
Tblspace Tblspace/Dbspace bit map page
Hi, What is the difference between the Tablespace Tablespace bit-map page and the Dbspace bit map page ? Is it that the Tblspc.Tblspc. bit map page is only for the pages containing the Tblspc.Tblspc and the DBspc. bit map page for the free pages containing data ? When i look …
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…
Re: No. of Extents
In article <m8o8jDAfYWo1EwKE@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes >In article <35A0D7E3.4263@bloomberg.net>, Art S. Kagel ><kagel@bloomberg.net> writes >>colin quadros wrote: >>> >>> Can anyone tell how to cslculate the number of extents in a tabl…
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…
Re: extent size ?
ccremid wrote: > > Clem Akins wrote: > > > > At 11:30 PM 02-07-98 +0800, Yew Fei wrote: > > <snip> > > > > > > >what is the optimum extent size (first extent size) and next extent size > > >shall I used to create this table ? > > <snip> > > > > > > I like to set the first extent …
Re: No. of Extents
colin quadros wrote: > > Can anyone tell how to cslculate the number of extents in a table in a > 5.X environment..?? Also, if we know the number of rows,columns and tbcheck -pe -OR- tbcheck -pt database:table > indexes in a table , how do you find the "right" first extent size …
Re: Couldn't drop dbspace
Hi Uwe! I've made 'oncheck -pe' and these are results. Looks very strange, isn't it? Any thoughts? ---------------------------------------------------------------------------- ---------------------- DBspace Usage Report: testdbs Owner: informix Created: 06/19/9…
Re: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
extent size ?
I have a table with the following structure : create table bill_trans ( bill_no integer, bill_date date, bill_time time, bill_item char(40), bill_amt dec(16,2), primary key(bill_no) ) lock mode row ; Estimation of records per day : 20…
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…
No. of Extents
Can anyone tell how to cslculate the number of extents in a table in a 5.X environment..?? Also, if we know the number of rows,columns and indexes in a table , how do you find the "right" first extent size and next extent size..?? Regards, Colin…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Re: oncheck -pe output
Tino, I had a similar problem last month. only it was on a temp dbspace I was down to 50 meg of contiguous space when the dbspace was defined as 1 gig. This problem arises when there is lots of new tables being inserted and deleted into the chunk, also t…
Re: oncheck -pe output
ccremid wrote: > > Informix gurus: > > After running oncheck -pe on Online 7.23/AIX 4.2 I got the > following output for my Temp dbspace. [oncheck -pe output SNIPPED] > Can someone explain the use of this TBLSPACE TBLSPACE allocations?. > Is there any way to delete them? > > As …
oncheck -pe output
Informix gurus: After running oncheck -pe on Online 7.23/AIX 4.2 I got the following output for my Temp dbspace. DBspace Usage Report: dbtemp Owner: informix Created: 02/25/98 Chunk: 3 /dev/RDBTEMP Size Used Free …
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…
Extent size
-- Hello, I have a database with many tables, a few thousand tables and due the behavior of the product I can`t set the initial extent size so that the amount of extents is minimal. Why can't I do the following; "with alter index ?? to cluster" I recreate the table in the order…
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: +…
sysmaster extents
I am running Online 7.23.UC4 on HPUX 10.20. Is it important for the DBA to be concerned about the number of extents in the system catalog? I have plenty of room in root to accomodate the growth. Thanks, Paul Brais braispa@mail.northgrum.com…
Re: Initial extent size < first extent
Thanks to all who answered my question on the initial extent size being < the first extent size specified. Sujata ***************************************** Sujata Soman E-Mail: ssoman@omm.com O'Melveny & Myers, Los Angeles ******************************************…
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…
Extent Sizing
Does anyone know of any good ksh scripts that would figure out extent sizing for a database. I want to run something that would show me the present 1st and next and maybe calculate out 6month or a year growth. What is a good script out there these days for doing this or does an…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
syscolumns extents
Informix OnLine 5.0 HPUX 10.20 HP-755 Server Database w/135 tables I started getting a warning that syscolumns has more than 8 extents. I don't remember having an opportunity to set extents or sizes on system tables. The table has 2352 rows. …
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…
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
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.…
How is disk space allocated to Indexes?
My questions are as follows: Assume that you create a table and allocate it an initial extent of some size.Then you create an index on that table in the same dbspace. Then you add rowsto the table, so that nodes get created in the index. Is the space allocated to the index part o…
Re: How is disk space allocated to Indexes?
apatankar@s1.com wrote: >My questions are as follows: >Assume that you create a table and allocate it an initial extent of some size. >Then you create an index on that table in the same dbspace. Then you add rows >to the table, so that nodes get created in the index. Is the spac…
How is disk space allocated to Indexes?
My questions are as follows: Assume that you create a table and allocate it an initial extent of some size. Then you create an index on that table in the same dbspace. Then you add rows to the table, so that nodes get created in the index. Is the space allocated to the index part…
Re: INTIAL SIZE of the sys tables
Hi, You can not at all set the systables first or next extent size. Systables are created by Informix server with first and next extent 8 pages when a new database creates. Regards…
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.…
Re: My Whole World Fell Apart!!
>have a table called scpard it was created with an initial extent of >620 Kb and a next extent size of 124 Kb. > >My problem is with rate at which extents are being added. Currently the >table is adding extents at a rate of 5 per week. There are 38 extents >and the calculated m…
Initial Extents
Is there an upper limit to initial extents? I'm running ODS 5.02 and I've got one table at 846,000 pages, and several at 300,000-400,000 pages, including indexes. Calculating the extent size at 4KB per page, my largest initial extent size is around 3,385,000 KB. Is this reasonabl…
Re: Extents
I have seen obsene amounts of extents for the systables. Is there a substantail penalty for this. I contacted tech support and was told not to worry about it. Any comments otherwise? -Bill > > > Thuc Nguyen wrote in message <6csn4o$dbl$1@news.xmission.com>... > > > >Hi > ><chomp…
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…
Re: Extents
Thuc, Do an alter table of the next size on sysprocbody and probably sysprocedures. This will keep the extents to 2. I do not know if there is a way to change the initial allocation for system tables. Regards David _____________________________…
Re: Extents
Thuc Nguyen wrote in message <6csn4o$dbl$1@news.xmission.com>... > >Hi ><chomp>. > >Since I have recently installed new Informix 7.23 on another HP 10.20, how can I increase extent size in sysprobody before we create new empty database? > You have to adjust the next extent size.…
Extents
Hi I have installed ODS 7.23 on HP 10.20 I have an ODS 7.23 on other HP10.20 with a database. I have noticed that a few sys tables have more than 80 extents like sysprobody has 87 extents. Since I have recently installed new Informix 7.23 on another HP 10.20, how can I increase…
extents
Hi I installed ODS 7.23 on HP 10.20 today. The information engineer once told me before I create the empty database, I need to fix the extent sizes in sysmasters in order to keep all system files under 8 extents. Can anyone give me instruction on how to fix it? I have ODS 7.2…
Understanding tbcheck -pe
*Sample Data* Disk Usage for Chunk 1 Start Length ---------------------------- ----- ------ stores.informix.customer 8066 8 stores.informix.orders 8074 16 stores.informix.customer 8090 8 - is the 'Length' m…
Re: How to reuse pages in other tables?
Leonids.Voroncovs@dati.lv wrote: > Created a table: CREATE TABLE ... > Checked: oncheck -pT database:table > Number of extents 1 > First extent size 4 > Next extent size 4 > Number of pages allocated 8 > Number of…
Re: first extent and next extent
>Hi, >I want to know that is there a system table include >first and next extent size information ? >and how can i keep the origin extent size during >dbexport and dbimport easily ? >and how can i change the first extent size after >dbimport (for i kno…
Re: first extent and next extent
jjdai@pek-co.cn.dhl.com wrote: > Hi, > I want to know that is there a system table include > first and next extent size information ? > and how can i keep the origin extent size during > dbexport and dbimport easily ? > and how can i change the first extent size after…
first extent and next extent
Hi, I want to know that is there a system table include first and next extent size information ? and how can i keep the origin extent size during dbexport and dbimport easily ? and how can i change the first extent size after dbimport (for i know change next extent siz…
Re: Ex Size
On Thu, 29 Jan 1998, Fergal Flanagan wrote: > Hi Art, > Just a quick query! > Ive just dome some extent sizing on tables of around 1.5 million > records. Obviously my computations are based upon the uniqueness of index > entries, so they come in at around 399072 - 450000Kb. …
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…
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…
Re: Extent/Next Extent
david.ashby@workcover.nsw.gov.au wrote: : Greg, : : More info next time please. : : If the table is already allocated and you want to know the current : allocations just do a "dbschema -d dbname -t tabname -ss" this will : give you the current sizes. War…
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: Extent/Next Extent
Greg, More info next time please. If the table is already allocated and you want to know the current allocations just do a "dbschema -d dbname -t tabname -ss" this will give you the current sizes. Warning the extents are in kbytes not pages. …
Re: Extent/Next Extent
To check for existing sizes look in systables: select fextsize, nextsize from systables where tabname = <tabname> -Bill > > What's the best way to determine the Extent size and Next Extent size in > Informix ? > > Greg Kuntz > -- Bill Ennis Voice: 312-…
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…
Re: Extent/Next Extent
Buy Carleton Doe's 'Informix Online Dynamic Server Handbook'... lots of great tips, and a worksheet on the CD-ROM to calculate extent sizes (along with a bunch of tools). All in all, a must-have for any DBA. *Highly* recommended. -------------------------------------------------…
Re: Extent/Next Extent
Hello, Theres a script/program in http://www.iiug.org that can help you do that or you can use this script: $1 == ");" { print ")" if ( nuro != 0 ) { exsi = insi * 1.25 * nuro exsi = exsi + nuro / 2016 * rosi * 2048 …
Re: Extent/Next Extent
This is a multi-part message in MIME format. --------------F20DBE5E7F6F02C4FBB978DA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Informix has excellent documentation on calculating extent sizes in their Performance Guide (available in PDF at Answers…
Extent/Next Extent
What's the best way to determine the Extent size and Next Extent size in Informix ? Greg Kuntz…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
Question on the contents of tempdbs
Hi everybody, I have a very funny situation here. I am unable to drop my temporary dbspace because accoding to ODS "7.22", " the dbspace is not empty ". Now, what on earth could exist in the tempdbs in Quiescent mode, or when nothing is going on ??!! I…
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…
indexes and extents
hi, I am using informix 7.13.UC2 on an hpux 10.01. I have created 4 indexes in a separate dbspace for this huge table that I have. What I have found is that when I used the 'create index idxname on tblname(col1) in dbspace', i found that the index has an entry in the smi tables.…
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…
Re: question on moving data out of chunk
Mike Orszag <jmo@ricardo.econ.bbk.ac.uk> wrote: > Can I move the TBLSPACE TBLSPACE data out of this chunk (in a cooked > file)? The TBLSPACE TBLSPACE entry contains the TOC entries of this Chunk but no table data. Normally you can delete such an additional chunk. Try it with on…
question on moving data out of chunk
I am using the Netscape product LiveWire Pro with Informix. I have an extra chunk of the rootdbs I want to drop but it has: Disk usage for Chunk 3 Start Length ------------------------------------------- --------- --------- O…
About Chunks Information.
Hi, Friends. Have anybody Any Idea about how to interpret the information of each page of tablespace tablespace, wich give this information to tbcheck -pt command. I'm trying to track the data pages of a Database that I have Broken. I can get the tblspace tblspace page from the…
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…
Extents overlap
Hi, I have a problem that I don't know if is really dangerous or not. When I execute the oncheck -ce on an on-line instance I get this output : ERROR EXTENTS OVERLAP ERROR EXTENTS OVERLAP Is this a problem with the sysmaster database that doesn't have correct data, or …
Re: Extents
Tony_Reynolds(Accounting & Purchasing) wrote: } } Hi, } Im doing my first extent sizing exercise in an attempt to improve } performance. } in the sysmaster database I am using the following sql: } select dbsname,tabname,count(*) number, sum(size) } from sysextents } group by dbsn…
Extents
Hi, Im doing my first extent sizing exercise in an attempt to improve performance. in the sysmaster database I am using the following sql: select dbsname,tabname,count(*) number, sum(size) from sysextents group by dbsname,tabname order by number desc Is the size the size of the …
7.22 temporary TBLspace problem
I'm receving the following error recently, when performing the engine shutdown and restart. 19:14:41 Dropping temporary TBLspace 30015b, recovering 8 pages. 19:14:41 Dropping temporary TBLspace 30015c, recovering 8 pages. 19:14:41 Dropping temporary TBLspace 30015d, recoverin…
Re: Extend overflow(in systables?)
On 12 May 97 at 9:24, Julio Cesar de Figueiredo wrote: > WHAT IS IT??? > WARNING:TBLSpace dbxxx:informix.sysprocbody has more than 8 extents. > WARNING:TBLSpace dbxxx:informix.sysprocplan has more than 8 extents. It means that you have two tblspaces which have more than 8 exten…
Extend overflow(in systables?)
WHAT IS IT??? WARNING:TBLSpace dbxxx:informix.sysprocbody has more than 8 extents. WARNING:TBLSpace dbxxx:informix.sysprocplan has more than 8 extents.…
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…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
Re: Are BLOBs logged?
"Paul Watson" <wfsoftware@cix.compulink.co.uk> wrote in article <E8Gswx.3DE@cix.compulink.co.uk>... > >I have a naive and simple question: are the full contents of BLOBs > >logged? I've heard contradictory assertions on this, and I want to find > >out why our transaction logs ar…
Re: tblspace number and rowid
In article <E64B4x.MFp@nonexistent.com>, Jacob Salomon <jake@apparel.net> writes >My previous post got no responses at all and vanished suspiciously >quickly, so I am reposting. > >Hi Y'all, > >Tim Jones's posted question on "Selecting Locked rows" got me thinking, >a grave offen…
Minimizing Extent?
Is there a better way to reduce table extent than onunload and onload? Is there a way to do this on the fly.…
tblspace number and rowid
My previous post got no responses at all and vanished suspiciously quickly, so I am reposting. Hi Y'all, Tim Jones's posted question on "Selecting Locked rows" got me thinking, a grave offense! The hamsters are threatening job actions! ;) The setup: Pre-Fragmentation, we wer…
tblspace number and rowid
Hi Y'all, Tim Jones's posted question on "Selecting Locked rows" got me thinking, a grave offense! The hamsters are threatening job actions! ;) The setup: Pre-Fragmentation, we were always able to select the rowid of a row in any table and locate where on disk that is. eg: s…
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…
Re: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
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: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
Maximum extents
Hi all, Does anybody know the maximum number of extents for one tablespace ? Thanks in advance. Stephane (stephane.magnan@eur.autodesk.com) Autodesk Development B.V. Switzerland…
How to find ....
How to find the number of extents for an Index on an Informix DSA 7.1x/7.2x ?…
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: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
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…
Re: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
Extents overlap
Hello, Just after database initialization of I-OnLine v7.0 on RS6000 'oncheck -ce' reports: Extents overlap There are no more databases, only 'Sysmaster'. Please comment. Sigitas Tumas S.TUMAS@kaunas.omnitel.net Sekasoft, Kaunas, Lithuania…
Re: Negative npused bug: When will it be fixed?
In article <4vt6o4$3h8@news.informix.com>, junet@informix.com (June Tong) says: > >Well, there are two bugs which apparently can lead to npused being negative, >one fixed in 5.02, and one fixed in 5.06. However, you must rebuild your >table in order to repair any npused which is…
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…
Extents Overlap
We ran the TBCheck -ce and got the error message: ERROR extents overlap. TBCheck -pe helped us identify the Chunk and therefore the DBSpace (thanks to Joe Lumbley and his fine survival guide. Perhaps in panic mode we overlooked it in our administrators guide, but we could not …
Re: TBLSPACE table extents. (fwd)
June Tong wrote: > > : From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov> > : To: Jacques Renaut <jrenaut@informix.com> > : Subject: Re: TBLSPACE table extents. > > : May work on a 7, yet to see it happen on 5. ALL DOC I'v read (will be more > : specific if need) SAY DELETE S…
Re: TBLSPACE table extents. -Reply
In article <4qbopp$nqe@news.informix.com>, June Tong <junet@informix.com> writes >Paul Daniels (paul.daniells@lovellwhitedurrant.com) wrote: >: Jack's suggestion works fine on database tables, unfortunately I did not >: make myself clear, the TBLSPACE TBLSPACE I was referring to …
Re: TBLSPACE table extents. (fwd)
: From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov> : To: Jacques Renaut <jrenaut@informix.com> : Subject: Re: TBLSPACE table extents. : May work on a 7, yet to see it happen on 5. ALL DOC I'v read (will be more : specific if need) SAY DELETE SPACE IS NOT REUSED. Please be…
Re: TBLSPACE table extents. (fwd)
For those who want to try it! ---------- Forwarded message ---------- Date: Thu, 20 Jun 1996 17:21:54 -0500 (CDT) From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov> To: Jacques Renaut <jrenaut@informix.com> Subject: Re: TBLSPACE table extents. May work on a 7, yet to see it …
Re: TBLSPACE table extents. -Reply
Paul Daniels (paul.daniells@lovellwhitedurrant.com) wrote: : Jack's suggestion works fine on database tables, unfortunately I did not : make myself clear, the TBLSPACE TBLSPACE I was referring to is the : internal one which holds information on table location within a dbspace, : …
Re: TBLSPACE table extents.
Cheryl Kendricks wrote: > > Delete row are not REUSED!!! You have to ALTER table: Best ALTER index to > CLUSTER or UNLOAD(TBUNLOAD)/LOAD(TBLOAD). I'v find if you have an existing > DB and have been keep stats on growth estimates work out GOOD!!! But > that's an IF!!! > > I would…
Re: TBLSPACE table extents.
Delete row are not REUSED!!! You have to ALTER table: Best ALTER index to CLUSTER or UNLOAD(TBUNLOAD)/LOAD(TBLOAD). I'v find if you have an existing DB and have been keep stats on growth estimates work out GOOD!!! But that's an IF!!! --------------------------------------------…
Re: TBLSPACE table extents. -Reply
In article <4q5vg1$6om@cssun.mathcs.emory.edu>, Paul Daniels <paul.daniells@lovellwhitedurrant.com> wrote: >[Snip] >> the TBLSPACE tables have developed many extents >> and been fragmented throughout the dbspace(s) >....... >> Does anybody have suggestion or ideas on how to preve…
Re: TBLSPACE table extents. -Reply
In article <4q5vg1$6om@cssun.mathcs.emory.edu>, Paul Daniels <paul.danie lls@lovellwhitedurrant.com> writes >[Snip] >> the TBLSPACE tables have developed many extents >> and been fragmented throughout the dbspace(s) >....... >> Does anybody have suggestion or ideas on how to prev…
Re: TBLSPACE table extents.
>I try to estimate the growth of the table over some period of time, >say, 3 months, and create the table with the appropriate size >first extent. Then, I calculate what the growth will be in each month, >and define that as the next extent size. >The only way to truly avoid thi…
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…
Re: TBLSPACE table extents. -Reply
[Snip] > the TBLSPACE tables have developed many extents > and been fragmented throughout the dbspace(s) ....... > Does anybody have suggestion or ideas on how to prevent it happening ? [Snip] >>Jack Parker Wrote: >>[Snip] >>ALTER INDEX foo TO CLUSTER; >>Where foo is some index …
Re: TBLSPACE table extents. -Reply
You don't have to export. You can cluster the index to consolidate the file or you can use the alter fragment syntax to fool the rdbms into re-writing the file. This happens because the sizing for the table was not correct. You don't have to make extent sizes huge; you just nee…
Re: TBLSPACE table extents.
> paul.daniells@lovellwhitedurrant.com (Paul Daniels) writes: > We are using OnLine 7.12 on HP900's running HP-UX 10.01 > > On each system the TBLSPACE tables have developed many extents > and been fragmented throughout the dbspace(s). I don't remember this > happening the …
Re: TBLSPACE table extents.
Hi, Once you have extents allocated you have few options available. dbexport/dbimport (if no options are specified) will put all tables into one extent. By the way there is no need for the re-initialize step. Also, note the -ss option of dbexport to retain extent sizes; this do…
TBLSPACE table extents.
We are using OnLine 7.12 on HP900's running HP-UX 10.01 On each system the TBLSPACE tables have developed many extents and been fragmented throughout the dbspace(s). I don't remember this happening the same on version 5 that we ran previously. The only method for recovery has b…
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: extents
Thuc Nguyen wrote: > > I am newly hired DBA. > > I ran tbcheck -ce on Online 5.03 on HP Box. > > Here is the info.. > > WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents > WARNING:TBLSpace coris:informix.sysprocbody has more than 8 extents > WARNING:TBLSpace cori…
Re: extents
ken, > While we are on the subject of extents ... > > I have seen a lot of talk about setting up extents correctly and > maintaining them, but no one ever really gives specifics. > > So, does anyone have a good method (magic formula) for determining how > big to set the initial…
Re: extents
Thun, First, the Informix consultant is always right. Informix only employs totally infallable professionals ;-) Get your hands on the C.D.I. FAQ and go out and buy Elizabeth Suto's book. Take the time to read thru these references well. The more you read, the easier the whole …
Re: extents
thuc, > WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents this is, as it says, only a warning. if a table has more than 8 extents, it can hurt the performance of the system, but it isn't an error and many tables can exist with much more than 8 extents. if yo…
Re: extents
Yes but BESURE to dbschema the tables first with all dbschema information. do a dbschema -- to get all of the fields. You want to include constraints and permissions. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@p…
Re: extents
At 01:13 AM 5/6/96 -0500, Thuc Nguyen wrote: >I am newly hired DBA. > >WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents >I was told by an Informix Consultant to do the followings: >1. unload the table to a flat file >2. drop the table >3. create the table, get t…
Re: extents
Thuc Nguyen wrote: > > I am newly hired DBA. > > I ran tbcheck -ce on Online 5.03 on HP Box. > > Here is the info.. > > WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents >[Stuff Deleted] > I cant find enough information about that script in any informix manual. …
extents
I am newly hired DBA. I ran tbcheck -ce on Online 5.03 on HP Box. Here is the info.. WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents WARNING:TBLSpace coris:informix.sysprocbody has more than 8 extents WARNING:TBLSpace coris:informix.sysprocplan has more than…
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)…
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…
Tbcheck and .EXTENTS files
Does anyone know how to redirect the .EXTENTS and .extents files produced by tbcheck to another directory ? Thanks Daniel Informix DBA CSFB UK…
Re: Fragmentation and Extent Size
Greg, Could it be that you are using the same first and next extent sizes from 5.05? For fragmented tables the first and next extent size refers to the fragment allocation not the whole table…
Re: Upgrade to 7.1
Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi Informix folks: : Validating systables for database sysmaster : ISAM error: no record found. : WARNING:No systabauth record for TBLspace informix.sysrawdsk. : TBLspace name sysrawdsk : Owner …
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: TBLSPACE DROPED
Paulvn@msn.com (Paul Van Niekerk) wrote: >Why does informix drop a tblspace. >I'm running online 5 on a hp-unix 9.04. >This is killing me for i have to restore all the tables. >Is Informix not talking to hp-unix or is it just a bug?? Yes it's a Bug !!! I came across this bug o…
TBLSPACE DROPED
Why does informix drop a tblspace. I'm running online 5 on a hp-unix 9.04. This is killing me for i have to restore all the tables. Is Informix not talking to hp-unix or is it just a bug??…
Re: Help calculating extents from esql-c
As to your initial question, I do not think that you will be able to calculate the number of extents. As far as I am aware tbcheck is the only way that you can calculate the number of extents on a table. If you look at the extent sizes for a table, as shown an a tbcheck, you wil…
Re: Help calculating extents from esql-c
As to your initial question, I do not think that you will be able to calculate the number of extents. As far as I am aware tbcheck is the only way that you can calculate the number of extents on a table. If you look at the extent sizes for a table, as shown an a tbcheck, you wil…
Extents and query performance
Recently I was adjusting a performance test, trying to keep it in a reasonable amount of time (for a test) and at a time one of the querys started to take much less time than before. The people that were doing the test told me that the only change made was in the extent size o…
Synonym
I had never used a synonym until recently. As part of my backup routine I perform a integrity checks using/resulting in: STUDENT - CHECK TABLE INDEXES AND ROWIDS IN INDEX; CHECK TBLSPACE DATA ROWS INCLUDING BITMAPS, REMAINING PAGES AND BLOBS: tbcheck -cI -cD -q stud…
EXTENTS discussion proposal
Proposal for Group discussion Some One-Liners about EXTENTS... 1. An EXTENT is a physical unit of storage. 2. EXTENTS are defined in Kilobytes. 3. A TABLE has a FIRST EXTENT and a NEXT EXTENT size. 4. EXTENTS are contiguous PAGES contained in a CHUNK. 5. De…
Need help with tblspace overflow
I have an application that has recently been convered to run against a transaction logged database. Prior to TL it worked fine. With TL, most of the time it still works fine. However, when it is working against a very large temporary table it aborts with the following messages…
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…
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?…
Re: TBLSPACES and Frag Index Creation
charlie.muntz@vallley.net (Charlie Muntz) wrote: >Online 7.1 on a SPARC/1000; Solaris 2.4 >Trying to create an index on an integer field in a fragmented table (fragged on the int); >If the table is approx 20K rows, engine wants about 50 TBLSPACES during index creation; >If the t…
TBLSPACES and Frag Index Creation
Online 7.1 on a SPARC/1000; Solaris 2.4 Trying to create an index on an integer field in a fragmented table (fragged on the int); If the table is approx 20K rows, engine wants about 50 TBLSPACES during index creation; If the table is 200K rows, the engine wants about 400 TBLSPACE…
Re: **MEMORY FAULT***HELP?!****
In article <3m3ppc$pb4@cssun.mathcs.emory.edu>, jvemo@cyberspace.com says most eloquently... > >At 02:18 PM 4/4/95 GMT, Roshanak N. Cyrus wrote: >} >}/users/informix->tbcheck -pe perform2 >} >}WARNING:TBLSpace demo1:informix.t_cdedcde has more than 8 extents. >}WARNING:TBLSpace i…
Re: **MEMORY FAULT***HELP?!****
At 02:18 PM 4/4/95 GMT, Roshanak N. Cyrus wrote: } }/users/informix->tbcheck -pe perform2 } }WARNING:TBLSpace demo1:informix.t_cdedcde has more than 8 extents. }WARNING:TBLSpace ifamperf:ifam.system_log has more than 8 extents. }WARNING:TBLSpace st09:informix.t_cdedcde has more t…
**MEMORY FAULT***HELP?!****
/users/informix->tbcheck -pe perform2 WARNING:TBLSpace demo1:informix.t_cdedcde has more than 8 extents. WARNING:TBLSpace ifamperf:ifam.system_log has more than 8 extents. WARNING:TBLSpace st09:informix.t_cdedcde has more than 8 extents. WARNING:TBLSpace st09:informix.t_wks has …
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…
Re: reclaiming tblspace
>: There are two ways to do this: >: 1) If the table has an index, use SQL to ALTER INDEX TO CLUSTER. >: This will physically re-arrange the data in the table to match the index, >: freeing up unused extents space along the way. This method requires free >: dbspace >= (tablesiz…
Re: reclaiming tblspace
Clem Akins (cwakins@leia.alloys.rmc.com) wrote: : FYHG22F@prodigy.com (Reed Mathews) : Subject: online engine use of disk space : > I have been working with the informix online engine 4.0 for : > about 2 years now and we have gradually filled the disk space : > allocated to the…
reclaiming tblspace
FYHG22F@prodigy.com (Reed Mathews) Subject: online engine use of disk space > I have been working with the informix online engine 4.0 for > about 2 years now and we have gradually filled the disk space > allocated to the database. (We are running at about 99% now.) > We do pla…
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: Export/Import Database - Help??
In article <392a42$jhv@arcadia.informatik.uni-muenchen.de> spitz@ana.med.uni-muenchen.de writes: >How can Online fit all tables into one extent? AFAIK, dbimport >uses the default extent size of 16k, so large tables will get >split into many little pieces, and performance will deg…
Re: Export/Import Database - Help??
>>>>> Richard Spitz <spitz@GANS2X.ana.med.uni-muenchen.de> writes: > How can Online fit all tables into one extent? AFAIK, dbimport > uses the default extent size of 16k, so large tables will get > split into many little pieces, and performance will degrade serious- > ly if the …
dbimport and extents
Dr Richard Spitz (spitz@ana.med.uni-muenchen.de) posted: > Bill Ennis (ennis@ssd.comm.mot.com) wrote: > : Warning: If you are using Online you will lose the dbspace/extent > : information ;( However, it does fit all tables into one extent ;)). > > How can Online fit all tab…
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...…
Extents
|>In article <2p0snc$cil@maicgn.SoftwareEngineering>, ar@mai.de (Achim Reiners) writes: |> |>|> |> Is it possible to change these for the system tables as well? These |> tables were the first ones exceeding the warning level of 8 extents! |>|>I know there is an answer to this on…
Extent sizes
ar@mai.de wrote: AR> I would like to have a better feeling about the performance impact > of the definition of extent sizes (first and next) for tables. It is important that you don't have too many extents, because you are in effect dealing with a fragmented drive if you do. A…
Extent sizes
Hello Tuners, I would like to have a better feeling about the performance impact of the definition of extent sizes (first and next) for tables. In our production database ( Online 5.01 ) we have already tables with about 50 extents. tbcheck already gives a warning at 8 extents.…
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…
Re: tblspace does not exist
this is what informix told me to do...…
Re: tblspace does not exist
In <22jhelINN95c@emory.mathcs.emory.edu> inf_bb@hermes1.sps.mot.com (informix users bb) writes: >sebastian, >NOTE: any and all disclaimers apply (naomi, correct me if i get this wrong). >you can get rid of this problem table by (call it tab1 for this example): >1. create a ta…
Re: tblspace does not exist
sebastian, NOTE: any and all disclaimers apply (naomi, correct me if i get this wrong). you can get rid of this problem table by (call it tab1 for this example): 1. create a table with the exact schema as tab1 called tab2 2. get the tabids and partnumbers for tab1 and tab2 se…
tblspace does not exist
Hi informix combattants ;-) I encountered a new problem, really nasty and annoying. I have: INFORMIX-OnLine Version 5.00.UC1 Thu Jan 9 19:27:54 PST 1992 From times to times my 4GL application crashes and it says: Program stopped at "cl_stat.4gl", line number 245. SQL st…
next extents
David, David, and John, Thank you for your responses, I will try one or the other - and perhaps all of them and let you know. j. _____________________________________________________________________________ Jack Parker - Contractor | Hewlett Packard, BSMC Boise, …
Extents and dbimport
This is for informix support types: Does dbimport compute what the extent sizes should be based on the commented information contained in the database.sql code? And if not, shouldn't it? j. _____________________________________________________________________________ Jack Par…
Calculating Extents
Can someone please tell me a reliable way to calculate extents on tables with TEXT BLOBS? I've tried using the formula in the book, but that doesnt work well. In our case, this BLOB is in the tblspace, not in a blobspace. Does it make a difference? Should I just use the avera…
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: tblspace overflow (fwd)
In article <9260@emory.mathcs.emory.edu> cris@logic.dsg.ti.com (Cris Schramm) writes: >> From: clay.irving@execnet.com (clay irving) >> Subject: tblspace overflow >> >> The only way I know to increase this value is to initialize the >> database and increase the shared memory par…
tblspace overflow (fwd)
> From: clay.irving@execnet.com (clay irving) > Subject: tblspace overflow > > The only way I know to increase this value is to initialize the > database and increase the shared memory parameters -- this is going > to clear {m{y root dbspace (not quite a friendly thing)! > Does a…
Re: tblspace overflow
Another response from one of our closet engineers :-) ... ----------------------------------------------------------------------- >From clay.irving@execnet.com (clay irving) Newsgroups: comp.databases.informix Subject: tblspace overflow Date: 3 Aug 92 19:04:55 GMT I have an Inf…
tblspace overflow
I have an Informix database (4.1) with over 300 tables. I used dbexport to unload the database. I then used dbimport to create a copy of my database in another dbspace, but I received an error message: 311 - Cannot open system catalog (sysviews) 141 - {ISAM error: tblspace table…
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 …
Re: Number of extents in a tblspace
> > > > >Hi folks, > >How can I figure out the number of extents in EVERY tblspace of a database? > >Thanks in advance. > >ats :) > >-------------------------------------------------------------------------------- >| Abilio Tavares da Silva …
Number of extents in a tblspace
Hi folks, How can I figure out the number of extents in EVERY tblspace of a database? Thanks in advance. ats :) -------------------------------------------------------------------------------- | Abilio Tavares da Silva | | …
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…