sql question
I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it.
Re: sql question
Hi, It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on AIX 7, and TSM 6.3.4 on Redhat 5 and 6 Select a.node_name from nodes a where - a.node_name not in (select b.node_name from collocgroup b) On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary g...@bsu.edu wrote: I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it.
Re: sql question
Nick: Just tried a cut and paste directly into the admin client. Same results, Anr2034E no results match this criteria However, a select count(node_name) from collocgroup gives 74 And select count(*) from nodes gives 196 I'm baffled -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Marouf Sent: Thursday, September 11, 2014 8:08 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql question Hi, It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on AIX 7, and TSM 6.3.4 on Redhat 5 and 6 Select a.node_name from nodes a where - a.node_name not in (select b.node_name from collocgroup b) On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary g...@bsu.edu wrote: I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it.
Re: sql question
Gary, Since the field COLLOCGROUP_NAME is in the NODES table you could use the below queries as a sanity check to help verify the results you are seeing from your collocation sub-query. select NODE_NAME, COLLOCGROUP_NAME from nodes select count(*) from nodes where COLLOCGROUP_NAME is NULL Hope this helps, Bill On 9/11/2014 8:18 AM, Lee, Gary wrote: Nick: Just tried a cut and paste directly into the admin client. Same results, Anr2034E no results match this criteria However, a select count(node_name) from collocgroup gives 74 And select count(*) from nodes gives 196 I'm baffled -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Marouf Sent: Thursday, September 11, 2014 8:08 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql question Hi, It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on AIX 7, and TSM 6.3.4 on Redhat 5 and 6 Select a.node_name from nodes a where - a.node_name not in (select b.node_name from collocgroup b) On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary g...@bsu.edu wrote: I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it. -- William Sefranek University of Buffalo Enterprise Infrastructure Services (716)645-5116
Re: sql question
Thanks William. Don't know how I overlooked collocgroup_name in the nodes table. Makes life easier. Also confirmed what I thought. I should see 122 results from my previous query. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of William Sefranek Sent: Thursday, September 11, 2014 8:56 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql question Gary, Since the field COLLOCGROUP_NAME is in the NODES table you could use the below queries as a sanity check to help verify the results you are seeing from your collocation sub-query. select NODE_NAME, COLLOCGROUP_NAME from nodes select count(*) from nodes where COLLOCGROUP_NAME is NULL Hope this helps, Bill On 9/11/2014 8:18 AM, Lee, Gary wrote: Nick: Just tried a cut and paste directly into the admin client. Same results, Anr2034E no results match this criteria However, a select count(node_name) from collocgroup gives 74 And select count(*) from nodes gives 196 I'm baffled -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Marouf Sent: Thursday, September 11, 2014 8:08 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql question Hi, It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on AIX 7, and TSM 6.3.4 on Redhat 5 and 6 Select a.node_name from nodes a where - a.node_name not in (select b.node_name from collocgroup b) On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary g...@bsu.edu wrote: I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it. -- William Sefranek University of Buffalo Enterprise Infrastructure Services (716)645-5116
Re: sql question
Regarding the original SELECT statement: I suspect there may be an empty collocation group that is messing up the results. Although Bill's is certainly the more optimal approach, I suspect that this will also work (better): select node_name from nodes where node_name not in (select node_name from collocgroup where node_name is not null) Best regards, - Andy Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead | stor...@us.ibm.com IBM Tivoli Storage Manager links: Product support: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager Online documentation: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli +Documentation+Central/page/Tivoli+Storage+Manager Product Wiki: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivoli +Storage+Manager/page/Home ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2014-09-11 09:01:03: From: Lee, Gary g...@bsu.edu To: ADSM-L@VM.MARIST.EDU Date: 2014-09-11 09:01 Subject: Re: sql question Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Thanks William. Don't know how I overlooked collocgroup_name in the nodes table. Makes life easier. Also confirmed what I thought. I should see 122 results from my previous query. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of William Sefranek Sent: Thursday, September 11, 2014 8:56 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql question Gary, Since the field COLLOCGROUP_NAME is in the NODES table you could use the below queries as a sanity check to help verify the results you are seeing from your collocation sub-query. select NODE_NAME, COLLOCGROUP_NAME from nodes select count(*) from nodes where COLLOCGROUP_NAME is NULL Hope this helps, Bill On 9/11/2014 8:18 AM, Lee, Gary wrote: Nick: Just tried a cut and paste directly into the admin client. Same results, Anr2034E no results match this criteria However, a select count(node_name) from collocgroup gives 74 And select count(*) from nodes gives 196 I'm baffled -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Marouf Sent: Thursday, September 11, 2014 8:08 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql question Hi, It seems to work ok for me, I added a - for continuation. TSM on 6.3.0 on AIX 7, and TSM 6.3.4 on Redhat 5 and 6 Select a.node_name from nodes a where - a.node_name not in (select b.node_name from collocgroup b) On Thu, Sep 11, 2014 at 5:51 AM, Lee, Gary g...@bsu.edu wrote: I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it. -- William Sefranek University of Buffalo Enterprise Infrastructure Services (716)645-5116
ANS0361I error on Linux Box
Hello. We have a linux server with TSM 6.4 for Linux installed. Anyone ever see these messages: 09/10/2014 08:17:53 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:30:38 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:30:39 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:31:05 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from lstat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:34 ANS1999E Incremental processing of '/' stopped. 09/10/2014 20:32:34 ANS1028S An internal program error occurred. Not finding much on Google. Jeannie Bruno Senior Systems Analyst jbr...@cenhud.commailto:jbr...@cenhud.com Central Hudson Gas Electric (845) 486-5780
Re: ANS0361I error on Linux Box
Based on the message information available online, you might need to contact support. Here's what I found: ANS0361I: www.ibm.com/support/knowledgecenter/SSGSG7_6.4.0/com.ibm.itsm.msgs.client.doc/msg-ANS0361I.html ANS1999E: http://www.ibm.com/support/knowledgecenter/SSGSG7_6.4.0/com.ibm.itsm.msgs.client.doc/msg-ANS1999E.html ANS1028S: http://www-01.ibm.com/support/knowledgecenter/SSGSG7_6.4.0/com.ibm.itsm.msgs.client.doc/msg-ANS1028S.html Angela Robertson IBM Software Group Durham, NC 27703 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/11/2014 09:54:07 AM: From: Jeanne Bruno jbr...@cenhud.com To: ADSM-L@VM.MARIST.EDU Date: 09/11/2014 09:56 AM Subject: [ADSM-L] ANS0361I error on Linux Box Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hello. We have a linux server with TSM 6.4 for Linux installed. Anyone ever see these messages: 09/10/2014 08:17:53 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:30:38 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:30:39 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:31:05 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from lstat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:34 ANS1999E Incremental processing of '/' stopped. 09/10/2014 20:32:34 ANS1028S An internal program error occurred. Not finding much on Google. Jeannie Bruno Senior Systems Analyst jbr...@cenhud.commailto:jbr...@cenhud.com Central Hudson Gas Electric (845) 486-5780
Attempt to Restore Root ('/') Filesystem from TSM Image Backup With Incremental Changes Produces Error ANS4004E
Hello!
I am currently in the process of developing / testing a strategy to utilize
TSM's image backup functionality for bare metal system restores. On my
test box, I have six EXT4 filesystems with image backups sent to TSM as
follows:
# dsmc backup image / -snapshotproviderimage=LINUX_LVM
# dsmc backup image /boot
# dsmc backup image /home -snapshotproviderimage=LINUX_LVM
# dsmc backup image /opt -snapshotproviderimage=LINUX_LVM
# dsmc backup image /tmp -snapshotproviderimage=LINUX_LVM
# dsmc backup image /var -snapshotproviderimage=LINUX_LVM
The test system is also on a regular incremental backup schedule, and so,
after submitting the image backups for all filesystems, I add / modify /
delete a few files on each filesystem and then run a successful incremental
backup as follows:
# dsmc incr
I then hose the box by booting into a live environment and re-formatting
each of the six filesystems afresh to EXT4. Within this same live
environment, I have the TSM 7.1.0.3 client installed (the same version as I
used to send the image and incremental backups to TSM from the system I now
wish to restore).
With the TSM client installed and configured in the live environment, I
confirm that I can see that the image backups are available to restore:
Image Size Stored Size FSType Backup Date Mgmt Class A/I Image
Name
-- --- -- --- -- ---
--
1 16.00 GB 16.00 GB EXT4 09/08/2014 09:08:19 DEFAULT A /
2 500.00 MB500.00 MB EXT4 09/08/2014 09:00:07 DEFAULT A /boot
3 8.00 GB 8.00 GB EXT4 09/08/2014 09:11:40 DEFAULT A /home
4 8.00 GB 8.00 GB EXT4 09/08/2014 09:21:55 DEFAULT A /opt
5 8.00 GB 8.00 GB EXT4 09/08/2014 09:24:18 DEFAULT A /tmp
6 160.00 GB160.00 GB EXT4 09/08/2014 09:27:01 DEFAULT A /var
Satisfied that all is well, I now mount the now freshly-formatted root
('/') filesystem to the '/rescue' directory in my live environment, and
attempt to restore it from the image. Since I have incremental backups
that include various additions, changes, and deletions to the filesystem,
I've elected to restore the filesystem as follows:
[root@livecd ~]# dsmc restore image / /rescue -incremental -deletefiles
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.3
Client date/time: 09/10/2014 18:53:18
(c) Copyright by IBM Corporation and other(s) 1990, 2014. All Rights
Reserved.
Node Name: ***.***.***.***
Session established with server : Linux/x86_64
Server Version 6, Release 3, Level 4.200
Server date/time: 09/10/2014 14:53:46 Last access: 09/10/2014 14:53:37
Restore Image Function Invoked.
ANS8048W Warning! Performing image restore of the Linux file system '/' to
an alternate destination '/rescue' is not recommended as this may result in
duplicate UUIDs leading to failed mounts after a successful restore.
Continue (Yes (Y)/No (N)) y
* WARNING
Restoring a file system or raw logical volume will replace any data that
currently resides there and all file system parameters. Are you sure you
want to replace
File System/Volume: '/rescue'? (Yes (Y)/No (N)) y
Restoring 17,179,869,184 [Done]
Restore processing finished.
Restoring 4,096 / -- /rescue/ [Done]
Total number of objects restored: 2
Total number of objects failed: 0
Total number of bytes transferred:16.00 GB
Data transfer time: 195.00 sec
Network data transfer rate: 86,036.95 KB/sec
Aggregate data transfer rate: 79,144.66 KB/sec
Elapsed processing time: 00:03:31
ANS4004E Error processing '/': destination file or directory is write locked
As can be seen, the image restore completes successfully, but when TSM
attempts to reconcile the subsequent changes reflected by the later
incremental backup, error ANS4004E is issued. I have tested to confirm
whether or not the mounted '/rescue' directory is writeable, and it is.
Is it possible that the TSM client application is exercising some sort of
protection that prevents the restore feature from recovering a root ('/')
filesystem from backup? If so, that certainly would be understandable, but
is there an override for scenarios, such as the one above, when that really
is what I want to do? What am I missing?
Also, for the record, it is worth mentioning that if I don't pass the
'-incremental -deletefiles' options, the restore completes successfully and
I can then mount the other filesystems within the '/rescue' directory and
recover them from their respective image backups. Upon exiting the live
environment and attempting to boot the system, I am greeted by a successful
boot to the system in the state it was in when the image backups were made,
and from what was a completely hosed box, which is precisely what I'm
after. However,
Re: ANS0361I error on Linux Box
Yes thank you. I saw those. Well, when I do a manual backup it finishes successfully. A Scheduled backup gives me the errors. The same server was failing while trying to backup a .tar file, so I put the .tar file as an exclude in the options file, but now I get the errors I posted. So I thought if anyone had any insite.. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: Thursday, September 11, 2014 10:19 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] ANS0361I error on Linux Box Based on the message information available online, you might need to contact support. Here's what I found: ANS0361I: www.ibm.com/support/knowledgecenter/SSGSG7_6.4.0/com.ibm.itsm.msgs.client.doc/msg-ANS0361I.html ANS1999E: https://urldefense.proofpoint.com/v1/url?u=http://www.ibm.com/support/knowledgecenter/SSGSG7_6.4.0/com.ibm.itsm.msgs.client.doc/msg-ANS1999E.htmlk=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0Ar=f3l1RRS8gTbNHXijSp2%2BKEusapsywszEyX0xc4Ub8BM%3D%0Am=BxTBqoJ2Hs%2FKzaa6BEqX%2FbJhXpGPN%2BhQok%2BH9DaNvvI%3D%0As=4b96c66a950c024df5b7802040091515b3ee58c263ceb4ab6edf19e9361ae6db ANS1028S: https://urldefense.proofpoint.com/v1/url?u=http://www-01.ibm.com/support/knowledgecenter/SSGSG7_6.4.0/com.ibm.itsm.msgs.client.doc/msg-ANS1028S.htmlk=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0Ar=f3l1RRS8gTbNHXijSp2%2BKEusapsywszEyX0xc4Ub8BM%3D%0Am=BxTBqoJ2Hs%2FKzaa6BEqX%2FbJhXpGPN%2BhQok%2BH9DaNvvI%3D%0As=81e5e9b449e723657df719033fb17323c1e2dfd9f0dca03a137f286990135608 Angela Robertson IBM Software Group Durham, NC 27703 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/11/2014 09:54:07 AM: From: Jeanne Bruno jbr...@cenhud.com To: ADSM-L@VM.MARIST.EDU Date: 09/11/2014 09:56 AM Subject: [ADSM-L] ANS0361I error on Linux Box Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hello. We have a linux server with TSM 6.4 for Linux installed. Anyone ever see these messages: 09/10/2014 08:17:53 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:30:38 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:30:39 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:31:05 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from lstat, errno = 127 09/10/2014 20:32:33 ANS0361I DIAG: TransErrno: Unexpected error from GetFSInfo:stat, errno = 127 09/10/2014 20:32:34 ANS1999E Incremental processing of '/' stopped. 09/10/2014 20:32:34 ANS1028S An internal program error occurred. Not finding much on Google. Jeannie Bruno Senior Systems Analyst jbr...@cenhud.commailto:jbr...@cenhud.com Central Hudson Gas Electric (845) 486-5780
Re: Attempt to Restore Root ('/') Filesystem from TSM Image Backup With Incremental Changes Produces Error ANS4004E
I can't help with your question, but that is one slick operation!
STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
stephen.stackw...@icfi.com | icfi.com
ICF INTERNATIONAL | 7125 Thomas Edison Dr, Suite 100, Columbia, Md 21046 |
443-573-0524, 443-718-4900 (o)
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On
Behalf Of J. Adam Craig
Sent: Thursday, September 11, 2014 10:23
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Attempt to Restore Root ('/') Filesystem from TSM Image
Backup With Incremental Changes Produces Error ANS4004E
Hello!
I am currently in the process of developing / testing a strategy to utilize
TSM's
image backup functionality for bare metal system restores. On my test box, I
have six EXT4 filesystems with image backups sent to TSM as
follows:
# dsmc backup image / -snapshotproviderimage=LINUX_LVM # dsmc backup
image /boot # dsmc backup image /home -
snapshotproviderimage=LINUX_LVM # dsmc backup image /opt -
snapshotproviderimage=LINUX_LVM # dsmc backup image /tmp -
snapshotproviderimage=LINUX_LVM # dsmc backup image /var -
snapshotproviderimage=LINUX_LVM
The test system is also on a regular incremental backup schedule, and so,
after submitting the image backups for all filesystems, I add / modify /
delete
a few files on each filesystem and then run a successful incremental backup
as follows:
# dsmc incr
I then hose the box by booting into a live environment and re-formatting
each of the six filesystems afresh to EXT4. Within this same live
environment, I have the TSM 7.1.0.3 client installed (the same version as I
used to send the image and incremental backups to TSM from the system I
now wish to restore).
With the TSM client installed and configured in the live environment, I
confirm that I can see that the image backups are available to restore:
Image Size Stored Size FSType Backup Date Mgmt Class A/I Image
Name
-- --- -- --- -- ---
--
1 16.00 GB 16.00 GB EXT4 09/08/2014 09:08:19 DEFAULT A /
2 500.00 MB500.00 MB EXT4 09/08/2014 09:00:07 DEFAULT A /boot
3 8.00 GB 8.00 GB EXT4 09/08/2014 09:11:40 DEFAULT A /home
4 8.00 GB 8.00 GB EXT4 09/08/2014 09:21:55 DEFAULT A /opt
5 8.00 GB 8.00 GB EXT4 09/08/2014 09:24:18 DEFAULT A /tmp
6 160.00 GB160.00 GB EXT4 09/08/2014 09:27:01 DEFAULT A /var
Satisfied that all is well, I now mount the now freshly-formatted root
('/') filesystem to the '/rescue' directory in my live environment, and
attempt
to restore it from the image. Since I have incremental backups that include
various additions, changes, and deletions to the filesystem, I've elected to
restore the filesystem as follows:
[root@livecd ~]# dsmc restore image / /rescue -incremental -deletefiles IBM
Tivoli Storage Manager Command Line Backup-Archive Client Interface
Client Version 7, Release 1, Level 0.3
Client date/time: 09/10/2014 18:53:18
(c) Copyright by IBM Corporation and other(s) 1990, 2014. All Rights
Reserved.
Node Name: ***.***.***.***
Session established with server : Linux/x86_64
Server Version 6, Release 3, Level 4.200
Server date/time: 09/10/2014 14:53:46 Last access: 09/10/2014 14:53:37
Restore Image Function Invoked.
ANS8048W Warning! Performing image restore of the Linux file system '/' to
an alternate destination '/rescue' is not recommended as this may result in
duplicate UUIDs leading to failed mounts after a successful restore.
Continue (Yes (Y)/No (N)) y
* WARNING
Restoring a file system or raw
logical volume will replace any data that currently resides there and all file
system parameters. Are you sure you want to replace
File System/Volume: '/rescue'? (Yes (Y)/No (N)) y Restoring
17,179,869,184 [Done]
Restore processing finished.
Restoring 4,096 / -- /rescue/ [Done]
Total number of objects restored: 2
Total number of objects failed: 0
Total number of bytes transferred:16.00 GB
Data transfer time: 195.00 sec
Network data transfer rate: 86,036.95 KB/sec
Aggregate data transfer rate: 79,144.66 KB/sec
Elapsed processing time: 00:03:31
ANS4004E Error processing '/': destination file or directory is write locked
As can be seen, the image restore completes successfully, but when TSM
attempts to reconcile the subsequent changes reflected by the later
incremental backup, error ANS4004E is issued. I have tested to confirm
whether or not the mounted '/rescue' directory is writeable, and it is.
Is it possible that the TSM client application is exercising some sort of
protection that prevents the restore feature from recovering a root ('/')
filesystem from backup? If
AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi..
Has anyone experienced AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE?? IBM
says this appears to be an FCS/FSCSI protocol driver issue and are looking into
this issue (PMR 28375,379,000/PMR# 71738,379,000).
AIX V6.1.9.3
Atape V12.8.0.0
TSM Server V6.2.5.0
LABEL: TAPE_ERR4
IDENTIFIER: 5537AC5F
Date/Time: Tue Sep 9 22:38:02 CDT 2014
Sequence Number: 811703
Machine Id: 0009C7A6D600
Node Id: cgoaix08
Class: H
Type:PERM
WPAR:Global
Resource Name: rmt9
Resource Class: tape
Resource Type: 3580
Location:U7311.D20.067F4CB-P1-C03-T1-W50050763004B190C-L0
VPD:
ManufacturerIBM
Machine Type and Model..ULT3580-TD4
Serial Number...00078C0D17
Device Specific.(FW)C7QH
Description
TAPE DRIVE FAILURE
Probable Causes
ADAPTER
TAPE DRIVE
Failure Causes
ADAPTER
TAPE DRIVE
Recommended Actions
PERFORM PROBLEM DETERMINATION PROCEDURES
Detail Data
SENSE DATA
0600 1B00 0200 0300
Re: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi Charles,
I had this same error a few weeks ago. It was caused by a bad drive.
Thanks,
Bill
X-4466
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of Lamb,
Charles P.
Sent: Thursday, September 11, 2014 8:13 AM
To: ADSM-L@vm.marist.edu
Subject: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi..
Has anyone experienced AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE?? IBM
says this appears to be an FCS/FSCSI protocol driver issue and are looking into
this issue (PMR 28375,379,000/PMR# 71738,379,000).
AIX V6.1.9.3
Atape V12.8.0.0
TSM Server V6.2.5.0
LABEL: TAPE_ERR4
IDENTIFIER: 5537AC5F
Date/Time: Tue Sep 9 22:38:02 CDT 2014
Sequence Number: 811703
Machine Id: 0009C7A6D600
Node Id: cgoaix08
Class: H
Type:PERM
WPAR:Global
Resource Name: rmt9
Resource Class: tape
Resource Type: 3580
Location:U7311.D20.067F4CB-P1-C03-T1-W50050763004B190C-L0
VPD:
ManufacturerIBM
Machine Type and Model..ULT3580-TD4
Serial Number...00078C0D17
Device Specific.(FW)C7QH
Description
TAPE DRIVE FAILURE
Probable Causes
ADAPTER
TAPE DRIVE
Failure Causes
ADAPTER
TAPE DRIVE
Recommended Actions
PERFORM PROBLEM DETERMINATION PROCEDURES
Detail Data
SENSE DATA
0600 1B00 0200 0300
Re: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi.
We have quite a few of these per week (we had six last night). When we raised
it with IBM, we were told that they were spurious so I would be interested if
that turns out not to be the case. They make spotting real tape errors [a
little] more time consuming.
James.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lamb,
Charles P.
Sent: 11 September 2014 16:13
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi..
Has anyone experienced AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE?? IBM
says this appears to be an FCS/FSCSI protocol driver issue and are looking into
this issue (PMR 28375,379,000/PMR# 71738,379,000).
AIX V6.1.9.3
Atape V12.8.0.0
TSM Server V6.2.5.0
LABEL: TAPE_ERR4
IDENTIFIER: 5537AC5F
Date/Time: Tue Sep 9 22:38:02 CDT 2014
Sequence Number: 811703
Machine Id: 0009C7A6D600
Node Id: cgoaix08
Class: H
Type:PERM
WPAR:Global
Resource Name: rmt9
Resource Class: tape
Resource Type: 3580
Location:U7311.D20.067F4CB-P1-C03-T1-W50050763004B190C-L0
VPD:
ManufacturerIBM
Machine Type and Model..ULT3580-TD4
Serial Number...00078C0D17
Device Specific.(FW)C7QH
Description
TAPE DRIVE FAILURE
Probable Causes
ADAPTER
TAPE DRIVE
Failure Causes
ADAPTER
TAPE DRIVE
Recommended Actions
PERFORM PROBLEM DETERMINATION PROCEDURES
Detail Data
SENSE DATA
0600 1B00 0200 0300
Re: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
I should have said in my last message, we get them across our whole estate of
38 3592 E07 drives, split across two libraries. We don't see them on our LTO6
drives in a separate library.
James.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Cargill, Bill
Sent: 11 September 2014 16:20
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi Charles,
I had this same error a few weeks ago. It was caused by a bad drive.
Thanks,
Bill
X-4466
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of Lamb,
Charles P.
Sent: Thursday, September 11, 2014 8:13 AM
To: ADSM-L@vm.marist.edu
Subject: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi..
Has anyone experienced AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE?? IBM
says this appears to be an FCS/FSCSI protocol driver issue and are looking into
this issue (PMR 28375,379,000/PMR# 71738,379,000).
AIX V6.1.9.3
Atape V12.8.0.0
TSM Server V6.2.5.0
LABEL: TAPE_ERR4
IDENTIFIER: 5537AC5F
Date/Time: Tue Sep 9 22:38:02 CDT 2014
Sequence Number: 811703
Machine Id: 0009C7A6D600
Node Id: cgoaix08
Class: H
Type:PERM
WPAR:Global
Resource Name: rmt9
Resource Class: tape
Resource Type: 3580
Location:U7311.D20.067F4CB-P1-C03-T1-W50050763004B190C-L0
VPD:
ManufacturerIBM
Machine Type and Model..ULT3580-TD4
Serial Number...00078C0D17
Device Specific.(FW)C7QH
Description
TAPE DRIVE FAILURE
Probable Causes
ADAPTER
TAPE DRIVE
Failure Causes
ADAPTER
TAPE DRIVE
Recommended Actions
PERFORM PROBLEM DETERMINATION PROCEDURES
Detail Data
SENSE DATA
0600 1B00 0200 0300
Re: sql question
Have you tried the sample script q_nongroupednodes? All the sample scripts are in the TSM software installation directory in scripts.smp - install with dsmserv runfilepathscripts.smp DEFINE SCRIPT Q_NONGROUPEDNODES DESC=Display nodes not in a colloc group UPDATE SCRIPT Q_NONGROUPEDNODES /* */ UPDATE SCRIPT Q_NONGROUPEDNODES /* Script Name: q_nongroupednodes */ UPDATE SCRIPT Q_NONGROUPEDNODES /* Description: Displays the */ UPDATE SCRIPT Q_NONGROUPEDNODES /* registered nodes that are not */ UPDATE SCRIPT Q_NONGROUPEDNODES /* currently defined as members */ UPDATE SCRIPT Q_NONGROUPEDNODES /* of a collocation group, and their */ UPDATE SCRIPT Q_NONGROUPEDNODES /* domain.*/ UPDATE SCRIPT Q_NONGROUPEDNODES /* Parameter: none */ UPDATE SCRIPT Q_NONGROUPEDNODES /* Example: run q_nongroupednodes */ UPDATE SCRIPT Q_NONGROUPEDNODES /* */ UPDATE SCRIPT Q_NONGROUPEDNODES select domain_name as Domain, - UPDATE SCRIPT Q_NONGROUPEDNODES node_name as - UPDATE SCRIPT Q_NONGROUPEDNODES Nodes not defined to collocation group - UPDATE SCRIPT Q_NONGROUPEDNODES from nodes where collocgroup_name is - UPDATE SCRIPT Q_NONGROUPEDNODES null order by domain_name, node_name -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: September 11, 2014 04:51 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] sql question I have run myself ragged on this one. I would have sworn it worked yesterday morning. Tsm server 6.2.5 under RHEL 6.1 I am trying to get a list of nodes not in a collocgroup. Statement follows: Select a.node_name from nodes a where a.node_name not in (select b.node_name from collocgroup b) Thanks foor any assistance. Its probably simple, and I'm just not seeing it.
FW: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Try this and see if it helps.
1. take the drive path offline in TSM
Then the drive offline in TSM
2. run: rmdev -Rdl fscsi11
3. rmdev -Rl fcs11
4. cfgmgr -l fcs11
Then place the drive online in TSM
5. Put the drive PATH back online in TSM
The drive will come back as rmt9 as long as no other changes are made to drives.
Need to run commands to find the associated rmtxx to fscsixx and fcsxx. Some
of the rmtxx still created AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE
after running the above commands after a while.
-Original Message-
From: Lamb, Charles P.
Sent: Thursday, September 11, 2014 10:26 AM
To: Hartman, Thomas J.; Goebel, Curtis J.
Subject: FW: AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Fyi.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of James
Thorne
Sent: Thursday, September 11, 2014 10:22 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi.
We have quite a few of these per week (we had six last night). When we raised
it with IBM, we were told that they were spurious so I would be interested if
that turns out not to be the case. They make spotting real tape errors [a
little] more time consuming.
James.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lamb,
Charles P.
Sent: 11 September 2014 16:13
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE Question
Hi..
Has anyone experienced AIX ERRPT ID 5537AC5F TAPE DRIVE FAILURE MESSAGE?? IBM
says this appears to be an FCS/FSCSI protocol driver issue and are looking into
this issue (PMR 28375,379,000/PMR# 71738,379,000).
AIX V6.1.9.3
Atape V12.8.0.0
TSM Server V6.2.5.0
LABEL: TAPE_ERR4
IDENTIFIER: 5537AC5F
Date/Time: Tue Sep 9 22:38:02 CDT 2014
Sequence Number: 811703
Machine Id: 0009C7A6D600
Node Id: cgoaix08
Class: H
Type:PERM
WPAR:Global
Resource Name: rmt9
Resource Class: tape
Resource Type: 3580
Location:U7311.D20.067F4CB-P1-C03-T1-W50050763004B190C-L0
VPD:
ManufacturerIBM
Machine Type and Model..ULT3580-TD4
Serial Number...00078C0D17
Device Specific.(FW)C7QH
Description
TAPE DRIVE FAILURE
Probable Causes
ADAPTER
TAPE DRIVE
Failure Causes
ADAPTER
TAPE DRIVE
Recommended Actions
PERFORM PROBLEM DETERMINATION PROCEDURES
Detail Data
SENSE DATA
0600 1B00 0200 0300
Links to the 7.1.1 / 4.1.1 content in IBM Knowledge Center, on the wiki, and from an FTP site
Hello, The 7.1.1 / 4.1.1 content is available on IBM Knowledge Center. Here are the links: Tivoli Storage Manager V7.1.1 - http://www.ibm.com/support/knowledgecenter/SSGSG7_7.1.1/com.ibm.itsm.tsm.doc/welcome.html Tivoli Storage Manager for Virtual Environments V7.1.1 - http://www.ibm.com/support/knowledgecenter/SS8TDQ_7.1.1/com.ibm.itsm.ve.doc/welcome.html Tivoli Storage Manager for Storage Area Networks V7.1.1 - http://www.ibm.com/support/knowledgecenter/SSSQZW_7.1.1/com.ibm.itsm.sta.doc/welcome.html Tivoli Storage Manager HSM for Windows V7.1.1 - http://www.ibm.com/support/knowledgecenter/SSATMW_7.1.1/com.ibm.itsm.hsmwin.doc/welcome.html Tivoli Storage Manager for Space Management V7.1.1 - http://www.ibm.com/support/knowledgecenter/SSSR2R_7.1.1/com.ibm.itsm.hsmul.doc/welcome.html Tivoli Storage Manager for Databases V7.1.1 - http://www.ibm.com/support/knowledgecenter/SSTFZR_7.1.1/com.ibm.itsm.db.doc/welcome.html Tivoli Storage FlashCopy Manager V4.1.1 - http://www.ibm.com/support/knowledgecenter/SS36V9_4.1.1/com.ibm.itsm.fcm.doc/welcome.html Tivoli Storage Manager for Mail V7.1.1 - http://www.ibm.com/support/knowledgecenter/SSTG2D_7.1.1/com.ibm.itsm.mail.doc/welcome.html In addition, we have PDFs available from the TSM wiki: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Storage%20Manager/page/PDF%20versions%20for%20the%20latest%20release If you don't want to go to the wiki, you can go directly to the FTP site for the PDFs: ftp://public.dhe.ibm.com/software/products/TSM/current/ We're working on the downloadable version of this content. I hope to have more information soon. Angela Angela Robertson IBM Software Group Durham, NC 27703 aprob...@us.ibm.com
