Level-0 restore and sysmaster problem

I'm building a cloned HPUX 11 & IDS 7.2 machine. I can initialize the database and bring it online with no problems. When I restore from a level-0 archive (using ontape) there is a problem converting the sysmaster database. Everything is fine in quiesent mode, but switching to online mode produces the following log entries: 16:00:38 Quiescent Mode 16:00:38 Checkpoint Completed: duration was 0 seconds. 16:00:46 On-Line Mode 16:00:46 Converting 'sysmaster' database ... 16:00:48 Assert Failed: pthdrpage:ptaltstat2:bad alter slot 16:00:48 Who: Session(15, informix@l2000, 2183, -1045546988) Thread(38, sqlexec, c1ac2da0, 1) 16:00:48 Results: Cannot use TBLSpace page for TBLSpace 1049336 16:00:48 Action: Run 'oncheck -pt 1049336' 16:00:48 See Also: /tmp/af.26139f 16:00:48 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 4 1 "Table failure: 'sysmaster:"informix".arc_file_copy'." "pthdrpage:ptal 16:00:48 Message 19261 not found. 16:00:48 See '/tmp/buildsmi.2153'. 16:00:49 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 3 6 "Internal Subsystem failure: 'SMI'" "Message 19261 not found. " Running oncheck -pt 1049336 returns: $ oncheck -pt 1049336TBLspace Report for sysmaster:informix.arc_file Error opening TBLspace arc_file_copy. And the /tmp/buildsmi.2153 file reads: Database selected. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 242: Could not open database table (informix.arc_file_copy). 172: ISAM error: Unexpected internal error Error in line 1Near character position 76 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 1 row(s) unloaded. Data committed. Database closed. The unload of sysmaster prior to upgrade failed Thinking it was a corrupt archive, I've tried several more with the same results. I'm on a tight deadline and have been hungup at this point for 2 days now trying to solve it. HELP!

You should rebuilt the sysmaster db, but you will loose the info from your backup history. To recreate the sysmaster su - informix $INFORMIXDIR/etc/buildsmi Regards Diane Lavoie -----Original Message----- From: DAN DEHAAN [mailto:ddehaan@skywest.com] Sent: Friday, December 17, 2004 10:29 AM To: ids@iiug.org Subject: Level-0 restore and sysmaster problem [3888] I'm building a cloned HPUX 11 & IDS 7.2 machine. I can initialize the database and bring it online with no problems. When I restore from a level-0 archive (using ontape) there is a problem converting the sysmaster database. Everything is fine in quiesent mode, but switching to online mode produces the following log entries: 16:00:38 Quiescent Mode 16:00:38 Checkpoint Completed: duration was 0 seconds. 16:00:46 On-Line Mode 16:00:46 Converting 'sysmaster' database ... 16:00:48 Assert Failed: pthdrpage:ptaltstat2:bad alter slot 16:00:48 Who: Session(15, informix@l2000, 2183, -1045546988) Thread(38, sqlexec, c1ac2da0, 1) 16:00:48 Results: Cannot use TBLSpace page for TBLSpace 1049336 16:00:48 Action: Run 'oncheck -pt 1049336' 16:00:48 See Also: /tmp/af.26139f 16:00:48 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 4 1 "Table failure: 'sysmaster:"informix".arc_file_copy'." "pthdrpage:ptal 16:00:48 Message 19261 not found. 16:00:48 See '/tmp/buildsmi.2153'. 16:00:49 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 3 6 "Internal Subsystem failure: 'SMI'" "Message 19261 not found. " Running oncheck -pt 1049336 returns: $ oncheck -pt 1049336TBLspace Report for sysmaster:informix.arc_file Error opening TBLspace arc_file_copy. And the /tmp/buildsmi.2153 file reads: Database selected. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 242: Could not open database table (informix.arc_file_copy). 172: ISAM error: Unexpected internal error Error in line 1Near character position 76 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 1 row(s) unloaded. Data committed. Database closed. The unload of sysmaster prior to upgrade failed Thinking it was a corrupt archive, I've tried several more with the same results. I'm on a tight deadline and have been hungup at this point for 2 days now trying to solve it. HELP!

Dan, did you test archecker tool from iiug.org? I never used it, but too many people recommends it.. Bye Paola Quoting DAN DEHAAN <ddehaan@skywest.com>: > I'm building a cloned HPUX 11 & IDS 7.2 machine. I can initialize the > database and bring it online with no problems. When I restore from a level-0 > archive (using ontape) there is a problem converting the sysmaster database. > Everything is fine in quiesent mode, but switching to online mode produces > the following log entries: > > 16:00:38 Quiescent Mode > 16:00:38 Checkpoint Completed: duration was 0 seconds. > 16:00:46 On-Line Mode > 16:00:46 Converting 'sysmaster' database ... > 16:00:48 Assert Failed: pthdrpage:ptaltstat2:bad alter slot > 16:00:48 Who: Session(15, informix@l2000, 2183, -1045546988) > Thread(38, sqlexec, c1ac2da0, 1) > 16:00:48 Results: Cannot use TBLSpace page for TBLSpace 1049336 > 16:00:48 Action: Run 'oncheck -pt 1049336' > 16:00:48 See Also: /tmp/af.26139f > 16:00:48 Process exited with return code 127: /bin/sh /bin/sh -c > /usr/local/bin/online-alarm 4 1 "Table failure: > 'sysmaster:"informix".arc_file_copy'." "pthdrpage:ptal > 16:00:48 Message 19261 not found. > 16:00:48 See '/tmp/buildsmi.2153'. > 16:00:49 Process exited with return code 127: /bin/sh /bin/sh -c > /usr/local/bin/online-alarm 3 6 "Internal Subsystem failure: 'SMI'" "Message > 19261 not found. " > > > Running oncheck -pt 1049336 returns: > > $ oncheck -pt 1049336> TBLspace Report for sysmaster:informix.arc_file > Error opening TBLspace arc_file_copy. > > > And the /tmp/buildsmi.2153 file reads: > > Database selected. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 242: Could not open database table (informix.arc_file_copy). > 172: ISAM error: Unexpected internal error > Error in line 1> Near character position 76 > 0 row(s) unloaded. > 0 row(s) unloaded. > 0 row(s) unloaded. > 1 row(s) unloaded. > Data committed. > Database closed. > The unload of sysmaster prior to upgrade failed > > > Thinking it was a corrupt archive, I've tried several more with the same > results. I'm on a tight deadline and have been hungup at this point for 2 > days now trying to solve it. HELP! > > > >

I found the problem - an old version tape in the new version case. I've now installed the correct IDS and everything works. Thanks for taking time to help though. -----Original Message----- From: Lavoie, Diane [mailto:diane.lavoie@domtar.com] Sent: Friday, December 17, 2004 10:14 AM To: Dan Dehaan; ids@iiug.org Subject: RE: Level-0 restore and sysmaster problem [3888] You should rebuilt the sysmaster db, but you will loose the info from your backup history. To recreate the sysmaster su - informix $INFORMIXDIR/etc/buildsmi Regards Diane Lavoie -----Original Message----- From: DAN DEHAAN [mailto:ddehaan@skywest.com] Sent: Friday, December 17, 2004 10:29 AM To: ids@iiug.org Subject: Level-0 restore and sysmaster problem [3888] I'm building a cloned HPUX 11 & IDS 7.2 machine. I can initialize the database and bring it online with no problems. When I restore from a level-0 archive (using ontape) there is a problem converting the sysmaster database. Everything is fine in quiesent mode, but switching to online mode produces the following log entries: 16:00:38 Quiescent Mode 16:00:38 Checkpoint Completed: duration was 0 seconds. 16:00:46 On-Line Mode 16:00:46 Converting 'sysmaster' database ... 16:00:48 Assert Failed: pthdrpage:ptaltstat2:bad alter slot 16:00:48 Who: Session(15, informix@l2000, 2183, -1045546988) Thread(38, sqlexec, c1ac2da0, 1) 16:00:48 Results: Cannot use TBLSpace page for TBLSpace 1049336 16:00:48 Action: Run 'oncheck -pt 1049336' 16:00:48 See Also: /tmp/af.26139f 16:00:48 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 4 1 "Table failure: 'sysmaster:"informix".arc_file_copy'." "pthdrpage:ptal 16:00:48 Message 19261 not found. 16:00:48 See '/tmp/buildsmi.2153'. 16:00:49 Process exited with return code 127: /bin/sh /bin/sh -c /usr/local/bin/online-alarm 3 6 "Internal Subsystem failure: 'SMI'" "Message 19261 not found. " Running oncheck -pt 1049336 returns: $ oncheck -pt 1049336TBLspace Report for sysmaster:informix.arc_file Error opening TBLspace arc_file_copy. And the /tmp/buildsmi.2153 file reads: Database selected. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 242: Could not open database table (informix.arc_file_copy). 172: ISAM error: Unexpected internal error Error in line 1Near character position 76 0 row(s) unloaded. 0 row(s) unloaded. 0 row(s) unloaded. 1 row(s) unloaded. Data committed. Database closed. The unload of sysmaster prior to upgrade failed Thinking it was a corrupt archive, I've tried several more with the same results. I'm on a tight deadline and have been hungup at this point for 2 days now trying to solve it. HELP!