Informix Backups using ONBAR and TSM
A DBA on IDS 10.00.FC9 (HP-UX 11i) backing up with ON-Bar to TSM 6.2 reports that backups complete cleanly and the objects are visible via TSM queries, but a cold/imported restore to a second box fails with "no storage spaces to restore", and archecker -bvs likewise validates 0 tables/fragments. Respondents suggested checking it wasn't a warm restore of an up dbspace, confirming the oncfg_<servername>.<servernum> and post-backup ixbar files were copied to the target, matching chunk sizes and ONCONFIG, registering the target node in TSM (dsmc set access / txbsapswd, or changing nodename/password in dsm.sys), checking the bar activity log for mounts, and enabling BAR_DEBUG. The poster had already done most of this; no resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9
Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Okay just a shot in the dark but there is also a bootstrap file in
$INFORMIXDIR/etc. It is called oncfg.<servername>.number. Is that file there
on the target machine?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 2:11 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23521]
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Yep - its there... I also have the ixbar.<servernum> file.
The restore tries to start - but then it just says there were no storage
spaces to restore.
When I run archecker... it is on the source server.
Laurie
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 12:23 PM >>>
Okay just a shot in the dark but there is also a bootstrap file in
$INFORMIXDIR/etc. It is called oncfg.<servername>.number. Is that file there
on the target machine?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 2:11 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23521]
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
What is the bar activity log showing ... When I do this on a separate box
.. in the dsm.sys file I change the nodename and password ... ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From: "Laurie Gustin" <lgustin@utah.gov>
To: ids@iiug.org
Date: 04/27/2011 02:11 PM
Subject: RE: Informix Backups using ONBAR and TSM [23521]
Sent by: ids-bounces@iiug.org
cold restore -
the restore box is the same version, same OS.. and I have created links
for
all the dbspaces.
The only thing that is different is that the links go to cooked files
instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a
Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't
work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level
2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are
no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks
like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
If all else fails, you can set BAR_DEBUG to a number between 1 & 9 with 9
providing the most debug info. You can then check BAR_DEBUG_LOG to see what is
going on. You may need support to help decipher that output.
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, April 27, 2011 3:09 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23528]
What is the bar activity log showing ... When I do this on a separate box ...
in the dsm.sys file I change the nodename and password ... ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From: "Laurie Gustin" <lgustin@utah.gov>
To: ids@iiug.org
Date: 04/27/2011 02:11 PM
Subject: RE: Informix Backups using ONBAR and TSM [23521] Sent by:
ids-bounces@iiug.org
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a
Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't
work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level
2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are
no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks
like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Here are my imported restore documentation. 1. verify chunks/links are same size as production 2. copy ixbar file from source and rename it to $INFORMIXDIR/etc/ixbar.<servernum> on the target 3. copy oncfg_<servername>.<servernum> from source and rename it to $INFORMIXDIR/etc/oncfg_<servername>.<servernum> on the target 4. copy $ONCONFIG file from source to target modify DBSERVERNAME and DBSERVERALIAS 5. give target permission to access TSM object for source dsmc set access backup /servera/*/* serverb dsmc set access backup /opt/informix/*/* serverb I don't modify the ixbar file or modify my dsm.sys file. Has the server being restored to been configured in TSM (register node TSM command and txbsapswd utility run?) Andrew
I can look at the debug stuff... but there are no errors on the backup - and
no real errors on the restore other than it says there is nothing to restore.
I'm pretty sure I did all the imported restore stuff right...
My real question/problem right now is why doesn't archecker find the backup
files on the source server...
Thanks
Laurie
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 1:27 PM >>>
If all else fails, you can set BAR_DEBUG to a number between 1 & 9 with 9
providing the most debug info. You can then check BAR_DEBUG_LOG to see what is
going on. You may need support to help decipher that output.
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, April 27, 2011 3:09 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23528]
What is the bar activity log showing ... When I do this on a separate box ...
in the dsm.sys file I change the nodename and password ... ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From: "Laurie Gustin" <lgustin@utah.gov>
To: ids@iiug.org
Date: 04/27/2011 02:11 PM
Subject: RE: Informix Backups using ONBAR and TSM [23521] Sent by:
ids-bounces@iiug.org
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a
Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't
work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level
2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are
no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks
like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Are you seeing any mounts in the activity log ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From: "Laurie Gustin" <lgustin@utah.gov>
To: ids@iiug.org
Date: 04/27/2011 04:08 PM
Subject: RE: Informix Backups using ONBAR and TSM [23532]
Sent by: ids-bounces@iiug.org
I can look at the debug stuff... but there are no errors on the backup -
and
no real errors on the restore other than it says there is nothing to
restore.
I'm pretty sure I did all the imported restore stuff right...
My real question/problem right now is why doesn't archecker find the
backup
files on the source server...
Thanks
Laurie
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 1:27 PM >>>
If all else fails, you can set BAR_DEBUG to a number between 1 & 9 with 9
providing the most debug info. You can then check BAR_DEBUG_LOG to see
what is
going on. You may need support to help decipher that output.
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Wednesday, April 27, 2011 3:09 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23528]
What is the bar activity log showing ... When I do this on a separate box
...
in the dsm.sys file I change the nodename and password ... ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From: "Laurie Gustin" <lgustin@utah.gov>
To: ids@iiug.org
Date: 04/27/2011 02:11 PM
Subject: RE: Informix Backups using ONBAR and TSM [23521] Sent by:
ids-bounces@iiug.org
cold restore -
the restore box is the same version, same OS.. and I have created links
for
all the dbspaces.
The only thing that is different is that the links go to cooked files
instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a
Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't
work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level
2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are
no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks
like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Does the post backup copy of the ixbar.<servernum> file exist on the target?
Zev Berezin
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 2:45 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23526]
Yep - its there... I also have the ixbar.<servernum> file .
The restore tries to start - but then it just says there were no storage
spaces to restore.
When I run archecker... it is on the source server.
Laurie
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 12:23 PM >>>
Okay just a shot in the dark but there is also a bootstrap file in
$INFORMIXDIR/etc. It is called oncfg.<servername>.number. Is that file there
on the target machine?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 2:11 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23521]
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi,
Do you have set DSMI_CONFIG;
Can you see TSM backup using dsmc q b "\\\\..\\\\*" -optfile=....\\\\dsm.opt
Sergios
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Zev
Berezin
Sent: Thursday, April 28, 2011 12:26 AM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23535]
Does the post backup copy of the ixbar.<servernum> file exist on the target?
Zev Berezin
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 2:45 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23526]
Yep - its there... I also have the ixbar.<servernum> file .
The restore tries to start - but then it just says there were no storage
spaces to restore.
When I run archecker... it is on the source server.
Laurie
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 12:23 PM >>>
Okay just a shot in the dark but there is also a bootstrap file in
$INFORMIXDIR/etc. It is called oncfg.<servername>.number. Is that file there
on the target machine?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 2:11 PM
To: ids@iiug.org
Subject: RE: Informix Backups using ONBAR and TSM [23521]
cold restore -
the restore box is the same version, same OS.. and I have created links for
all the dbspaces.
The only thing that is different is that the links go to cooked files instead
of raw volumes...
>>> "Dan Mueller" <Dan.Mueller@trnswrks.com> 4/27/2011 11:52 AM >>>
Are you trying to warm restore a dbspaces that is not down?
Dan
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Laurie
Gustin
Sent: Wednesday, April 27, 2011 12:36 PM
To: ids@iiug.org
Subject: Informix Backups using ONBAR and TSM [23517]
We are having problems doing a restore from an onbar backup, using a Tivoli
Storage Manager.
This is what we have:
IDS 10.0 FC9 on HP-UX 11.i ( we tried reverting back to fc8... it didn't work
either)
Storage Management Server for Linux/x86_64 - Version 6, Release 2, Level 2.0
Backups run with no errors, and, when I run a TSM query, I can see the
datasets, but when I try to restore from the backup, onbar says there are no
spaces to restore. The same type of output is returned from archecker.
This is the archecker output from the server that is not working looks like
this:
informix@itshp7 [/home/infrmx]
$ archecker -bvsIBM Informix Dynamic Server Version 10.00.FC9 Program Name: archecker
Version: 8.0
Released: 2008-08-28 16:34:06
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 08/28/08 16:35 on HP-UX B.11.11 U
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEBLOCK 62 KB
AC_IXBAR /home/informix/etc/ixbar.99
AC_TIMEOUT 300
AC_SESSION
Control page checks PASSED
Table checks PASSED
Tables/Fragments validated: 0
Any help would be greatly appreciated.
Thanks
Laurie
Laurie Gustin
Database Administrator
Dept of Technology Services
Dept of Public Safety
lgustin@utah.gov
801-965-4410
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 6076 (20110427) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 6076 (20110427) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Disclaimer
This message may contain privileged - confidential information and is intended
exclusively to the addressees (or any person in charge to deliver to the
addresses) . If you are not the intended recipient, you may not use, copy,
distribute or deliver this message (or part of its contents) to anyone or take
any action in reliance on it. In such a case, you should destroy this message,
and notify the sender.
All reasonable precautions have been taken to ensure no viruses are present in
this e-mail. However, as Internet is a non secure environment; we will bear no
responsibility for any loss or damage arising from the use of this e-mail or
attachments. Thus, we recommend that you subject these to your virus checking
procedures prior to use.
If any investment information is contained herein, it has been provided to you
for informational purposes only and may not be relied upon in the process of
evaluating the merits of investing in any financial instruments referred to
herein. It is not a research report, a trade confirmation or an offer or
solicitation of an offer to buy/ sell any financial instruments
Views, opinions, conclusions and other information expressed in this e-mail
are not given or endorsed by Marfin Egnatia Bank S.A. Group of Companies
unless otherwise indicated by an authorized representative independent of this
message.
ÎνÏÏÏοÏοίηÏη/ ÎÏοÏοίηÏη ÎÏ
θÏνηÏ
Tο ÏαÏÏν μήνÏ
μα ενδÎÏεÏαι να ÏεÏιλαμβάνει
εμÏιÏÏεÏ
ÏικÎÏ - αÏÏÏÏηÏÎµÏ ÏληÏοÏοÏÎ¯ÎµÏ ÎºÎ±Î¹
αÏεÏ
θÏνεÏαι αÏοκλειÏÏικά ÏÏοÏ
Ï
ÏκοÏοÏμενοÏ
Ï ÏαÏαλήÏÏÎµÏ (ή Ï
ÏεÏθÏ
νο για
Ïην ÏαÏάδοÏή ÏοÏ
ÏÏοÏ
Ï Î±Î½ÏίÏÏοιÏοÏ
Ï
ÏκοÏοÏμενοÏ
Ï ÏαÏαλήÏÏεÏ). Σε ÏεÏίÏÏÏÏη ÏοÏ
ÏεÏιÎλθει Ïε εÏÎ¬Ï Î±ÏÏ Î»Î¬Î¸Î¿Ï, δεν θα ÏÏÎÏει
να ÏÏηÏιμοÏοιήÏεÏε, ανÏιγÏάÏεÏε,
διανείμεÏε ή ÏαÏαδÏÏεÏε Ïε οÏοιονδήÏοÏε
Ïο ÏαÏÏν μήνÏ
μα (ή Ïμήμα ÏοÏ
ÏεÏιεÏομÎνοÏ
ÏοÏ
), οÏÏε να ÏÏοβείÏε Ïε οÏοιαδήÏοÏε
ενÎÏγεια βάÏει αÏ
ÏοÏ. ΣÏην ÏεÏίÏÏÏÏη αÏ
Ïή
θα ÏÏÎÏει να καÏαÏÏÏÎÏεÏε Ïο ÏαÏÏν μήνÏ
μα
και να ειδοÏοιήÏεÏε Ïον αÏο