Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. testhandle

    ISAM error

    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
  2. testhandle

    Resetting the value for the serial data type

    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.
  3. testhandle

    Resetting the value for the serial data type

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

    Resetting the value for the serial data type

    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
  5. testhandle

    Windows XP Pro & Windows 2000 Pro

    Thanks for the reply.
  6. testhandle

    Windows XP Pro & Windows 2000 Pro

    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...
  7. testhandle

    Migration issue from 5.10.UC2 to 7.31

    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...
  8. testhandle

    Urgent - startup error

    Any solution to bring the DB on line. Thanks
  9. testhandle

    On-line 5.10 restore and recovery

    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...
  10. testhandle

    Urgent - startup error

    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...
  11. testhandle

    Defragmenting Systables

    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
  12. testhandle

    TBCONFIG parameters

    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...
  13. testhandle

    956: Client is not in /etc/hosts.equiv on the remote host.

    Any solution please?
  14. testhandle

    TBCONFIG parameters

    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...
  15. testhandle

    Cannot read system catalog(sysprocplan)

    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...
  16. testhandle

    Cannot read system catalog(sysprocplan)

    Hi, Received the following message. 20211 - Cannot read system catalog(sysprocplan).ISAM error:key value locked. Any idea hot to resolve this please. Thanks
  17. testhandle

    Cannot read system catalog(sysprocplan)

    Hi, Received the following message. 20211 - Cannot read system catalog(sysprocplan).ISAM error:key value locked. Any idea hot to resolve this please. Thanks
  18. testhandle

    Informix instance startup error

    Shriyan, I tried setting the permissions & privileges for the LV /dev/vguv/test_informix without creating the link which worked fine. Thanks for your help. Thanks John Jayaseelan
  19. testhandle

    Informix instance startup error

    How can you set a user:group to LV?
  20. testhandle

    Informix instance startup error

    Hi, Following are settings for the raw LV. # lvdisplay /dev/vguv/test_informix --- Logical volumes --- LV Name /dev/vguv/test_informix VG Name /dev/vguv LV Permission read/write LV Status available/syncd Mirror copies...

Part and Inventory Search

Back
Top