ADSM-L

Restoring an Informix Instance using ADSM

1998-02-09 05:16:59
Subject: Restoring an Informix Instance using ADSM
From: Paul Hill <ph AT ALT.DATEL-GROUP.CO DOT UK>
Date: Mon, 9 Feb 1998 10:16:59 -0000
SUBSCRIBE ADSM-L paul hill

Can anybody out there help me?

According to Informix this is an ADSM problem and according to IBM this
is an Informix problem.

I have backed up an Informix database using ADSM and everything look
fine as far as ADSM is concerned.

I have tried Informix versions 7.22.UC2 and 7.22.UC4 Dynmic server and
ADSM
version 2, Release 1, Level 5.13 server and API - Version 2, Release 1,
Level 0.6.
I have also tried ADSM version 3.1.10.1 client and version 3.1.0.1
server.

The Operating system is AIX 4.1.4.

When I try to restore this instance I get the following messages in the
log files:

*********** Informix Log file *********************

 1997-12-23 16:25:00 34818  19182 onbar -r -w
 1997-12-23 16:25:08 34818  19182 Successfully connected to Storage
Manager.
 1997-12-23 16:25:10 34818  19182 Begin salvage for log 1.
 1997-12-23 16:29:10 34818  19182 Completed salvage of logical log 1.
 1997-12-23 16:30:20 34818  19182 Successfully connected to Storage
Manager.
 1997-12-23 16:30:22 34818  19182 A system error occurred. Aborting XBSA
session.


********** Informix debug File ******************

 1997-12-23 16:30:16 34818  19182 BSAInit: enter
 1997-12-23 16:30:20 34818  19182 BSAInit: return 0 (0x0) and bsaHandle
0x00000001
 1997-12-23 16:30:20 34818  19182 barBsaInit: return 0 (0x0)
 1997-12-23 16:30:20 34818  19182 BSABeginTxn: enter with bsaHandle
0x00000001
 1997-12-23 16:30:20 34818  19182 BSABeginTxn: return 0 (0x0)
 1997-12-23 16:30:20 34818  19182 barBeginTxn: return 0 (0x0)
 1997-12-23 16:30:20 34818  19182 barGetObject: enter obj_name rootdbs
 1997-12-23 16:30:21 34818  19182 initObjDesc: enter
 1997-12-23 16:30:21 34818  19182 initObjDesc: space name /tst copy type
3 obj type 4 status 2
 1997-12-23 16:30:21 34818  19182 initObjDesc: return
 1997-12-23 16:30:21 34818  19182 barGetObject: object owner      name
copytype copyid                size      resource type status desc info
 1997-12-23 16:30:21 34818  19182 barGetObject:  INFORMIX informix /tst
/tst/rootdbs/0                 3 0          5131       0    0    R
4     1
 1997-12-23 16:30:21 34818  19182 BSAGetObject: enter
 1997-12-23 16:30:22 34818  19182 BSAGetObject: return 3 (0x3)
 1997-12-23 16:30:22 34818  19182 barGetObject: bufferLen = 61440,
numBytes = 0
 1997-12-23 16:30:22 34818  19182 do_xbsa_error: enter
 1997-12-23 16:30:22 34818  19182 do_xbsa_error: return 138 (0x8a)
 1997-12-23 16:30:22 34818  19182 barGetObject: return 3 (0x3)
 1997-12-23 16:30:22 34818  19182 barEndTxn: enter
 1997-12-23 16:30:22 34818  19182 BSAEndTxn: enter with bsaHandle
0x00000001 and vote 2
 1997-12-23 16:30:22 34818  19182 BSAEndTxn: return 0 (0x0)
 1997-12-23 16:30:22 34818  19182 bar_upd_sysutils: enter
 1997-12-23 16:30:52 34818  19182 bar_upd_sysutils: return 0
 1997-12-23 16:30:52 34818  19182 barEndTxn: return 0 (0x0)
 1997-12-23 16:30:52 34818  19182 barTerminate: enter
 1997-12-23 16:30:52 34818  19182 BSATerminate: enter with bsaHandle
0x00000001
 1997-12-23 16:30:52 34818  19182 BSATerminate: return 0 (0x0)
 1997-12-23 16:30:53 34818  19182 barTerminate: return 0 (0x0)
 1997-12-23 16:30:53 34818  19182 do_phys_restore: calling
bar_phys_close_restore(BU_ABORT, errtxt)
 1997-12-23 16:30:53 34818  19182 bar_phys_close_restore: enter
commit_flag 1
 1997-12-23 16:30:53 34818  19182 bar_phys_close_restore: return 0
 1997-12-23 16:30:53 34818  19182 do_phys_restore: return 3
 1997-12-23 16:30:58 34818  19182 return from bar_exec 3
 1997-12-23 16:30:58 34818  19182 bar_main: exiting with 3 (0x3)
 1997-12-23 16:30:58 34818  19182 bar_cleanup: enter
 1997-12-23 16:30:58 34818  19182 bar_api_disconnect: enter

************ ADSM client trace ***************

DumpPS --------------  Active Policy Set Dump  --------------
        Domain Name: STANDARD
       Act. PS Name: STANDARD
     Act. date/time: 12/22/1997 12:26:53
    Default MC Name: STANDARD
    Def MC num. tag: 1
        GPMC number: 2
GPMC Back Retention: 30
GPMC Arch Retention: 365
      Number of MCs: 1
    Longest MC name: 8
    Has a backup CG: True
  Has an archive CG: True
################## MANAGEMENT CLASS ################
                            Name: STANDARD
                          Number: 15
                     Description: 'Installed default management class.'
      Space Management Technique: None
       Auto Migrate on Non-Usage: 0
Backup Required Before Migration: Yes
  Destination for Migrated Files: SPACEMGPOOL
    ---- BACKUP Copy Group ----
                 Name: STANDARD
               Number: 1
            Frequency: 0
      Ver Data Exists: 10000
     Ver Data Deleted: 10000
    Retain Extra Vers: 30
     Retain Only Vers: 60
          Copy Serial: Shared Static
            Copy Mode: Modified
          Destination: DATEL
    ---- ARCHIVE Copy Group ----
                Name: STANDARD
              Number: 1
           Frequency: 10000
         Retain Vers: 365
         Copy Serial: Shared Static
           Copy Mode: Absolute
         Destination: ARCHIVEPOOL
12/23/1997 16:30:20 .0762 [034818] : ../../src/ansnls.c(1906): Adding
message: 10303 to the cache.
psqSendQuery: Using 'STANDARD' as the directory MC
12/23/1997 16:30:20 .0762 [034818] : ../xopen/xopnsess.c( 276): BSAInit
original bsaOwner=INFORMIX, appOwner=informix, token=.
12/23/1997 16:30:20 .0763 [034818] : ../xopen/xopnsess.c( 358): BSAInit
for node=INFORMIX, owner=informix.
12/23/1997 16:30:20 .0763 [034818] : ../common/dsmsess.c( 266):
dsmQuerySessInfo: completed
12/23/1997 16:30:20 .0764 [034818] : ../xopen/xopnsess.c( 380): Actual
node=INFORMIX, actual owner=informix.
12/23/1997 16:30:20 .0899 [034818] : ../xopen/xopntxn.c(  74): Call to
BSABeginTxn
12/23/1997 16:30:21 .0200 [034818] : ../xopen/xopnget.c( 105): Call to
BSAGetObject
12/23/1997 16:30:21 .0200 [034818] : ../xopen/xopnget.c( 111): Warning:
BSAGetObject objectDesc.version unexpected 0.
12/23/1997 16:30:21 .0216 [034818] : ../common/dsmget.c( 475):
dsmBeginGetData: getType = Backup
12/23/1997 16:30:21 .0357 [034818] : ../common/dsmget.c( 715):
dsmGetObj: ObjId = 0-5131
12/23/1997 16:30:22 .0357 [034818] : ../../src/ansnls.c(1906): Adding
message: 10765 to the cache.
  Length:    12 Code: 00000050 Type:    <-       BeginObjData
12/23/1997 16:30:22 .0369 [034818] : ../../src/ansnls.c(1865): Found
message: 10598 in cache.
TcpRead: data:00000000 0000140B 01
12/23/1997 16:30:22 .0373 [034818] : ../../src/ansnls.c(1865): Found
message: 10765 in cache.
  Length:    13 Code: 00000051 Type:    <-         EndObjData
12/23/1997 16:30:22 .0374 [034818] : ../common/dsmget.c(1417): Server
aborted sub-transaction. Reason code: 1
12/23/1997 16:30:22 .0374 [034818] : ../common/dsmget.c( 761):
dsmGetObj: DataBlk.numBytes = 0.
12/23/1997 16:30:22 .0375 [034818] : ../xopen/xopnget.c( 188): Call to
dsmGetObj error rc = 1
12/23/1997 16:30:22 .0375 [034818] : ../common/dsmget.c( 926):
dsmEndGetObj:
12/23/1997 16:30:22 .0376 [034818] : ../common/apianchr.c( 518):
anRunStateMachine: Bad sequence call, event = 9, state = 2.
12/23/1997 16:30:22 .0377 [034818] : ../common/dsmget.c( 606):
dsmEndGetData:
12/23/1997 16:30:22 .0379 [034818] : ../../src/ansnls.c(1906): Adding
message: 10145 to the cache.
cuFlushServerStream: Flushing out residual verbs from input stream

12/23/1997 16:30:22 .0394 [034818] : ../../src/ansnls.c(1865): Found
message: 10765 in cache.
  Length:     6 Code: 00000013 Type:    <-             EndTxn
12/23/1997 16:30:22 .0395 [034818] : ../xopen/xopnutil.c( 234): dsm rc
(1) , BSA rc (3)
12/23/1997 16:30:22 .0667 [034818] : ../xopen/xopntxn.c( 107): Call to
BSAEndTxn
12/23/1997 16:30:52 .0914 [034818] : ../xopen/xopnsess.c( 422): Call to
BSATerminate

**********************************

If you have actually got this far thanks and
I hope you can help.

Paul
<Prev in Thread] Current Thread [Next in Thread>
  • Restoring an Informix Instance using ADSM, Paul Hill <=