SearchFAQMemberlist Log in
Reply to topic Page 1 of 1
No Query Restore & faster restore performance question?
Author Message
Post No Query Restore & faster restore performance question? 
Hi Everyone,

I have a TSM 5.5.1.0 server on AIX 5.3 and the client involved was a Linux
2.6.9-55 server at the tsm client version 5.5.0.6. I had thought that a
no query restore was envoked with the syntax: dsmc restore -subdir=yes
/u01/ but how do you know for sure when a no query restore is done? Or
did I need an * after/u01*?

I also found that in order to increase a restore you should have the
subdir, replace, tapeprompt and quiet options in the client user options
file. Is there anything else that can be done to increase performance?

Below is an example of a restore done last night. It looks like all of
the data came from our CDL (the DB* tapes), but since we have reclamation
set to 50 on the CDLB_LINUX storage pool we are confused why it needed so
many tapes mounted as well as what we could've done to improve the speed
of the restore. The restore command used for this was: dsmc restore
-subdir=yes /u01/ which we were hoping would restore all of /u01 to the
linux server chln012.

Thanks in advance to anyone that has advice and

Date/Time Message
--------------------
----------------------------------------------------------
07/27/08 20:32:57 ANR0406I Session 419201 started for node CHLN012
(Linux86)
(Tcp/Ip chln012.highmark.com(33188)). (SESSION:
419201)
07/27/08 20:38:52 ANR1182I Removable volume DB0000 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:38:54 ANR1182I Removable volume DB0093 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:38:54 ANR1182I Removable volume DB0078 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:39:56 ANR1182I Removable volume DB0139 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:39:57 ANR1182I Removable volume DB0066 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:39:57 ANR1182I Removable volume DB0001 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:00 ANR1182I Removable volume DB0033 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:01 ANR1182I Removable volume DB0091 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:02 ANR1182I Removable volume DB0154 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:04 ANR1182I Removable volume DB0185 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:05 ANR1182I Removable volume DB0057 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:05 ANR1182I Removable volume DB0188 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:07 ANR1182I Removable volume DB0128 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:08 ANR1182I Removable volume DB0179 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:09 ANR1182I Removable volume DB0029 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:10 ANR1182I Removable volume DB0176 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:12 ANR1182I Removable volume DB0053 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:35 ANR1182I Removable volume DB0132 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:36 ANR1182I Removable volume DB0047 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:37 ANR1182I Removable volume DB0105 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:37 ANR1182I Removable volume DB0031 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:40:41 ANR1182I Removable volume DB0075 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:41:07 ANR1182I Removable volume DB0068 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:41:09 ANR1182I Removable volume DB0135 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:41:17 ANR1182I Removable volume DB0141 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:41:35 ANR8337I LTO volume DB0093 mounted in drive VLTO2-63

(/dev/rmt63). (SESSION: 419201)
07/27/08 20:41:35 ANR0510I Session 419201 opened input volume DB0093.

(SESSION: 419201)
07/27/08 20:41:43 ANR1182I Removable volume DB0008 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:41:45 ANR1182I Removable volume DB0108 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:42:16 ANR1182I Removable volume DB0042 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:42:18 ANR1182I Removable volume DB0167 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:42:19 ANR1182I Removable volume DB0104 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:42:53 ANR1182I Removable volume DB0171 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:43:38 ANR0514I Session 419201 closed volume DB0093.
(SESSION:
419201)
07/27/08 20:43:38 ANR8337I LTO volume DB0139 mounted in drive VLTO2-28

(/dev/rmt28). (SESSION: 419201)
07/27/08 20:43:38 ANR0510I Session 419201 opened input volume DB0139.

(SESSION: 419201)
07/27/08 20:43:49 ANR0514I Session 419201 closed volume DB0139.
(SESSION:
419201)
07/27/08 20:43:50 ANR8337I LTO volume DB0066 mounted in drive VLTO2-64

(/dev/rmt64). (SESSION: 419201)
07/27/08 20:43:50 ANR0510I Session 419201 opened input volume DB0066.

(SESSION: 419201)
07/27/08 20:44:03 ANR1182I Removable volume DB0118 is required for a
restore
request from session 419201. (SESSION: 419201)
07/27/08 20:44:28 ANR0514I Session 419201 closed volume DB0066.
(SESSION:
419201)
07/27/08 20:44:29 ANR8337I LTO volume DB0001 mounted in drive VLTO2-66

(/dev/rmt66). (SESSION: 419201)
07/27/08 20:44:29 ANR0510I Session 419201 opened input volume DB0001.

(SESSION: 419201)
07/27/08 20:44:47 ANR1183I Initial determination of removable volumes

required for a restore request from session 419201
is
complete. Additional volumes may still be required.

(SESSION: 419201)
07/27/08 20:45:38 ANR8468I LTO volume DB0093 dismounted from drive
VLTO2-63
(/dev/rmt63) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:45:49 ANR8468I LTO volume DB0139 dismounted from drive
VLTO2-28
(/dev/rmt28) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:46:28 ANR8468I LTO volume DB0066 dismounted from drive
VLTO2-64
(/dev/rmt64) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:46:41 ANR0514I Session 419201 closed volume DB0001.
(SESSION:
419201)
07/27/08 20:46:41 ANR8337I LTO volume DB0154 mounted in drive VLTO2-29

(/dev/rmt29). (SESSION: 419201)
07/27/08 20:46:41 ANR0510I Session 419201 opened input volume DB0154.

(SESSION: 419201)
07/27/08 20:48:41 ANR8468I LTO volume DB0001 dismounted from drive
VLTO2-66
(/dev/rmt66) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:50:37 ANR0514I Session 419201 closed volume DB0154.
(SESSION:
419201)
07/27/08 20:50:38 ANR8337I LTO volume DB0057 mounted in drive VLTO2-67

(/dev/rmt67). (SESSION: 419201)
07/27/08 20:50:38 ANR0510I Session 419201 opened input volume DB0057.

(SESSION: 419201)
07/27/08 20:52:37 ANR8468I LTO volume DB0154 dismounted from drive
VLTO2-29
(/dev/rmt29) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:52:57 ANR0514I Session 419201 closed volume DB0057.
(SESSION:
419201)
07/27/08 20:52:59 ANR8337I LTO volume DB0179 mounted in drive VLTO2-38

(/dev/rmt38). (SESSION: 419201)
07/27/08 20:52:59 ANR0510I Session 419201 opened input volume DB0179.

(SESSION: 419201)
07/27/08 20:53:40 ANR0514I Session 419201 closed volume DB0179.
(SESSION:
419201)
07/27/08 20:53:40 ANR8337I LTO volume DB0053 mounted in drive VLTO2-33

(/dev/rmt33). (SESSION: 419201)
07/27/08 20:53:40 ANR0510I Session 419201 opened input volume DB0053.

(SESSION: 419201)
07/27/08 20:54:02 ANR0514I Session 419201 closed volume DB0053.
(SESSION:
419201)
07/27/08 20:54:03 ANR8337I LTO volume DB0047 mounted in drive VLTO2-32

(/dev/rmt32). (SESSION: 419201)
07/27/08 20:54:03 ANR0510I Session 419201 opened input volume DB0047.

(SESSION: 419201)
07/27/08 20:54:58 ANR8468I LTO volume DB0057 dismounted from drive
VLTO2-67
(/dev/rmt67) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:55:23 ANR0514I Session 419201 closed volume DB0047.
(SESSION:
419201)
07/27/08 20:55:23 ANR8337I LTO volume DB0105 mounted in drive VLTO2-39

(/dev/rmt39). (SESSION: 419201)
07/27/08 20:55:23 ANR0510I Session 419201 opened input volume DB0105.

(SESSION: 419201)
07/27/08 20:55:40 ANR8468I LTO volume DB0179 dismounted from drive
VLTO2-38
(/dev/rmt38) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:56:02 ANR8468I LTO volume DB0053 dismounted from drive
VLTO2-33
(/dev/rmt33) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:56:56 ANR0514I Session 419201 closed volume DB0105.
(SESSION:
419201)
07/27/08 20:56:56 ANR8337I LTO volume DB0075 mounted in drive VLTO2-42

(/dev/rmt42). (SESSION: 419201)
07/27/08 20:56:56 ANR0510I Session 419201 opened input volume DB0075.

(SESSION: 419201)
07/27/08 20:57:23 ANR8468I LTO volume DB0047 dismounted from drive
VLTO2-32
(/dev/rmt32) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:57:41 ANR0514I Session 419201 closed volume DB0075.
(SESSION:
419201)
07/27/08 20:57:41 ANR8337I LTO volume DB0135 mounted in drive VLTO2-43

(/dev/rmt43). (SESSION: 419201)
07/27/08 20:57:42 ANR0510I Session 419201 opened input volume DB0135.

(SESSION: 419201)
07/27/08 20:58:17 ANR0514I Session 419201 closed volume DB0135.
(SESSION:
419201)
07/27/08 20:58:18 ANR8337I LTO volume DB0008 mounted in drive VLTO2-45

(/dev/rmt45). (SESSION: 419201)
07/27/08 20:58:18 ANR0510I Session 419201 opened input volume DB0008.

(SESSION: 419201)
07/27/08 20:58:56 ANR8468I LTO volume DB0105 dismounted from drive
VLTO2-39
(/dev/rmt39) in library CDLB_DEV. (SESSION: 419201)

07/27/08 20:59:13 ANR0514I Session 419201 closed volume DB0008.
(SESSION:
419201)
07/27/08 20:59:13 ANR8337I LTO volume DB0042 mounted in drive VLTO2-48

(/dev/rmt48). (SESSION: 419201)
07/27/08 20:59:13 ANR0510I Session 419201 opened input volume DB0042.

(SESSION: 419201)
07/27/08 20:59:41 ANR8468I LTO volume DB0075 dismounted from drive
VLTO2-42
(/dev/rmt42) in library CDLB_DEV. (SESSION: 419201)

07/27/08 21:00:17 ANR8468I LTO volume DB0135 dismounted from drive
VLTO2-43
(/dev/rmt43) in library CDLB_DEV. (SESSION: 419201)

07/27/08 21:00:28 ANR2017I Administrator LID3QE9 issued command: QUERY

ACTLOG search="session: 419201" (SESSION: 419414)

07/27/08 21:00:45 ANR0514I Session 419201 closed volume DB0042.
(SESSION:
419201)
07/27/08 21:00:46 ANR8337I LTO volume DB0104 mounted in drive VLTO2-51

(/dev/rmt51). (SESSION: 419201)
07/27/08 21:00:46 ANR0510I Session 419201 opened input volume DB0104.

(SESSION: 419201)
07/27/08 21:01:13 ANR8468I LTO volume DB0008 dismounted from drive
VLTO2-45
(/dev/rmt45) in library CDLB_DEV. (SESSION: 419201)

07/27/08 21:01:29 ANR0514I Session 419201 closed volume DB0104.
(SESSION:
419201)
07/27/08 21:01:34 ANE4955I (Session: 419201, Node: CHLN012) Total
number of
objects restored: 3,338(SESSION: 419201)
07/27/08 21:01:34 ANE4959I (Session: 419201, Node: CHLN012) Total
number of
objects failed: 0(SESSION: 419201)
07/27/08 21:01:34 ANE4961I (Session: 419201, Node: CHLN012) Total
number of
bytes transferred: 147.85 MB(SESSION: 419201)
07/27/08 21:01:34 ANE4963I (Session: 419201, Node: CHLN012) Data
transfer
time: 1,660.88 sec(SESSION: 419201)

07/27/08 21:01:34 ANE4966I (Session: 419201, Node: CHLN012) Network
data
transfer rate: 91.15 KB/sec(SESSION:
419201)
07/27/08 21:01:34 ANE4967I (Session: 419201, Node: CHLN012) Aggregate
data
transfer rate: 88.21 KB/sec(SESSION:
419201)
07/27/08 21:01:34 ANE4964I (Session: 419201, Node: CHLN012) Elapsed

processing time: 00:28:36(SESSION:
419201)
07/27/08 21:01:34 ANR0403I Session 419201 ended for node CHLN012
(Linux86).
(SESSION: 419201)
07/27/08 21:02:45 ANR8468I LTO volume DB0042 dismounted from drive
VLTO2-48
(/dev/rmt48) in library CDLB_DEV. (SESSION: 419201)

07/27/08 21:03:29 ANR8336I Verifying label of LTO volume DB0104 in
drive
VLTO2-51 (/dev/rmt51). (SESSION: 419201)
07/27/08 21:03:29 ANR8468I LTO volume DB0104 dismounted from drive
VLTO2-51
(/dev/rmt51) in library CDLB_DEV. (SESSION: 419201)


********************************
Joni Moyer
Highmark
Storage Systems, Storage Mngt Analyst III
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer < at > highmark.com
********************************

Post No Query Restore & faster restore performance question? 
On Jul 28, 2008, at 11:50 AM, Joni Moyer wrote:

Hi Everyone,

I have a TSM 5.5.1.0 server on AIX 5.3 and the client involved was a
Linux
2.6.9-55 server at the tsm client version 5.5.0.6. I had thought
that a
no query restore was envoked with the syntax: dsmc restore -
subdir=yes
/u01/ but how do you know for sure when a no query restore is
done? ...

The appearance of the ANR1182I and ANR1183I messages indicates that
NQR is in play. See IBM Technote 1256380.

... Is there anything else that can be done to increase performance?

Things that we have historically found to improve performance are
summarized under
Restoral performance
in http://people.bu.edu/rbs/ADSM.QuickFacts

The magic word "collocation" does not appear in your posting, so you
probably have a lot of tape mounts due to insufficient collocation.
You can survey the tapes with the Query CONtent command to check that
out.

Richard Sims still at Boston University

Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Magic SEO URL for phpBB