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!

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

Level-0 restore and sysmaster problem

Status
Not open for further replies.

AttilaDan

Programmer
Dec 15, 2004
5
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top