https://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0The latest updates about Informix Dynamic Server (IDS)en-USCopyright 2007 IBM Corporation. All rights reservedcssadmin@us.ibm.com (CSN Administrator)Tue, 01 Dec 2009 00:00:00 GMTSun, 06 Dec 2009 04:58:53 GMThttp://www.ibm.com/i/ibm_logo_120x60.gifhttps://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0http://www.ibm.com/support/docview.wss?uid=swg1IC64294&myns=swgimgmt&mynp=OCSSGU8G&mync=RAn Informix / TSM standard backup configuration will lead to following error messages within the online log afterProblem solving informationswgimgmt.swg1IC64294Tue, 01 Dec 2009 00:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg1IC64924&myns=swgimgmt&mynp=OCSSGU8G&mync=RWhen using the instance manager, the instance manager window disappears but the instmgr.exe process is using most of one cpu.Problem solving informationswgimgmt.swg1IC64924Tue, 01 Dec 2009 00:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg1IC64808&myns=swgimgmt&mynp=OCSSGU8G&mync=RThe assertion failure stack will look like this:Problem solving informationswgimgmt.swg1IC64808Tue, 01 Dec 2009 00:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg1IC64691&myns=swgimgmt&mynp=OCSSGU8G&mync=RIn versions 11.50.FC5, 11.50UC5 and 11.50.UC5W4 with HP-UX and RH Linux, when you create an sbspace withProblem solving informationswgimgmt.swg1IC64691Tue, 01 Dec 2009 00:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21395852&myns=swgimgmt&mynp=OCSSGU8G&mync=RWhen attempting to insert rows into a table, the following error is returned to the client: ISAM error 136 : no more extentsProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21395852Tue, 24 Nov 2009 16:27:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21330735&myns=swgimgmt&mynp=OCSSGU8G&mync=RToo many extents in a table can cause problems: 1. Can impact the performance of accessing the table, engine can not access the data effectively as they are stored discontinuously. 2. Can reach the storage limitation of the table, more data can not be inserted into the table again. So 1. Need to reorganize a table with many extents and reclaim the space. 2. Decide to delete most rows from a huge table 3. Decide to change the structure of a huge tableProblem solving informationTechnotes(FAQs)swgimgmt.swg21330735Thu, 12 Nov 2009 16:46:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21409734&myns=swgimgmt&mynp=OCSSGU8G&mync=RInformix engine couldn't allocate any more virtual shared memory throwing out "Out of virtual shared memory, cannot grow exception stack shmat: [EMFILE][24]: out of shared memory segments, check system SHMSEG" error messages, and the engine hangs.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409734Thu, 12 Nov 2009 16:34:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21408901&myns=swgimgmt&mynp=OCSSGU8G&mync=RWhy Logical Logs will not dynamically allocateProblem solving informationTechnotes(FAQs)swgimgmt.swg21408901Tue, 10 Nov 2009 12:01:51 GMThttp://www.ibm.com/support/docview.wss?uid=swg21409322&myns=swgimgmt&mynp=OCSSGU8G&mync=RIf you do not take a physical backup (backing up dbspaces, sbspaces, and so on) then backing up logical logs is not useful. Those logical logs cannot be used for any type of recovery unless you have at least one physical backup ( Onbar Level 0, Ontape Level 0, external backup ). You do need the logical logs to be marked as backed up or the server will become blocked.Problem solving informationTechnotes(FAQs)swgimgmt.swg21409322Thu, 05 Nov 2009 08:44:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21403150&myns=swgimgmt&mynp=OCSSGU8G&mync=RWhat information should be collected when you experience a problem with your software? Collecting data for any Datablade Problem. Collecting this information before calling IBM support will help you understand the problem and save time analyzing the data.Problem solving informationTechnotes(FAQs)swgimgmt.swg21403150Wed, 04 Nov 2009 13:05:19 GMThttp://www.ibm.com/support/docview.wss?uid=swg21408421&myns=swgimgmt&mynp=OCSSGU8G&mync=RHow to tell which users have DBA privileges on databaseProblem solving informationTechnotes(FAQs)swgimgmt.swg21408421Wed, 04 Nov 2009 11:44:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27016679&myns=swgimgmt&mynp=OCSSGU8G&mync=RInformix Dynamic Server provides periodic fixes for release 11.50. The following list is the most recent report of fixes for customer-reported defects in Version 11.50.xC5W4. This report combines both Windows- and UNIX-specific defect fixes, and is more current than the defect information included in the product release.Product documentationProduct information and publicationsswgimgmt.swg27016679Tue, 03 Nov 2009 13:34:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21407705&myns=swgimgmt&mynp=OCSSGU8G&mync=RYou are reviewing your online.log and notice several: Loading Module <SPLNULL> Unloading Module <SPLNULL>Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21407705Tue, 27 Oct 2009 15:26:10 GMThttp://www.ibm.com/support/docview.wss?uid=swg21408223&myns=swgimgmt&mynp=OCSSGU8G&mync=RYou are installing IDS. You noticed that there are several Java errors. You run the following command: java -version JVMJ9VM011W Unable to load j9jit23: /home/informix/IDS_JRE/bin/libj9jit23.so: cannot restore segment prot after reloc: Permission denied JVMJ9VM011W Unable to load jclscar_23: /home/informix/IDS_JREProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21408223Tue, 27 Oct 2009 13:29:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21406781&myns=swgimgmt&mynp=OCSSGU8G&mync=RProgress Indicator for Sync and CheckProblem solving informationTechnotes(FAQs)swgimgmt.swg21406781Wed, 21 Oct 2009 12:50:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21406502&myns=swgimgmt&mynp=OCSSGU8G&mync=RUpgrading IDS 11.50 to version 11.50.xC5W2 may terminate the server or corrupt data if transactions are not completed before the upgrade.Flashesswgimgmt.swg21406502Mon, 12 Oct 2009 12:39:38 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405610&myns=swgimgmt&mynp=OCSSGU8G&mync=RWhen IDS is setup to use an LDAP user via PAM, it fails to connect, even though I'm able to able to connect as a user defined in the operating system via /etc/passwd file.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21405610Mon, 12 Oct 2009 11:23:06 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405779&myns=swgimgmt&mynp=OCSSGU8G&mync=RHow do I setup IDS to use PAMProblem solving informationTechnotes(FAQs)swgimgmt.swg21405779Mon, 12 Oct 2009 11:15:32 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405608&myns=swgimgmt&mynp=OCSSGU8G&mync=RImported restore fails during logical recovery phase with the message in log: 2009-09-11 16:47:09 18216 17544 /usr/informix/bin/onbar_d -r -l 2009-09-11 16:47:09 18216 17544 WARNING: Skipped backup/restore of space 'rootdbs'. 2009-09-11 16:47:10 18216 17544 ERROR: Unable to start the logicalrestore: rootdbs which is the ROOT DBspace is being restored and infxlog has not been physically restored. If the ROOT DBspace or a DBspace containing the physical log or a logical log filProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21405608Mon, 12 Oct 2009 09:57:54 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405613&myns=swgimgmt&mynp=OCSSGU8G&mync=RSetting up Single Sign On With Informix Dynamic Server Using Windows AdProblem solving informationTechnotes(FAQs)swgimgmt.swg21405613Mon, 12 Oct 2009 09:48:20 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405653&myns=swgimgmt&mynp=OCSSGU8G&mync=RThis document contains step-by-step instructions to setup Single Sign-on for IDS using a Unix KDC.Problem solving informationTechnotes(FAQs)swgimgmt.swg21405653Mon, 12 Oct 2009 09:45:05 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405778&myns=swgimgmt&mynp=OCSSGU8G&mync=RHow to configure IDS and Informix clients for Kerberos/SSOProblem solving informationTechnotes(FAQs)swgimgmt.swg21405778Mon, 12 Oct 2009 09:41:54 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405924&myns=swgimgmt&mynp=OCSSGU8G&mync=RThe IDS 11.50 Information Center is now a Collaboration Center!Flashesswgimgmt.swg21405924Mon, 05 Oct 2009 20:28:17 GMThttp://www.ibm.com/support/docview.wss?uid=swg21404334&myns=swgimgmt&mynp=OCSSGU8G&mync=RLogical logs can fill on an IDS instance and this document will describe what actions to take and what information should be collected.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21404334Wed, 30 Sep 2009 22:20:40 GMThttp://www.ibm.com/support/docview.wss?uid=swg21405112&myns=swgimgmt&mynp=OCSSGU8G&mync=RYou are setting up an HDR pair but see this error in the online.log: DR: The configuration parameter LTAPEDEV on the paired servers must be both set to a NULL device or both set to non-NULL (could be different) devices.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21405112Wed, 30 Sep 2009 22:00:00 GMThttp://www.ibm.com/legal/us/Terms of UseTerms and conditionshttp://www.ibm.com/legal/us/