Recent content by testhandle

Hi, Received the following error during 'tbcheck -cc'. ISAM error: no record found. WARNING:No systabauth record for TBLSpace informix.mar_mem_activity. Please tell the severity of the error and how this can be overcome. Thanks

The table is created using 'SERIAL', how the value of serial will be reset after reaching the max. Does that happen or needs to be reset.

Is there any other way to implement this (For example in the create table syntax itself).

Hi, Informix online 5.0 serial data type has a limitation of max value 2,147,483,647. Is there any way to reset the value to 1 after reaching the max? Thanks John Jayaseelan

Thanks for the reply.

Good afternoon, Could anyone please confirm which of these (Windows XP Pro & Windows 2000 Pro) installation would be preferable in a network environment of approx. 300 desktops having approx. 3 servers used as PDC/BDC/Print server. Could you please also list the pros & cons of the...

Hi, Migrating the 5.10.UC2 database to 7.31. During the oninit -v received the following messages on the screen. _____________ Checking group membership to determine server run modesucceeded Reading configuration file '/home/informix/dump/informix731/etc/onconfig.prod01d Creating...

Any solution to bring the DB on line. Thanks

Hi, Tried to restore the level 0 taken the previous night after replacing the broken disk and restoring Logical volume details for the chunks on the disk. During the restore (tbtape -r), ‘n’ was given for 'backup of logical logs', after level0 was restored the following messages are displayed...

Hi, After the disk failure restored the recent level0. Received the following. Any help please, it is production system. 16:28:55 Rollforward of log record failed, iserrno = 105 16:28:55 Log Record: log = 11271, pos = 12f353c, type = 29, trans = 98 16:28:55 slotdelete: bad rowid = 7e314...

Hi, The informix version is online 5.10. This instance does not have any sysmaster database. All the system tables are present in rootdbs. Thanks

Shriyan, Thanks a lot for your info. When I tried tbstat -g seg, without any result but the usage options. Could you please confirm the syntax. There are multiple informix instance runing on the same server, some times during the informix startup will give an error ' Could not allocate shared...

Any solution please?

Hi, Please tell the implications/purpose of the following parameters and what is the maximum value can be set. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) USERS 45 # Maximum number of concurrent user processes TRANSACTIONS 45...

Hi Shriyan, Thanks for your reply. This error appeared when the users try using the application. When checked for locks for table locks, found one user had many locks on the sysprocplan table. How the particular user could have locked the sysprocplan table. Is there any max access to the...