ADSM-L

Re: ADSM and Informix

1999-05-18 12:54:46
Subject: Re: ADSM and Informix
From: DAVID HENDRIX <dmhendri AT FEDEX DOT COM>
Date: Tue, 18 May 1999 10:54:46 -0600
We saw this same error on HP-UX using 3.1.0.1 or 3.1.0.3.

When we upgrade to 3.1.0.6 the error went away.

We truss'ed the onbar process and it consistently died at the BSAQueryObject
call.  Ironically, if you look at it, you'll see it register the object, send
the data, close the transaction and then query ADSM to see if it is there, and
it croaks.  No rhyme or reason.  Try 3.1.0.6.

Another possibility is checking the alarm program.  Your trace is having a
problem at the log portion.  We found that sometimes our DBAs set up the
informix dump scripts with one environment, without making the cooresponding
change to the alarm exit for log dumps.  Hence the log dumps were sent to a
different node name or under a different user id, which causes very difficult
problems.

David Hendrix
dmhendri AT fedex DOT com








Gregory Day <gday AT US.IBM DOT COM> on 05/18/99 09:39:00 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>








 To:      ADSM-L AT VM.MARIST DOT EDU

 cc:      (bcc: DAVID HENDRIX/216832/ITD/FEDEX)



 Subject: ADSM and Informix









We have a Sun Solaris 2.6 server with ADSM client 3.1.0.5 installed.  The
servers also has Informix 7.30 installed.  We are backing up the Informix server
to a NT ADSM server (3.1.2.0).  The problem is that the backup does not complete
successfully.  Informix tech support is stating it is an ADSM problem and not an
Informix or Onbar backup problem.  I included part of the onbar log.

The XBSA and ADSM client was setup according to the procedures in the README.API
as well as the latest Redbook.

Any help is appreciated.

Thanks
Greg

===================================================================
ONBAR BACKUP STARTED - Thu May  6 22:17:06 PDT 1999
ONCONFIG = onconfig.cf
INFORMIXDIR = /usr/informix/7.30.UC3
INFORMIXSERVER = spmtcp
INFXBSA_SERVER =
INFXBSA_SCHEDULED =
INFXBSA_USER_INITIATED =
INFXBSA_FULL =
INFXBSA_INCR =
INFXBSA_CLASS =
EXECUTING PARALLEL FULL BACKUP (onbar -b)
 1999-05-06 22:17:08 10519  10518 /usr/informix/7.30.UC3/bin/onbar_d -b -f
/export/home/informix/dba/onbar_specs.txt
 1999-05-06 22:17:09 10519  10518 Begin level 0 backup rootdbs.
 1999-05-06 22:17:09 10519  10518 Successfully connected to Storage Manager.
 1999-05-06 22:17:10 10519  10518 Completed level 0 backup rootdbs.
 1999-05-06 22:17:11 10529  10519 Process 10529  10519 successfully forked.
 1999-05-06 22:17:11 10530  10519 Process 10530  10519 successfully forked.
 1999-05-06 22:17:11 10531  10519 Process 10531  10519 successfully forked.
 1999-05-06 22:17:11 10532  10519 Process 10532  10519 successfully forked.
 1999-05-06 22:17:11 10533  10519 Process 10533  10519 successfully forked.
 1999-05-06 22:17:12 10529  10519 Begin level 0 backup dbs_llog.
 1999-05-06 22:17:12 10532  10519 Begin level 0 backup dbs_test.
 1999-05-06 22:17:12 10529  10519 Successfully connected to Storage Manager.
 1999-05-06 22:17:12 10530  10519 Begin level 0 backup dbs_plog.
 1999-05-06 22:17:12 10529  10519 Completed level 0 backup dbs_llog.
 1999-05-06 22:17:12 10530  10519 Successfully connected to Storage Manager.
 1999-05-06 22:17:12 10532  10519 Successfully connected to Storage Manager.
 1999-05-06 22:17:12 10530  10519 Completed level 0 backup dbs_plog.
 1999-05-06 22:17:12 10531  10519 Begin level 0 backup dbs_dev.
 1999-05-06 22:17:12 10531  10519 Successfully connected to Storage Manager.
 1999-05-06 22:17:13 10532  10519 Completed level 0 backup dbs_test.
 1999-05-06 22:17:13 10533  10519 Begin level 0 backup workdbs.
 1999-05-06 22:17:14 10533  10519 Successfully connected to Storage Manager.
 1999-05-06 22:17:14 10529  10519 Process 10529  10519 completed.
 1999-05-06 22:17:14 10530  10519 Process 10530  10519 completed.
 1999-05-06 22:17:14 10532  10519 Process 10532  10519 completed.
 1999-05-06 22:19:16 10533  10519 Completed level 0 backup workdbs.
 1999-05-06 22:19:19 10533  10519 Process 10533  10519 completed.
 1999-05-06 22:23:16 10531  10519 Completed level 0 backup dbs_dev.
 1999-05-06 22:23:24 10531  10519 Process 10531  10519 completed.
 1999-05-06 22:23:24 10519  10518 Begin backup logical log 1315.
 1999-05-06 22:23:24 10519  10518 Successfully connected to Storage Manager.
 1999-05-06 22:23:27 10519  10518 XBSA Error (BSAQueryObject): Backup object
does not exist in Storage Manager.
 1999-05-06 22:23:27 10519  10518 ERROR: Missing data for bar_instance set
clause.
 1999-05-06 22:23:32 10519  10518 SQL   -25582     Network connection is broken.
 1999-05-06 22:23:32 10519  10518 ISAM        9    Bad file number
### 05/06 22:23 FAILURE 139 IN EXECUTING PARALLEL FULL BACKUP (onbar -b)
 1999-05-06 22:23:33 10632  10631 /usr/informix/7.30.UC3/bin/onbar_d -l
 1999-05-06 22:23:33 10632  10631 Begin backup logical log 1315.
 1999-05-06 22:23:33 10632  10631 Successfully connected to Storage Manager.
 1999-05-06 22:23:35 10632  10631 XBSA Error (BSAQueryObject): Backup object
does not exist in Storage Manager.
 1999-05-06 22:23:35 10632  10631 ERROR: Missing data for bar_instance set
clause.
 1999-05-06 22:23:40 10632  10631 SQL   -25582     Network connection is broken.
 1999-05-06 22:23:40 10632  10631 ISAM        9    Bad file number
 1999-05-06 22:26:48 10680  10679 /usr/informix/7.30.UC3/bin/onbar_d -l
 1999-05-06 22:26:48 10680  10679 Begin backup logical log 1315.
 1999-05-06 22:26:48 10680  10679 Successfully connected to Storage Manager.
 1999-05-06 22:26:50 10680  10679 XBSA Error (BSAQueryObject): Backup object
does not exist in Storage Manager.
 1999-05-06 22:26:51 10680  10679 ERROR: Missing data for bar_instance set
clause.
 1999-05-06 22:26:56 10680  10679 SQL   -25582     Network connection is broken.
 1999-05-06 22:26:56 10680  10679 ISAM        9    Bad file number
 1999-05-06 22:34:03 10743  10742 /usr/informix/7.30.UC3/bin/onbar_d -l
 1999-05-06 22:34:03 10743  10742 Begin backup logical log 1315.
 1999-05-06 22:34:03 10743  10742 Successfully connected to Storage Manager.
 1999-05-06 22:34:05 10743  10742 XBSA Error (BSAQueryObject): Backup object
does not exist in Storage Manager.
 1999-05-06 22:34:05 10743  10742 ERROR: Missing data for bar_instance set
clause.
 1999-05-06 22:34:10 10743  10742 SQL   -25582     Network connection is broken.
 1999-05-06 22:34:10 10743  10742 ISAM        9    Bad file number
<Prev in Thread] Current Thread [Next in Thread>