Search results for query: *

If I remember correctly, sp_who2, is just like sp_who from MS-SQL right? Well, if so, issuing the < onstat -g ses > Informix command, will get you the same info from sp_who2: The system process ID. The status of the process (e.g., RUNNABLE, SLEEPING). Login name of the user. Machine name of the...

Hi there, I'm a Informix DBA, and I'm having some problems with the Tuxedo app. As you all may guess, I don't have a gadman clue of what is happening, here's the message on the log: 132719.sw8!PSAPISRV.32924: LIBTUX_CAT:250: ERROR: tpsvrinit() failed 133022.sw8!WSH.34152: WSNAT_CAT:1139: ERROR...

Hi there everybody, we are upgrading from IDS 7.31.ud2 to 7.31.ud6, and after the importing procedures, we are experiencing problems with some SPL's, follows the ISAM error below: -640 QPlan sanity failure line-number. Running UPDATE STATISTICS might fix this internal error. If the error...

Hi everybody, I'm having problems to get the schema from a SPL. I've raised the limits from user Informix to 0 (unlimited), but I still can't get it. Does anyone has experienced this before? This is a major SPL, with thounsands of code lines. Anything would help. Thanks. FFO &quot;The only way...

Hi there, you need to ensure what media way are you using to backup your logs. If you're using a Storage Manager, such as TSM or EMC, you should configure your BAR* onconfig variables to do so. If not, if you're using a tape device, you should disable the ALARMPROGRAM onconfig variable lie this...

Hi guys, technical support discovered a bug on: Informix Dynamic Server Version 7.30.TC9 We have been tremendously adviced to move to 7.31.TD2. Thanks anyway. FFO &quot;The only way of knowing is to understand&quot;

The problem is that probably you have tried to bring the engine up too many times, and so has locked some shared memory segments on your OS. Try this: ipcs -m|grep informix See if there is any memory segments there, if so, try this: ipcrm -m <shmid> where <shmid> is the number on the second...

Hi everybody, recently I had one of my engines bounced for an exception caught in one of my userthreads. Unfortunately, this happened again today and I have to explain the causes for the bouncing. Here is the Assert Failure generated: 19:27:12 Assert Failed: No Exception Handler 19:27:12...

WiccaChic, here are the steps to create the raw devices: -use <smitty lv> to enter smitty, under the Logical Volumes section; -choose the Add a Logical Volume option; -choose the Volume Group using ESC-4; -choose a Logical Volume Name, that's the name of you raw device; -choose the Number o...

Hi there mynwo, the type of connection you are using and the number of users connected simultaniously don't affect the size of the rootdbs dbspace, although, some tables of the catalog increase with the number of users, such as sysprivs and others. One thing that you should is to remove the...

Hi there, my customer is asking me about the time consuming, the space consuming and the lock time used to create an index. I can't use oncheck, as it locks the table permanently. I tried to use some SQL-scripts, but nothing shows me exactly this kind of information. Anything would help me...

Also, to connect do Informix Datase use these tools: DBACCESS - powerfull tool for Unix connection, administration ONMONITOR - usefull for monitoring options Best Regards, FFO &quot;The only way of knowing is to understand&quot;

Hi there, here are some interesting sites that you can use: http://www.iiug.org/ (Informix Inernational Users Group) http://www-306.ibm.com/software/data/informix/pubs/library/ (IBM-Informix Library Page) www.ibm.com/informix (Oficial IBM-Informix Product Family Web Site)...

In fact, there is not an oficial formula to find out the best SHMTOTAL suitable value. But you can use this to make your own formula: These are the ONCONFIG parameters which afects the shared memory size: LOCKS + BUFFERS + SHMVIRTSIZE + SHMADD + NETTYPE Running *** onstat -g seg ***, you...

The only way to do that is using the archecker. You can find somethin on this link: http://www.prstech.com/src/archecker.sh.shtml Or you can learn more bout the Archecker on the IBM manual: http://www.syncframe.de/download/IBM_Backup_Guide.pdf See chapter 5. Best Regards ids2000