Hi!
I recently moved from DISK to FILE dev class for my DB2 data backups. Apparently one day was missed. How do I get these older files from V7SAN copied or moved to VTL then to tape? Thx!!
# ls -lrt -R /tsmdb2 |grep -i .bfs
-rw------- 1 tsminst1 tsmsrvrs 16532373504 Jun 22 19:19 00000004.bfs
-rw------- 1 tsminst1 tsmsrvrs 11133779968 Jun 22 19:19 00000005.bfs
-rw------- 1 tsminst1 tsmsrvrs 27390902272 Jun 22 18:45 00000001.bfs
-rw------- 1 tsminst1 tsmsrvrs 27390902272 Jun 22 18:49 00000000.bfs
-rw------- 1 tsminst1 tsmsrvrs 27390902272 Jun 22 19:02 00000003.bfs
# df -gt |grep db2
/dev/db2cyblv00 6655.50 2068.57 4586.93 32% /tsmdb2/db200
/dev/db2cyblv01 6655.50 2083.71 4571.79 32% /tsmdb2/db201
/dev/db2cyblv02 6655.50 2109.22 4546.28 32% /tsmdb2/db202
/dev/db2cyblv03 6655.50 2058.20 4597.30 31% /tsmdb2/db203
/dev/db2cyblv04 6655.50 2073.60 4581.90 32% /tsmdb2/db204
/dev/db2cyblv05 6655.50 2058.20 4597.30 31% /tsmdb2/db205
Primary is V7DB2CYB, next is cybvtl1 and then to LTO5 via my migrate daily jobs.
tsm: R2TSM01>q stg V7DB2CYB
Storage Device Storage Estimated Pct Pct High Low Next Stora-
Pool Name Class Name Type Capacity Util Migr Mig Mig ge Pool
Pct Pct
----------- ---------- --------- ---------- ----- ----- ---- --- -----------
V7DB2CYB V7DISK2VTL DEVCLASS 38,453 G 0.0 0.0 90 25 CYBVTL1
tsm: R2TSM01>q stg V7DB2CYB f=d
Storage Pool Name: V7DB2CYB
Storage Pool Type: Primary
Device Class Name: V7DISK2VTL
Storage Type: DEVCLASS
Cloud Type:
Cloud URL:
Cloud Identity:
Cloud Location:
Estimated Capacity: 38,453 G
Space Trigger Util: 0.0
Pct Util: 0.0
Pct Migr: 0.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 25
Migration Delay: 0
Migration Continue: Yes
Migration Processes: 4
Reclamation Processes: 2
Next Storage Pool: CYBVTL1
Reclaim Storage Pool:
Maximum Size Threshold: No Limit
Access: Read/Write
Description:
Overflow Location:
Cache Migrated Files?:
Collocate?: Node
Reclamation Threshold: 60
Offsite Reclamation Limit:
Maximum Scratch Volumes Allowed: 1,024
Number of Scratch Volumes Used: 0
Delay Period for Volume Reuse: 0 Day(s)
Migration in Progress?: No
Amount Migrated (MB): 586.88
Elapsed Migration Time (seconds): 324
Reclamation in Progress?: No
Last Update by (administrator): xxxxxx
Last Update Date/Time: 06/22/2017 10:55:48
Storage Pool Data Format: Native
Copy Storage Pool(s):
Active Data Pool(s):
Continue Copy on Error?: Yes
CRC Data: No
Reclamation Type: Threshold
Overwrite Data when Deleted:
Deduplicate Data?: No
Processes For Identifying Duplicates:
Duplicate Data Not Stored:
Auto-copy Mode: All
Contains Data Deduplicated by Client?: No
Maximum Simultaneous Writers:
Protection Storage Pool:
Date of Last Protection:
Deduplicate Requires Backup?:
Encrypted:
Space Utilized(MB):
I recently moved from DISK to FILE dev class for my DB2 data backups. Apparently one day was missed. How do I get these older files from V7SAN copied or moved to VTL then to tape? Thx!!
# ls -lrt -R /tsmdb2 |grep -i .bfs
-rw------- 1 tsminst1 tsmsrvrs 16532373504 Jun 22 19:19 00000004.bfs
-rw------- 1 tsminst1 tsmsrvrs 11133779968 Jun 22 19:19 00000005.bfs
-rw------- 1 tsminst1 tsmsrvrs 27390902272 Jun 22 18:45 00000001.bfs
-rw------- 1 tsminst1 tsmsrvrs 27390902272 Jun 22 18:49 00000000.bfs
-rw------- 1 tsminst1 tsmsrvrs 27390902272 Jun 22 19:02 00000003.bfs
# df -gt |grep db2
/dev/db2cyblv00 6655.50 2068.57 4586.93 32% /tsmdb2/db200
/dev/db2cyblv01 6655.50 2083.71 4571.79 32% /tsmdb2/db201
/dev/db2cyblv02 6655.50 2109.22 4546.28 32% /tsmdb2/db202
/dev/db2cyblv03 6655.50 2058.20 4597.30 31% /tsmdb2/db203
/dev/db2cyblv04 6655.50 2073.60 4581.90 32% /tsmdb2/db204
/dev/db2cyblv05 6655.50 2058.20 4597.30 31% /tsmdb2/db205
Primary is V7DB2CYB, next is cybvtl1 and then to LTO5 via my migrate daily jobs.
tsm: R2TSM01>q stg V7DB2CYB
Storage Device Storage Estimated Pct Pct High Low Next Stora-
Pool Name Class Name Type Capacity Util Migr Mig Mig ge Pool
Pct Pct
----------- ---------- --------- ---------- ----- ----- ---- --- -----------
V7DB2CYB V7DISK2VTL DEVCLASS 38,453 G 0.0 0.0 90 25 CYBVTL1
tsm: R2TSM01>q stg V7DB2CYB f=d
Storage Pool Name: V7DB2CYB
Storage Pool Type: Primary
Device Class Name: V7DISK2VTL
Storage Type: DEVCLASS
Cloud Type:
Cloud URL:
Cloud Identity:
Cloud Location:
Estimated Capacity: 38,453 G
Space Trigger Util: 0.0
Pct Util: 0.0
Pct Migr: 0.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 25
Migration Delay: 0
Migration Continue: Yes
Migration Processes: 4
Reclamation Processes: 2
Next Storage Pool: CYBVTL1
Reclaim Storage Pool:
Maximum Size Threshold: No Limit
Access: Read/Write
Description:
Overflow Location:
Cache Migrated Files?:
Collocate?: Node
Reclamation Threshold: 60
Offsite Reclamation Limit:
Maximum Scratch Volumes Allowed: 1,024
Number of Scratch Volumes Used: 0
Delay Period for Volume Reuse: 0 Day(s)
Migration in Progress?: No
Amount Migrated (MB): 586.88
Elapsed Migration Time (seconds): 324
Reclamation in Progress?: No
Last Update by (administrator): xxxxxx
Last Update Date/Time: 06/22/2017 10:55:48
Storage Pool Data Format: Native
Copy Storage Pool(s):
Active Data Pool(s):
Continue Copy on Error?: Yes
CRC Data: No
Reclamation Type: Threshold
Overwrite Data when Deleted:
Deduplicate Data?: No
Processes For Identifying Duplicates:
Duplicate Data Not Stored:
Auto-copy Mode: All
Contains Data Deduplicated by Client?: No
Maximum Simultaneous Writers:
Protection Storage Pool:
Date of Last Protection:
Deduplicate Requires Backup?:
Encrypted:
Space Utilized(MB):