Oninit® Archive
Results for “TBLSPACE_STATS”
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 ------------------------------…
SQL query cost is very high
Hi Indika, There is a big difference between rows estimated and rows produced. Possibly your statistics are not up to date. You may like to run update statistics on tables involved in SQL and try. Regards, Nandkishor Singare -------------------------------…
Want to DROP an empty rootdbs chunk
Hi, There need to be a supported command/method to say get "system" i.e non table or index pages (e.g. exteneded reserved pages, database tblspace, tblspace tblspace pages) out of a chunk and moved to a diferent chunk in the same dbspace! Or have drop chunk be smart enough to do …
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.…
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 ------------------------------…
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…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
Checkpoint statistics
Hello all, I am posting the checkpoint statistics output below onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 2 days 07:38:02 -- 5318400 Kbytes AUTO_CKPTS=On RTO_SERVER_RESTART=60 seconds Estimated recovery time 23 seconds Critical Sections Phys…
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…
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…
Issue with statistics
We have a primary and a secondary. The secondary is a reporting server, and when one of the report creators adds a table to the sql query, the performance of the report grinds to a halt. It ran fast before adding this table to the query. Is there some way I can check to see what…
BUFFERPOOL
Thanks Mike for your valuable answer, and yes im running UPDATE STATISTICS HIGH on table with indexed columns…
UPDATE STATISTICS
Dear friends, As our application be running slow since DB migration is done. Informix version: 12.10 FC8 Application developed in Java and server running under JBOSS. OS: windows 2012 R2. I have done DB migration from old server to new server which is of same hardware and softw…
Checkpoints statistics
Hello Users, We are using IDS 12.10 FC8 DB server, Application is developed in Java and app server is JBOSS Our application is taking long time to save the data into database trhough application. Find the online log details below: 09:23:22 Checkpoint Completed: duration was 0 …
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.…
"output to" question
Hi All, I am having an issue with the following code output to /opt/gim2usr/scripts/nbupstat1.sql without headings select "UPDATE STATISTICS MEDIUM FOR TABLE "||trim(tabname)||";" from systables where .... when the output string exceeds 65 characters the line is split example:…
Is it just me...?
Have you tried UPDATE STATISTICS ... ?…
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.…
-12014 Smart Large Objects: Cannot find entry in
-12014 Smart Large Objects: Can not find entry in lofd table. This error occurs in informix 12.10FC8 when activating ER Keys The solution is to apply the deletion of statistics as follows Update statistics low drop distributions only; Caution should be exercised in productive…
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…
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…
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…
Rebuild Distributions After an Upgrade - Best Prac
I'm performing in-place upgrades from 11.50 and 11.70 to 12.10 and I am interested in the best way to drop and recreate distributions to minimize impact. Would this be the most reasonable approach? for each table: update statistics for table <table> drop distributions only; u…
SQL return high query cost on ids 12.10
Hi, Yes, i already run update statistics high for this table. Thank You…
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.…
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…
update statistics
hi, for the leading column, i want to do the update statistics high, I have two method to run it. method one: update statistics high for <table name>(col1,col2); method two update statistics high for <table name>(col1); update statistics high for <table name>(col2); Do met…
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)…
Performance issue
Hi, Do you have statistics updated?…
Informix use the wrong index
ok, I will launch update statistics high for the 2 tables…
Update statistics
Hi All, Getting below error: update statistics low using sampling may generate inaccurate index statistics for index 'some column' due to data skew Thanks…
widows batch file for informix Update statistcs
Hello, does any one has windows batch file(script) to run update statistics and need to run it with schedule task. Thanks…
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
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
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.…
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…
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…
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.…
After I run statistics any system table update
Hi All, Please let me know if i run statistics using below command after I have completed statistics any system table is getting update UPDATE STATISTICS FOR TABLE <Table Name> Version: 11.50 FC9 Thank you Regards Baskaran --001a113490fa5e866304edf2b37d…
Warning: The storage pool is out of space
Doesn't SP_THRESHOLD = 0 mean it is the automatic is off ? > Hello All, > > I am using the IDS 11.70 FC4, and I am not using the automatic storage > pool > provisioning feature. > > But, I have seen this message in the online.log file. > > I have enough free space available in t…
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.…
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…
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…
update statistics comparison
Hello, Honestly, although doing update statistics for years :-) , still not in 100% clear on some results comparisons ( the optimizer likes one better than other ....) OK. What are the major possible differences of the following two sets of update statistics jobs for a table? H…
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…
Error by Auto Update Statistics
Hallo, IBM Informix Dynamic Server Version 11.70.UC5X4 Linux 2.6.32.59-0.3-default #1 SMP 2012-04-27 11:14:44 +0200 x86_64 x86_64 x86_64 GNU/Linux I see every night this error in the online.log: 01:00:04 SCHAPI: [Auto Update Statistics Evaluation 32-41] Error -1265 Overflow o…
UPDATE STATISTICS may use indexes?
I'm chatting with a customer DBA about UPDATE STATISTICS HIGH and he's reporting some seemingly counterintuitive performance results... On a table having three columns (say A, B and C), he is reporting: UPDATE STATISTICS HIGH FOR TABLE tbl(A); UPDATE STATISTICS HIGH FOR TAB…
update statistics
Hi, Folks, IDS11.50 FC8 Assume a database has 100 tables: tab1,tab2,....tab100. What are the Major differences between the following two approaches for updating statistics? Approach 1: Just run a "update statistic" for whole database, update statistics; Approach 2: Run upda…
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…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
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…
Wait and Queue statistics
Can anybody provide clues on how to interpret onstat -g wst and onstat -g qst output please? I looked at the standard documentation but not much useful. Thanks, idos…
Stupid question
If Art, the data is already loaded, also constraints, stored procedures, etc.. He is now at the stage of updating statistics.…
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 …
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.…
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…
Re: Automatic Update Statistics
Hello, This topic was already discussed on IIUG forum, look for the old posts, and you´ll find the solution, ok? Best regards. Em 09/08/2011 05:04, Fernandez Garcia, Domingo escreveu: > Error -1284 -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hot…
Automatic Update Statistics
Good morning, We have installed IDS 11.70.FC1GE on Red Hat Enterprise Linux Server release 5.7 (Tikanga). Every day we see the next message in online.log: 01:00:17 SCHAPI: [Auto Update Statistics Evaluation 29-xx] Error -1284 Value will not fit in a BIGINT or an INT8. We don't …
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 ?…
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…
update statistics generated automatically?
But that was my question: the 'update statistics' command is NOT programmed in the application, it must be generated somewhere automatically but I don't know where!!…
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. ==========================================================…
Performance issue
Hi, I tried your query and it has a bit improve, but still not normal speed. I will update statistic for the whole database with your advise, then run the query again. I will date. Thank you all for your advices. update statistics low drop distributions; .... .... update statis…
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…
Set tables activity
Hello anybody Other question. Update statistics modified that table? Thank Servio Velasco…
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…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
sql insert increases the value of nreads in onstat -u
One more thing was a bit too trigger happy: Make sure TBLSPACE_STATS 1 in your onconfig if you can run this stand alone eq noone else accessing it during a test then maybe zero the counters (onstat -z) and run your stuff. then when done select * from sysmaster:sysptprof -->> c…
update statistics
How can i know which tables needs update statistics , Is there any query in sysmaster which can provide this information ?…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
SQL slowdown. Index rebuild?
Sorry, forgot to mention that update statistics drop distributions was done and a re-creation of the statistics LOW and MEDIUM for the tables and HIGH for the indexes.…
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 …
Update Statistics
If the AUS evaluator is run and says x number of tables need stats updated, then AUS runs and no-one touches the database, shouldn't the number that the evaluator says are needed decrease? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computi…
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…
hdr and statistics
Ever since I started HDR on a second server, the statistics have been different. After a db restart, sometimes onstat shows statistics on the primary server and the secondary shows as zeroed out, sometimes the opposite. Then it stays that way to another restart. Can't figure out …
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…
Question about seq scans on a table
Statistics are up to date. In a few hours i will extract the index size for each one of them. Thanks Leonardo…
Check query execution time in IDS 10 fc9
For your second question, the sysmaster:syssessions and sysmaster:syssesprofile tables have information about each session and what resources they are using. For the first, you have to turn on partition profiling in the ONCONFIG file (TBLSPACE_STATS). Once that's done, the sysma…
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…
Update Statistics
I've seen the recommendation to do update statistics on ids on this list over the last couple months in certain situations. Sadly I know little about administering IDS but I've muddle through so far. I was wondering if someone could do a quick tutorial about update statistics cov…
Update statistics after the upgrade
All, in a recent post on IIUG forum (http://www.iiug.org/forums/ids/ index.cgi/read/18706) Art and others explained why it's important to run update statistics after a major upgrade. I'd now like to ask how, or more precise, what is the most efficient way to do it in a 24/7 envi…
SDS & update statistics performance
Hi My situation: 1. I use MACH11 with IDS 11.50FC5W2 on Sun Solaris On Secondary server UPDATABLE_SECONDARY 0. 2. On SDS server assert and server stop: 15:56:34 Rollforward of log record failed. iserrno = 126 15:56:34 Log Record: log = 4807652, pos = 0x105558, type = OLDR…
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…
views and update statistics
hi all how can one see the last time statistics were update for a view? or does it just relate back to when the tables within the view were last updated? thanks much -…
Indexes usage
IFF you have TBLSPACE_STATS set to 1 in your ONCONFIG file, you can find the stats on your index partnums in the onstat -g ppf and depending on your server version (you REALLY must post your IDS version and platform information when you post!) you will find the same information i…
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…
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…
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.…
mutex dbs_partn and pt_170003
Hi people, im not really sure if was something related with statistics, but i ran statistics medium for the table, and user applications and batch process ran better, without waiting mutex. However anyones has an opinion about this issue??…
User statistics
How can I see the user Statistics on Database, tables their sessions, which table user is accessing, data that user trying to fetch on informix version 7.3.…
update statistics
Hi, we renamed a column which have no index and its not referenced, Is there need to run update statistics on this table? Regards, Khurram.…
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.…
dostats error on procedure nvl
Hi Art, dbschema --> create procedure nvl(val nvarchar(254), rep nvarchar(254)) returning nvarchar(254); begin if val is not null then return val; else return rep; end if; end end procedure; dostats file output( i think you dont need the whole file?) --> .... UPDATE STATISTI…
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…
UPDATE STATISTICS Performace Improvement
Hello, How can I improve the execution performance of 'Update Statistics'?? In our OLTP system we want to avoid any sysprocplan issue and for that purpose we need to execute update statistics as speedily as possible. Regards, Anees Ahmad…
update stats on syscdr database
Should we be running update statistics on syscdr database ? Currently we dont…
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 …
Re: Update Statistics
Colin Dawson wrote: > IDS 9.40.FC8X3 > Solaris 10 > SUN M5000 16*4 core CPU 128Gb Mem > > dostats version on this server:- Features Version 5.10, Source Revision: > 1.125 > > > > Sorry to raise this topic again. > > We have a table with 654,484,092 rows, fragmentation is round ro…
Re: Update Statistics
Hello Colin, The "dostats" is a very fine product that would be hard to beat. The only things the might help are "LIGHT_SCANS=FORCE", creating multiple temp Dbspaces on ramdrive (you can use PSORT_DBTEMP for this), use PSORT_NPROCS, DS_TOTAL_MEMORY 4000000, MAX_PDQPRIORITY 100,…
Update Statistics
IDS 9.40.FC8X3 Solaris 10 SUN M5000 16*4 core CPU 128Gb Mem dostats version on this server:- Features Version 5.10, Source Revision: 1.125 Sorry to raise this topic again. We have a table with 654,484,092 rows, fragmentation is round robin in 8 fragments. Indexes a…
about update statistics performance ?
Hi , I have somw questions about update statistics from AnswerOnline 11.5 as following : Here from IDS11.5 : Example of UPDATE STATISTICS HIGH statements for the first column in each index that differs: For example, suppose you have the following indexes on table t1: CREATE …
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…
update statistics after 9.4 to 10 migration
Hi everyone. I have read up on this but I am still a little unclear on what needs to be done regarding update statistics after migration a database from IDS 9.4 to IDS 10. After I bring up the old 9.4 database in the new version 10 environment is it necessary to do: update stat…
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 > --------------------------------------------…
querying during update statistics
Our DBA has shoved doing update statistics on our sales table to be while I am doing some heavy duty queries. The queries are taking much longer. Could update statistics be causing this? Thanks JPS…
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…
stored procedure query vs dbaccess
ANTHONY JUDISH wrote: > > Yes OTC, we've run update statistics on the tables and sp. ;) Yes, but are you sure that the statistics you have are what you think they are? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Re: identify changes for level 1 backup?
davidegrove@gmail.com wrote: > On Oct 20, 1:11 pm, Fernando Nunes <domusonl...@gmail.com> wrote: >> davidegr...@gmail.com wrote: > >>> When I see a >>> sudden, large increase in the size of a Level 1, I would like to know >>> what caused it. >> What I tried to explain is that al…
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…
Re: Long checkpoints
On Sep 10, 4:47 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > askel wrote: > > Hello there, > > > I've been reading about long checkpoints issue for a while but haven't > > found solution for our case. > > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fir…
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…
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…
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.…
Parameter tuning?
Good point Art. I also wonder whether statistics have been collected. Awfully high sequential scans. j.…
update statistics
I want to demonstrate the potential effects of update statistics in a repeatable way but am having trouble doing so. This is for a customer using an elderly version of Informix SE. Here's what I did. 1) create table item (code integer, name char(30), type char(1), cost integ…
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…
update statistics at the same time
hi, everybody. can I run update statistics on different tables at the same time, then they will run Parallel, to save time. thanks…
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…
Detecting unujsed indexes *NM*
ANDY KENT wrote: > How can I tell which indexes have never been used? Client seems to have rather > a lot of gratuitous single-column ones. I was hoping there might be a kind of > persistent sysptprof out there somewhere ... > > It's a 7.3/ Windows system being migrated to 10.0/ …
DROP chunk error.
NETSKY LIAO wrote: > Hi,all > > While I want DROP a CHUNK(/usr/informix/disk/wjfl3) from the DBSPACES,I had > drop the tables which in the CHUNK. These have > > TBLSPACE TBLSPACE 435002 50 > > FREE 435052 89235 > > report from oncheck -pe, So when use "onspaces -d <dbspace> -p <c…
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 …
Re: Oracle University Turkey ... follow-up
DA Morgan wrote: > Neil Truby wrote: >> >> Have you tried UPDATE STATISTICS? > > I don't even know what it is. At least with respect to an Oracle DB. Daniel, Update Statistics is the equivalent of the Oracle DBMS_STATS package.…
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…
Cannot drop stored proc after crash
you may update statistics for this procedure first, and then try again.…
Error in update stats
Version IDS 10: When I run update statistics I get error 255 on different tables at different times. Could it be because inside update statistics we are trying to commit something to sysdistrib database and it's just failing.…
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…
DYNAMIC HASH JOIN and SEQUENTIAL SCAN
> assume you have a test system... and noone accesses it but you.. > > onstat -z > > dbaccess <yourdb> yourqr.sql > /dev/null > > assume TBLSPACE_STATS 1 in your onconfig > > dbaccess sysmaster <<! > select * from sysptprof > ! Thank you very much for your advice. I will test…
Update Statistics
Hello, during the execution of UPDATE STATISTICS to the tables of my BD, as it is the impact that produces the execution. Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
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 ?…
table wise statistics
Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall statistics but How do get it for individual tables? Regards, Nandkishor…
Re: long checkpoints on informix
On 16 jul, 06:34, Ben Thompson <b...@nomonitorsoftspam.com> wrote: > Sakura.g...@gmail.com wrote: > > hi everyone > > i recently start to have some long and constant checkpoint > > i did lot of change but cant reduce it > > i have Informix Dynamic Server Version 9.40.FC2 > > and …
Re: long checkpoints on informix
On 16 jul, 06:34, Ben Thompson <b...@nomonitorsoftspam.com> wrote: > Sakura.g...@gmail.com wrote: > > hi everyone > > i recently start to have some long and constant checkpoint > > i did lot of change but cant reduce it > > i have Informix Dynamic Server Version 9.40.FC2 > > and …
long checkpoints on informix
Please post the output from: onstat -m onstat -d onstat -D onstat -u onstat -g iov Sakura.ggxx@gmail.com said: > hi everyone > i recently start to have some long and constant checkpoint > i did lot of change but cant reduce it > i have Informix Dynamic Server Version 9.40.FC2 >…
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…
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…
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: update statistics
A good starting point for update statistics: for every table: update statistics low for table <table> (<all columns that are part of an index>); update statistics high for table <table> (<all columns that head an index>) distributions only; update statistics medium for table …
update statistics
The IBM web page at http://www-1.ibm.com/support/docview.wss?rs=0&context=SSGU5D&context=SSHMMC&context=SSGU8G&context=SSGKNY&context=SSGU5Y&context=SSCRW7&context=SSGHZP&context=SSVT2J&q1=update+statistics&uid=swg21137764&loc=en_GB&cs=utf-8&lang= says to update statistics thusl…
RE: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
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…
Update statistics for large databases
Hi, how can I obtain a short time for my update statistics on a large databases. It's run on a machine with 8 processors, 32 Gb Ram, RHEL4 and IDS 10 FC4. My script for update statistics begins with update statistics medium on database and continue with update statistics low an…
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)…
Query Problem
Hi Got the solution for the problem We have to run Update statistics on all the tables involved in the query.…
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 ;-)…
The delete dosn't delete some records
Run 'update statistics high' and 'oncheck -cID' on that table. Also run 'oncheck -cc' to check the catalog. -Sanjit…
Performance Tuning Tips for Informix.
First check what oninit proc it is; most likely a cpu vp. (onstat -g glo gives the pid.) then i would check for seq scans -->> onstat -p -->> if TBLSPACE_STATS is 1 on $ONCONFIG goto sysmaster and select * from sysptprof-->> secscans. check for the tread(s) which are a lot acti…
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: 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…
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…
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…
update statistics
Hi, What are the best pratices to run update statistics? having: IBM p520 4 cpu's 16Gb AIX 5.3 IDS 9.40.FC8 tks Henrique Lima henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br _______________________________________________________ Você quer respostas para suas pergunta…
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…
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.…
Update statistics
Hi Gurus, When the system is running "update statistics", will it affect insert, update? We have some issue recently. We start to process business transaction at 6:00AM, when there is "update statistics" job running, some insert been rejected. The return code is "144","211". Any…
Re: statistics
On Fri, 7 Jul 2006 13:19:29 -0400, "Campbell, John \\(GE Cons Fin\\)" <John.Campbell2@ge.com> wrote: >Yes, I am very reluctant to mash on any system tables. This load routine runs a stored procedure every day that does an update/insert. If row found update it - if not insert i…
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: statistics
Yes, that was the suggestion - unload and keep the old distributions, run the load (insert/update routine), drop the distributions, and then put the old distributions back. -----Original Message----- From: gsturkenboom@lic.co.nz [mailto:gsturkenboom@lic.co.nz] Sent: Thursday, Ju…
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 …
Re: statistics
The statistics are exported in the sql file created during a dbexport and run as part of the dbimport. Could this be what they are refering to? Gerry PS IDS 7.31 Solaris 9. "Campbell, John (GE Cons Fin)" <John.Campbell2@ge.com> Sent by: informix-list-bounces@iiug.org 07/07/2006…
statistics
9.40.FC5 Solaris 9. Someone has suggested to me that I could unload the statistics data from the database catalog, run the batch data load, then put the old statistics back. They did this years ago on a Tandy - I don't know what database. They claim performance was not negativ…
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 …
Performance issue after 732 to 94fc6 upgrade
See below: > ----- Original Message ----- > From: Doug Fossmeyer <ids@iiug.org> > At: 6/12 20:13:55 > > > Part 2 of posting > > onstat -c > > IBM Informix Dynamic Server Version 9.40.FC6 -- On-Line -- Up 2 days > 19:54:35 > -- 2325280 Kbytes > <SNIP> > TBLSPACE_STATS 0 # Maintai…
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?…
Problem of Performance
Hi, which parameters (values) have changed radically? At OS level: Do you have higher CPU loads than before or higher disk IO load? Are you sure that your application didn't change? New features/different usage? Maybe SQL execution plans have changed! Do you run update statis…
Re: IDS 9.4 Slower then IDS 7.31
update statistics for procedure ?? Give this a try (just the first shot): $ onmode -C threshold 20000…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: IDS 9.4 Slower then IDS 7.31
Please run UPDATE STATISTICS LOW on your databases and report back if you still run into performance issues.…
Performance degradation through wstats
Yes, i agree with you, that it's a good idea to turn this statistics on. I asked, because i heard (in older constributions to c.d.informix) that it's a very bad idea (performance wise) to use this statistics in a production environment.…
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.…
update statistics
Hi, I have an error during executing the following command update statistics high for table tablename1 SQL Error(-567):Cannot write sorted rows ISAM error:no free disk space for sort Where it tries to find free disk space (tempdb or on the dbspace that the table resides)? The s…
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…
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!…
update statistics - distributions
Talk to IBM. Certainly update statistics with distributions will briefly take locks on system tables so you will need to set lock mode to wait 30 for applications and at the start of the update statistics script.…
DBDATE format issues
Make sure the session that creates the stored procedure or does update statistics on the stored procedure has the correct DBDATE setting.…
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 …
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 …
Update Statistics
This is some output from dostats TABLE(MEDIUM)...SUCCESSFUL (34.174 Secs) COL1(HIGH)...SUCCESSFUL (963.907 Secs) COL2(HIGH)...SUCCESSFUL (1061.096 Secs) COL3(HIGH)...SUCCESSFUL (1250.274 Secs) COL2, COL3(LOW)...SUCCESSFUL …
Update Statistics
This is some output from dostats TABLE(MEDIUM)...SUCCESSFUL (34.174 Secs) COL1(HIGH)...SUCCESSFUL (963.907 Secs) COL2(HIGH)...SUCCESSFUL (1061.096 Secs) COL3(HIGH)...SUCCESSFUL (1250.274 Secs) COL2, COL3(LOW)...SUCCESSFUL …
Re: Insider #65: Highlights: IIUG Board of 2006 elections, Informix
Have you tried UPDATE STATISTICS?…
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.…
Update Stats Question
hmm, firstly will that be possible? I guess the update statistics does a exclusive lock on some tables during updating the statistics, so I see it may not be a good idea. btw, what is the purpose behind doing this?…
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.…
Re: Heavily used tables
There are some scripts I wrote that are in the IIUG repository grouped under "Monitor", one of the scripts gets table level access counts Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Simon" <si_g_palmer@yah…
Heavily used tables
anjay.shah.21@talk.geekinterview.com wrote: > Hi, > > Is there a way of finding out which tables within the database are > heavily used? It does not necessarily mean new data, but could be lots > of queries against the tables rather than inserts. > > Normally thehe DB/App design…
Re: OT: IDS 10 QPlan sanity failure problems
the requirement to run aupdate statistics for procedure is supposed to be documented in the IDS 10 migration guide if its not then its a docs bug…
update statistics
Hello, We recieved this message from a cron job over the weekend: 564: Cannot sort rows. 179: ISAM error: no free disk space for sort Error in line 50 Near character position 44 question - does Informix always go straight to disk (temp db spaces) for sorting? is it even a…
Datetime of Altered Table
The column created in systables is the last time an alter table was run on that table. The only way of determinine when the last activity (excluding select) is to trawl through the logs with onlog, assuming you have sufficient logs to trawl through and you have not done your own …
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…
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…
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…
update statistics on system tables
IDS 9.4 on HPUX 11i Is it recommended to run update statistics on the system tables?…
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:…
More Update Statistics
Ok. I think all but 2 of my questions relating to update statistics have been answered. If anyone knows the answers to the following 2 questions, I'd appreciate some feedback. 1. Do the update statistics performance enhancements appear in 9.30.XC2 or 9.30.XC3? I have 2 docum…
Update Statistics
For the following table on IDS versions 9.30xC2 and up create table t ( a integer, b integer, c integer, d integer, e integer ) create unique index idx1 on t (a, b); create index idx2 on t (b, c, d); create index idx3 on t (b, c, e); do update statistics low fo…
Find out less used index?
Hi, if you have detached indices (indices in their own tablespace fragments, e.g. with their own names) you can activate TBLSPACE_STATS and afterwards you can do a the following SQL on sysmaster: select dbsname,tabname,sum(bufreads),sum(pagreads),sum(isreads) from sysptprof wher…
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…
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: Help with Informix !!! Really Important!!!
i do not really agree with Chris, start tuning it:!!!!! if 512MB ram why BUFFERS 200000 # Maximum number of shared buffers are you using 800 MB for your buffer cache??? this will NOT perform. i agree that you need to configure a tempdbs!!! also onstat -p woul…
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…
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 …
Need help!! Sql to Informix Migration
did you run update statistics?…
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…
update statistics
when update stats are run, is the table being locked? if so, is there a way to work around that? IDS ver 9.40_FC3 ----- HP-UX 11i Thanks, Tom…
update statistics
when update stats are run, is the table being locked? if so, is there a way to work around that? IDS ver 9.40_FC3 ----- HP-UX 11i Thanks, Tom…
Update statistics
Wayne, While yes, it does delete the distributions in the sys tables, it also performs an update statistics low on each table. Oddly enough, update statistics low (gathering basic table and column statistics, not distributions), can take longer than update statistics medium (sam…
Update statistics
Why would "update statistics drop distributions" take several hours.....? And it is still running.... I would have assumed that this would just basically be a delete in the sys tables. Am I wrong? Please do not transmit orders or instructions regarding a UBS account by email. Th…
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…
> btree pages in cache
Hi list, I have an excessive # of btree pages in cache (on 7.31.UD8, AIX 5.2). onstat -P shows: ---- 8< ---- Percentages: Data 19.76 Btree 78.54 Other 1.70 ---- 8< ---- I have TBLSPACE_STATS switched on in $ONCONFIG. Does anyone have an idea how i can tie up a session with pag…
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…
Scope change.
Leopold, If most of your tasks are reporting only and you are using HDR as the log you posted shows, why not run the read only reporting tasks on the DR secondary and reduce the load on your primary server? On a point of information HDR, which you call transactional replication…
RE: shmget: [EEXIST][17]: key 52564801: shared memory already exists
Hi Sergey. This error messages means can not create shared memory. Make sure output of ipcs command. Probably shared memory key exists. Try onmod -ky and oninit again. OR Reboot your machine. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: sshumilov@yahoo…
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…
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: Questionable IDS 9.21 performance on HP-UX v11.11
Jason wrote > We're having severe performance problems with our OLTP Delphi > app that connects to IDS via ODBC. > Having researched the problem I can find no glaring operating > system or database-configuration issues as such and my > suspicion lies firmly with the application…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
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…
Informix using onbar + ontape together
On Thu, 29 Jul 2004 10:39:47 -0400, Nat wrote: You cannot mix ontape and onbar. If you have to restore IB that onbar cannot read the logical log tapes/files that ontape makes. Change your alarm program to use onbar. Art S. Kagel > I am doing backup with onbar. I have also se…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: I may have missed it in your long post, but I didn't see anything about disc layouts or number of CPUs. Also I may have missed it as well but I couldn't see any output from "onstat -g iof" or "onstat -g iov". I have commented on your onconfig anyway. > OK …
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…
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…
RE: ONCONFIG for 9.40 offered for comment
Neil- That's what we thought when we first upgraded one of our engine to 9.4. We discovered that do to some change in the optimizer, it would no longer use indexes on temporary tables, unless you ran UPDATE STATISTICS for that table after loading it and building the index. If …
RE: ONCONFIG for 9.40 offered for comment
after we upgraded to 9.4, we also experienced slowness in few of the queries, we had to modify the queries to speed it up, few of the changes what we did are 1) after examining the explain plan, we found some queries were doing sequential scan in 9.4, had to create few indexes t…
Re: ONCONFIG for 9.40 offered for comment
Neil Truby wrote: > Not sure what TBLSPACE_STATS does It causes the engine to record stats about table activity, so there's the time and space overhead of that. It's noticable but not nearly as bad as QUEUE_STATS (sp?) which is apparently quite appalling. The downside to switch…
ONCONFIG for 9.40 offered for comment
Neil Truby wrote: > 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 refle…
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…
Is it good to run update statistics as follows for system tables ?
--0-1818311736-1085258509=:39755 Content-Type: text/plain; charset=us-ascii Hi all, I am dropping dustributions while updating statistics for sytem tables. Is this a good idea ? Examples : update statistics low for table sysaggregates drop distributions; update statistics lo…
TBLSPACE_STATS
The SMI tables maintained when you have TBLSPACE_STATS show statistics since - when? How do you zeroise the counters? Thanks Andy…
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.…
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…
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,…
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…
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…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Re: Puzzling performance issue?
On Tue, 25 Nov 2003 11:14:40 -0500, Eric wrote: Eric, comments and suggestions below: <SNIP> > Informix Dynamic Server Version 7.31.UD4 -- On-Line -- Up 4 days 17:31:46 > -- 315104 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 4…
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.…
Statistics for comp.databases.informix
Following is a summary of articles spanning a 31 day period, beginning at 30 Sep 2003 23:23:12 GMT and ending at 31 Oct 2003 20:40:56 GMT. Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\\s{0,3}(…
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.…
Re. Indexes
Hi, I don't know of a way to count "index hits" by "number of SQL statements utilizing the index". But you can do the following for detached indexes (where the index has it's own partition number) : - set TBLSPACE_STATS to 1 in your $ONCONFIG file and "bounce" the instance. (Th…
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 …
UPDATE STATISTICS
Imagine a table tab1 with a bazillion rows and five columns. There is one index on the table, on column A. If I do: UPDATE STATISTICS LOW FOR TABLE tab1(col_a); ... it runs very quickly. But if I just do: UPDATE STATISTICS LOW FOR TABLE tab1; ... it takes hours, maybe days…
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…
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…
Statistics for comp.databases.informix
Following is a summary of articles spanning a 31 day period, beginning at 01 Jul 2003 00:32:43 GMT and ending at 31 Jul 2003 23:10:41 GMT. Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\\s{0,3}(…
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…
Statistics for comp.databases.informix
Following is a summary of articles spanning a 30 day period, beginning at 01 Jun 2003 00:09:06 GMT and ending at 30 Jun 2003 22:02:04 GMT. Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\\s{0,3}(…
Statistics for comp.databases.informix
Following is a summary of articles spanning a 31 day period, beginning at 01 May 2003 00:18:27 GMT and ending at 31 May 2003 22:58:33 GMT. Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\\s{0,3}(…
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???…
RE: TBLSPACE_STATS
Hi, In the machine notes for ids 9 I find the next text: "16. In this release, partition profiling can be disabled by setting a new configuration parameter, TBLSPACE_STATS, to 0 in the onconfig file. When TBLSPACE_STATS is set to 0, the output of onstat -g ppf will …
TBLSPACE_STATS
How much performance degradation can be expected if I turn TBLSPACE_STATS ON (=1). Thanks. Ravi…
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…
Statistics
Hi, Assume there is a table containing indexes built with a combination of single & composite keys. Is it of any use to run the low for statistics or is it sufficient to run high on all columns, that is, just run high individually on a, b, c and d? index1 = (a,b) index2 = (c,d)…
Statistics for comp.databases.informix
Following is a summary of articles spanning a 30 day period, beginning at 01 Apr 2003 and ending at 30 Apr 2003 Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\\s{0,3}(?:>|:|\\S+>|\\+\\+)/. -…
Re: Update statistics low drop distributions
There is no record of when an update statistics low was executed at all. However, if the last update statistics was a low drop distributions there will be no records in the sysdistrib table for the tabid(s) concerned and no output for the table(s) from dbschema ... -hd. Art S. K…
Update statistics low drop distributions
Is there a way to determine if the last time an update statistics was executed was it an "update statistics low" or an "update statistics low drop distributions"? Clay Velut Database Administrator SCF of Arizona cvelut@scfaz.com http://www.scfaz.com 602-631-2486…
Update Statistics question
7.x Is it possible to know somehow when the last time update statistics was run? Thanks…
large chkpoints with update program running
In the year of Our Lord Thu, 15 Feb 2001 11:47:32 -0000, "Tam McLaughlin" <tamm@scotlegal.com> spake, saying: >The system is going v v slow and it is most likely due to an update >progrm than has been running for over 2 hours. The following is the results >from onstat -u | grep …
KAIO statistics
I am built a small test database server to test KAIO. What does it mean when one KAIO is doing nothing and one KAIO has done everything? Here is onstat -d and onstat -g ioq Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 14:46:41 -- 24576 Kbytes Dbspaces address …
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 …
Re: Background ontape -c problem
At 02:48 01/01/26 +0000, russ_kahler@andersonsinc.com wrote: Hi. Please check the following. Errorno 1 means "NOT super-user". ifmx28% ls -l $INFORMIXDIR/bin/ontape -rwsr-sr-x 1 root informix 2231520 Jul 13 2000 ontape ^^^^ <- Another user? Please check o…
Update statistics
This is a multi-part message in MIME format. ------=_NextPart_000_005F_01C08068.1A7BF7E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I have something that worries me a bit. I wrote a 4gl program that will run the update statistics on my syst…
Informix Statistic
Hi all, I need some input from you all. What are the statistic that I can capture from informix (ie. number of transaction, i/o for each dbspaces etc ). My purpose here is to capture the statistic and plot out a graph. Thanks and regards, Tham…
Queue statistics
Hi! What should I do to enable queue and wait statistics ( those shown with onstat -g qst , onstat -g wst ) ? I have IDS 2000 V 9.20 on an Unixware 7.1 box . Thanks. Sorin Ifrim…
No data being collected in sysmaster:sysptprof
Duh, nevermind. TBLSPACE_STATS probably has to be on. "B. Dana" wrote: > select * from sysptprof returns all zeros for all tables! > Gimme a clue. > Thanks.…
Re: 7.31 performance problem
Yes I have. KT > Have you run update statistics? onstat -p shows a lot of sequential scans.…
RE: 7.31 performance problem
Yes! KT > did u run update statistics etc ???…
What tables the database access most frequently
In article <A9qX5.9417$7.348176@quark.idirect.com>, "LuckeLuke" <nguyenq@supernet.ca> wrote: > Hi, > I want to know in Informix , what tables the database access most > frequently, what indexes access less/most frequently. Does someone already > has the SQLs or script to che…
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…
Update statistics
This is a multi-part message in MIME format. ------=_NextPart_000_0034_01C05A1D.1A715400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I've read about this in the manuals, I've asked advise and looked at samples, but update statistics is still…
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…
stored procs and recompiling
Mike Talbot wrote: > The tables involved > are reindexed After this action You should 'update statistics for procedure <proc_name>'.…
When was update statistics run
Any one know how to determine when update statistics was last run for a particular table? thanks, Robert Walkup rdww@ti.com…
Insert performance is poor
Tony Flaherty wrote: > >TBLSPACE_STATS 1 > > This has a huge (allegedly 20-30%) processing overhead, it should be turned > of (0) unless you are trouble shooting a specific problem. > This is'nt quite right. TBLSPACE_STATS hardly affects performance (but allows you to retrieve…
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?…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: insert performance problem
Thanh schrieb: > > Dell PowerEdge, PIII 600Mhz CPU, 1 Ultra2 SCSI drive, 128MB RAM. > > > TBLSPACE_STATS 1 This should be 0 !! > DBSERVERNAME mensa # Name of default database server > DBSERVERALIASES # List of alternate dbservernames > NETTYPE …
Informix/Baan/AIX Performance
"Anderson, Andy" wrote: > > We are experiencing performance issues since upgrading to AIX 4.3.3 from > 4.3.2. The Informix database configuration has not changed and all the > latest patches/fixes have been applied to the OS. We are running on a > AIX4.3.3 / Informix7.31.UC3X1 / …
update statistics
We are interested in getting some solid answers regarding the execution of the "update statistics" command against our Informix databases. Here is some background on our operating environment: 1. We are running Informix V731UC5 to V731UC7. 2. We are running an application tha…
Update Statistic
Should upate statistics be run at any time, or is it better to run update statistics when no user or batch processes are accessing the database? Sent via Deja.com http://www.deja.com/ Before you buy.…
RE: TBLSPACE_STATS to turn off/on?
> -----Original Message----- > From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk] > Sent: Friday, September 15, 2000 4:32 PM > To: kagel@bloomberg.net > Cc: informix-list@iiug.org > Subject: TBLSPACE_STATS to turn off/on? > > > "Art S. Kagel" wrote: > > > > You will indee…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
Re: TBLSPACE_STATS to turn off/on?
"Art S. Kagel" wrote: > > You will indeed lose the onstat -g ppf output but the overhead associated > with TBLSPACE_STATS is not insignificant. I have NEVER had this parameter > set through the four versions that have supported it and have never had any > memory corruption or ot…
TBLSPACE_STATS to turn off/on?
Hi, I was following some of the previous msg threads on turning this parameter off (setting to 0) and approach my consultants on my implementation of Informix that is supporting SAP R/3. The reply was that this parameter has some overheads, but if it is not on, doing problem an…
Re:update statistics problem
Why after running 'update statistics high' performance of my application decrease dramatically? Anna Zygmunt…
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…
TBLSPACE_STATS
I have been reading about turning these off in sevral of the last postings, and finally turned them off. I have been having some problems with buffer waits (7-12 %). After turning off the parameter, my buffer waits have have dropped in half (3-6 %). The load on the system seem…
RE: performance with very active threads
Tam Comments below on onconfig. Is KAIO available on SCO Unixware? Your AIO maxlen look long to me. The problem looks to me in the application. The engine must wait for all threads to get out of critical sections before starting the checkpoint, but then there is the time tak…
performance with very active threads
During a checkpoint you only have 8 cleaners utilized to flush 63 LRU's. That's 4 passes. Make LRUS=64 and CLEANERS=64. That's one pass. Let the disk subsystem figure out any contention. They're pretty good at that:) Also increase CKPTINTVL to every 30 minutes. Why have a …
Update statistics?
Please, Someone can tell me where I can find the reference for this ? I'am using Informix Online 7.30 Thanks. Lele…
long checkpoint
First, please do not post MIME/HTTP, this is a text newsgroup. Thanks. See below for notes. "Namenek, James H." wrote: > > I have just recently migrated from IDS 7.31.FC4XE to IDS 2000 9.21.FC1 (Two days ago). The system has just lived through a 6+ minute checkpoint. There …
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.…
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: Changing from Informix to Oracle
From: Boscia <rwboscia@worldnet.att.net> > >onstat - >Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days >06:48:25 -- 901120 Kbytes > > >onstat -c >PHYSDBS logs # Location (dbspace) of physical log >PHYSFILE 10000 # Physical …
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…
Re: Load Performance problems
Hi ! QSTAT ? what does it do ? I didn't find it on my onconfig V7.30 and TBLSPACE_STATS 1 What is it for ? tablespace statistics ? where do they go ? so, better to 0 ? Regards, Manel Falcó > >>QSTATS 1 > >Do you really want this on? > >># Read Ahead Variables >>…
Found the CDR Parameters
I knew it would happen. As soon as I sent that last message I thought of where I hadn't looked and there it was. In the ADMINDOC_7.3 release note was a reference to CDR variables that said they were defined in the Enterprise Replication Guide. And sure enough there they were i…
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?…
Re: Performance Problem
From: chivaviro1379@my-deja.com > >I have the configuration below running on HP-UX B.11.00 U 9000/800.on >L100 class which is 64bit machine. >I have run update statistics but nothing significantly has improved. >Also my backup takes long. Checkpoints are as low as 8 seconds and I…
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: Performance Issues
What version are you running? when given onstat -p its good to know how long it has been since statistics were zeroed (or if they havent when the server came up) Comments embedded. >===== Original Message From yener@my-deja.com ===== >Hi, > >We are currently running informix on…
Re: Slowness
Leonids, Do you use OPTCOMPIND 0 for OLTP system? I have also read that OPTCOMPIND should be 0 for OLTP and 2 for DSS systems. But I haven't tried that yet. We use OPTCOMPIND 1. Thanks in advance for you reply, Vinod Bhansali >>From: Leonids.Voroncovs@dati.lv >>Reply-To: Leoni…
Re: Slowness
Leonids, Do you use OPTCOMPIND for OLTP system? I have also read that OPTCOMPIND should be 0 for OLTP and 2 for DSS systems. But I haven't tried that yet. We use OPTCOMPIND 1. Thanks in advance for you reply, Vinod Bhansali >From: Leonids.Voroncovs@dati.lv >Reply-To: Leonids.V…
Re: Slowness
Boscia wrote: > Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 8 days 14:54:51 > -- 491520 Kbytes How much memory You have? OS needs some memory too. > ROOTSIZE 1500000 # Size of root dbspace (Kbytes) You need such a big rootdbs really? Only 3 Mb …
ALARMPROGRAM
yes, the engine will still send the alarmprogram the documented messages. the two are unrelated... mdelerme@my-deja.com wrote: > Hi, > > Can the alarmprogram be used if LTAPEDEV is set to /dev/null? This is a > portion of my onconfig : > > Diagnostics > > MSGPATH /opt/i…
Re: Charging for Informix usage
You seem to be implying that individual users have their own databases. If that is the case, some sort of usage stats would be quite simple to determine. Make sure that TBLSPACE_STATS is set to 1 (the default) in your onconfig file(s). Then, on a periodic basis, retrieve databas…
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…
Wait Statistics
Dies ist eine mehrteilige Nachricht im MIME-Format. --------------D0A6CF4F56568525466558CB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, i have some difficulties in interpreting the output of the following SQL-statement: select reason[1,20], tr…
RE: Updated Informix Linux install/configuration FAQ?
Thanks, great help...the database is now up and running. However, I'm still stuck somewhere with regards to testing my driver. An ldd of my Informix driver shows: libpthread.so.0 => /lib/libpthread.so.0 (0x40057000) libivmfront.so => /opt/alex/casp/odbc/lib/libivmfront.so (0x4…
Re: TBLSPACE_STATS parameter
"Carlson@WHSmith" wrote: > mgimbert8769@my-deja.com wrote: > > > > Hello everybody! > > > > Somebody known TBLSPACE_STATS paremeter? > > what is this used for? > > > > Thanks. > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > this parameter allow OnLine to m…
TBLSPACE_STATS parameter
Hello everybody! Somebody known TBLSPACE_STATS paremeter? what is this used for? Thanks. Sent via Deja.com http://www.deja.com/ Before you buy.…
update statistics
Hi friends, 'Update statistics medium' is being executed from cron at 11.00 pm. It takes about 5 hours. DB size is 25 GB. Generally it executes successfully but sometimes it gives following errors : 211: Cannot read system catalog (sysprocauth) 144: ISAM error: key values locked…
update statistics
Hi friends, Update Statistics medium is executed from cron at night. Generally it runs succesfully but sometimes it gives following error : -647 Error evaluating math library function function-name. or sometimes it gives following error 211 : Cannot read system catalog (sysproc…
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…
Re: Need for Speed...
Here are my recommendations. However, you need to post the table schemas and SET EXPLAIN output for any queries that seem slow in case we can help there also. Meanwhile there are some tuning parameters you can adjust: "jmorales@nettaxi.com" wrote: > > Hi Gurus, > > First of…
wait statistics
when I issue the command onstat -g wst I get the response: wait statistics not enabled. also, when I query the sysmaster table syssesswts there are never any values. How does one enable wait statistics (and is this a recommended practice) thanks for any advice...…
RE: PUT cursor very very very slow ... but it works with no error ! WHY
Just a few ideas. Only #1 seems likely to address the problem you described, but the others suggestions would help rule out things that kind of tug at the mind as being an issue. 1. Looking at your B-Tree percentage from onstat -P it looks like you are running into a bug which …
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…
Re: Informix SE 7 slower than 5 ?
Steven Hauser wrote: > Did you run "update statistics" in the recommended way? I have tested both. The recommended way in Informix-SQL sintax guide and also have used a "macro-report" made by Obnoxio that generates different updates. UPDATE STATISTICS LOW DROP DISTRIBUTIONS; …
re-initialization of shared memory fails
Here's the restore log (bar_act.log) 2000-04-03 10:21:30 5146 5145 /opt/informix/bin/onbar_d -r -p rootdbs 2000-04-03 10:24:10 5146 5145 Successfully connected to Storage Manager. 2000-04-03 10:27:16 5146 5145 Begin cold level 0 restore rootdbs. 2000-04-03 10:27:33 5146 5…
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…
Update statistics from "generation program" question
Hi all.. Given the following table definition: create table acct_nbr_srch_keys ( t_acct_num char(10), fund_num char(3), acct_num char(13), doc_id integer not null , fldr_id integer not null ); create unique index acctnbr_s_keys_pk on acct_nbr_srch_keys …
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…
Problem with statistics
We have a problem with statistics on 2 tables. We run update statistics on a regular basis. (once every morning and once in the evening). We have a select on the 2 tables and in sqexplain.out we see that this select the optimiser uses a sequential scan instead of using the index…
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…
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…
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. …
Update Statistics
En plataforma Informix hago update statistics con HIGH y me fallan las querys lo cambio a MEDIUM y la query retoma los valores correctos Alguien sabe porue puede suceder esto gracias.…
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…
update statistics
Each night we run update statistics with the following sql statement: update systables set npused = nrows / (2020/(rowsize)+4) where npused < 0 and the result log file give us the following output: ============================ Mon Jan 24 22:30:03 EST 2000 0 row(s) updated. =…
update statistics
I am new to informix and need to know how to run update statistics on a per table basis from the command line. TIA dnk61@yahoo.com __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com…
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…
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 …
RE: IDS 7.30 CPU Usage
Comments follow. >===== Original Message From "Jay Turner" <tjay@edcpub.com> ===== >Back in November we upgraded both our OS and Informix engine. From AIX >3.2.5 to AIX 4.3.2 and SE 5.03 UC1 to IDS 7.30 UC5. We are still using the >same system (RISC 6000 59H 768 meg. memory) a…
Re: checkpoints taking as much as 25 secs
Try modifying your LRU's to something like 63. Make your page cleaners equal to your LRU's value. I find I get considerable performance from my server set this way. As well, checkpoints on high end machines running hundreds of users using ~10GIG+ databases range from 1 -2 secs. …
Updating statistics
Greetings. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited basis on our databases. I've been gun shy about using them across the boa…
Update Statistics
Greetings. I'm sorry if this is a repeat, but was unsure if my email got through. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited …
Update Statistics
Greetings. I'm sorry if this is a repeat, but was unsure if my email got through. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited …
Update Statistics
Greetings. I'm sorry if this is a repeat, but was unsure if my email got through. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited …
Update Statistics
Greetings. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited basis on our databases. I've been gun shy about using them across the boa…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Write cache help
Wayne Trieu <trieu@ti.L-3Com.com> wrote in message news:807t74$ufk$1@nnrp1.deja.com... > Hi all, Hi ! > Can some one please help me how to increase write cache, right > now my cache is about 73% it seem low. I've tried all source recommend I > see on this group, but did …
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…
Update statistics
Hi This is going to sound heretical, but here goes. I've recently changed the statistics collected in our 50GByte database, from basically: high on first column on each index medium on other indexed columns low on the table We now collect the stats recommended for our version …
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…
Update statistics
Is it advisable to run update statistics on a Standard Engine database? Thanks g.muirhead@freeuk.com…
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…
Re: HP IDS 7.3 Performance problems.
From: "Kimberly Dicken" <infosys@ecke.com> > >Our HP Guy(tm) seems to want to do nothing except a) throw RAM at the >problem, and/or b) throw disks at the problem. I'm not completely confident >that the problem is solely I/O as the new machine has more disks, and >better controll…
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…
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…
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…
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…
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.…
Re: Update statistics automatic ?
Pascale wrote: > Hi everybody, > > I will have more information about update statistics > > On a online informix database 7.23, does statistics updated automatically ?? No > > or must I have to "isql" update statistics ?? You must issue UPDATE STATISTICS explicitly. Note: if…
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…
Update Statistics
I am using INFORMIX-SQL Version 7.20.UD1 running on a Sun-ultra enterprise. The problem I am having is with the update statistics high whenever it is done on a table of the following configuration for example Table Number name char(30), number char(15) Table Account number int…
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…
Re: using sysmaster in 9.x
thanks for the info - I guess I should have been more specific on what versions - we are using 7.23.uc4 and 9.14. No 7.3 yet.... any other ideas? maria Carlson@WHSmith wrote: > With 7.3 there is a configuration variable called TBLSPACE_STATS. If it > is not set in $ON…
using sysmaster in 9.x
With 7.3 there is a configuration variable called TBLSPACE_STATS. If it is not set in $ONCONFIG (I use 1), then table stats will not be kept. I found that out when I upgraded from 7.2 to 7.3. John Carlson Informix DBA WHSmith USA Maria Wilson wrote: > > I am trying to use the…
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…
TBLSPACE_STAT / LBU_PRESERVE
Hi Users, I am working on Sun Solaris 2.51 / IDS 7.3. Have some queries for which have not found answers in Informix Answers Online : 1. TBLSPACE_STAT set to 1 in ONCONFIG .... what is its use. 2. We use continous backup , so do we need to set LBU_PRESERVE TO 1. How does this …
Complete database re-org
John... Don't forget UPDATE STATISTICS... ~tut…
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…
update statistics
i am running sql version 7.20.UD3 'update statistics' returns the following error: 689: Global variable (variable-name) declared inconsistently. this is the type of error i thought would only happen in 4GL code. i am at a loss as to what could cause it in an SQL stmt, run fr…
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…
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…
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…
Re: UPDATE STATISTICS questions
>1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? Yes the distributions are created only by UPDATE STATISITICS MEDIUM or HIGH. Update statistics MEDIUM creates distribution by obtaining the random sample of the rows in the table. Whereas Update statistics …
RE: UPDATE STATISTICS questions
-----Original Message----- From: Dick.Brieck@chase.com [mailto:Dick.Brieck@chase.com] Sent: Monday, April 19, 1999 3:35 PM To: informix-list@iiug.org Subject: UPDATE STATISTICS questions I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS ME…
UPDATE STATISTICS questions
I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? Thanks for…
UPDATE STATISTICS questions
I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? Thanks for…
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 …
Index statistics
Hi, how can I find out if an index is used? Is there a count in sysindexes or some where else that is incremented when a certain index of a table is used in a query plan? Thanks in advance Monika Rabold Bull GmbH Langen Robert Boschstr. 52 63225 Langen Tel: 06103/761-4225 Fax:…
Statement level statistics
Does any body know how to enable the statement level statistics colums in the sysmaster:syssqexplain view/syssdblock table?…
UPDATE STATISTICS
I am advised that I must NOT use update statistics on my live database. Apparently it *could* corrupt some tables. Is there any situation where update statistics can damage data? I believe that I am running SE 5.0. Cheers Robert Stuart…
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…
Re: TBLSPACE_STATS
In article <7cbnqg$qiv$1@nnrp1.dejanews.com>, Lyzander Marantal <zandy@my-dejanews.com> wrote: > Hi everyone! > > I came across this ONCONFIG parameter in our 7.24 onconfig.std file. > > TBLSPACE_STATS 1 > > I've searched c.d.i. and the informix website but can't seem to find >…
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…
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…
a slow query selection.
Have you ever tried an UPDATE STATISTICS FOR TABLE detail_table?…
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…
UPDATE STATISTICS
Hello again everyone/ Another quick question (I hope) I'm slightly confused about the UPDATE STATISTICS command. If I do an UPDATE STATISTICS HIGH FOR TABLE tablename (col1, col2) then do an UPDATE STATISTICS MEDIUM FOR TABLE tablename (col3) then do and UPDATE STATISTICS LOW fo…
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?…
9.14 Crashes on Update Statistics
Universal 9.14 on NT. Update statistics on tables is OK Update statistics (high or low) on procedures crashes the engine. I assume that I have the wrong setting somewhere, but where? Can anybody help? Thanks Bashar Chalabi CTL, London…
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).…
update statistics
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_000_01BE34C1.ECD08A98 Content-Type: text/plain Can I run 'update statistics' against a database while users are ac…
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.…
Update Statistics
Hi Admins, Is there any way I can automate update statistics for a given Informix envirnment? Regards Mike _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com…
Way to determine UPDATE STATISTICS
Hi All; Is there a method to determine the rule about update statistics ? For example, what kind of tables should be run "UPDATE STATISTICS HIGH" and others use "LOW". By the way, what is the "RESOLUTION" ? How it work ? Thanks Jung-Hui Cheng cheng@dbtel.com.tw…
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…
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…
Update statistics
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_000_01BE0F40.AD4FB200 Content-Type: text/plain Can you run an update statistics high on multiple columns so that you do not …
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
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.…
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…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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: 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…
Q: Update statistics
Howdy folks, What is the effect to the users if they are using the system while running update statistics is running ? What is, if any is the effect to my update statistics ?? TIA Suze…
Re: New ONCONFIG Parameters
In article <6shtdk$5am$1@news.xmission.com>, Dale Forrey <forrey@wsu.edu> wrote: > > We have Informix 7.30 UC3-1 installed and running on an RS6000 under AIX > 4.3. The new ONCONFIG.STD file contains several new parameters that are > not documented in the 7.3 Administrators Gu…
Found the CDR Parameters
I knew it would happen. As soon as I sent that last message I thought of where I hadn't looked and there it was. In the ADMINDOC_7.3 release note was a reference to CDR variables that said they were defined in the Enterprise Replication Guide. And sure enough there they were i…
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 …
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…
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…
update statistics
I am trying to run update statistics from cron. I keep getting database closed messages. But I can connect to the database and run update statistics interactively. do I have to submit a password when I connect to the database?…
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.…
queue statistics
Hi, The qst option of onstat says "queue statistics not enabled".How to enable Q statistics ? TIA Sathish…
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…
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…
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 …
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…
Update statistics high vs medium
Hi, we are running Informix ODS v7.23 on AIX 4.2. There is a table with 27000 records look like this: TABLE dot ( dot_serial_num char(11) not null PK, dot_title char(82), create_dt date indexed) We have several queries that join multiple tables including this DOT t…
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: +…
Update Statistics
A necessity but taking out a table is a pain Does anyone know of a tool that eases the pain. I'm trying to run 24 x 7 but... Thanks, Robert…
Update statistics question
Hi Everybody, I have been doing some investigation into update statistics and was wondering if any one has similar experiences. Environment DEC OSF 3.2g Informix v7.20uc1 table: columns 25 rowsize 168 rows 3000000 I did the following:…
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…
Re: count(*) <> "wc -l" of unload file
select count(*) will give you an accurate count of the number of records - regardless of statistics. You are thinking of: select nrows from systables where tabname = 'foo' which indeed is subject to recent statistics having been run. cheers j.…
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…
Re: Optimizing..
Know your schema, update statistics, and read sqexplain.out.…
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…
Update Statistics
All, I have been left a large script by the Informix DBA to run. It does an update statistics (low, medium and high) on all of the tables in the db. Is there any way I can monitor how this is doing as at the moment it is just sat in dbaccess and I can't tell how much progress i…
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…
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: 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…
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: DELETE does not use index
Sorry for my stupid question, but what does UPDATE STATISTICS do in detail? cu Reiner pharia@erols.com schrieb in Nachricht <881057475.21169@dejanews.com>... > >Try "update statistics on table table_1"…
Re: Running UPDATE STATISTICS on a table being used
In article <652nqa$3ho@cssun.mathcs.emory.edu>, sujata_soman_at_omm-la2-infotech-001@internet.omm.com says... > > >Hi. > It is me again with another question related to UPDATE STATISTICS. >Yesterday, I ran UPDATE STATISTICS high on 6 of my largest tables WHILE they >were being…
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…
Update statistics Questions
Subject: Update Statistics Confusion Date: 10/9/97 9:08 PM We are running On-Line v7.23. I ran some test evaluating update statistics using the following SQL and we got some very strange behavior. Why? select count(*) from x_forms x,prdct_END e w…
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…
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.…
UPDATE STATISTICS
Why doesn't the engine UPDATE STATISTICS automatically? Does anyone have any ideas regarding the logistics of running of UPDATE STATISTICS in a 24 hour environment? Thank you and please also reply via email.…
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…
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…
when to 'update statistics' ???
Hi all: if anyone knows when to do the 'update statistics' ? Or, if there is any information (some ratios, for example) indicates that the engine needs 'update statistics'?? leo…
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…
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…
UPDATE STATISTICS
1. Can someone tell me if the UPDATE STATISTICS command generates an output file for the DBA to read? 2. How often should you run this procedure? TIA, /Patrick TV Corp. Singapore…
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…
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…
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…
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…
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…
Re: DBSchema on informix 5.01
Have you ran UPDATE STATISTICS ? also run bcheck on all your tables...…
Update statistics
Thanks to all that offered help for the update statistics... Turned out to be a combination of problems. 1) The update statistics statement had to be prepared. 2) Update stats high was resulting in a tablespce overflow We now have stats for our database, and things are moving …
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
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…
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: 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: 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??…
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…
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?…
UPDATE STATISTICS.
> From: "shawn raymond" <shawn.raymond@CCGATEWAY.AMC.EDU> > Is it possible that UPDATE STATISTICS could slow down access to a > database? I ran it on our database this morning and after it was > finished things got real slow. We are running Online 5.03UC The…
Update statistics.
Hello all, Is it possible that UPDATE STATISTICS could slow down access to a database? I ran it on our database this morning and after it was finished things got real slow. We are running Online 5.03UC2. Any feedback would be appreciated. Thanks! …
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…
Re: statistics
carolr@sparky.nimh.nih.gov wrote: : I am interested in importing data from informix into a variety of statistic : packages (i.e. SAS, SPSS, SYSTAT, etc.). SPSS for Windows 6.x can access databases via ODBC, so you have direct access to your data without having to worry about dat…
Usage Statistics
Pholks, Can any one talk to me about this topic? How do you tell what data is used by who and how frequently? cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, US…
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…
Update Statistics
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Update Statistics %VERIFY y %DATE 26/03/93 18:35 %REFERENCE 16917 I have a question regarding the necessity of running 'update statistics' regularl…
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…
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 | | …
Update Statistics
Does anyone have a recommendation on how often the update statistics command should be run? Should it be run as an adminstrative routine, or started up at the beginning of each .4gi(.4go for some) Thanks in advance ===============================================================…