migrating older bfs files

[TeamTLR]

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):

 

[TeamTLR]

I changed the timestamp of the files then reran the migration, but tsm did nothing.

 

[TeamTLR]

I figured so, thanks!
I keep 1 version in the copygrp, the DBA keeps 14 days, alternating fulls and incrs during the weekdays.

tsm: R2TSM01>q copy DODB2HPVtl * * t=b f=d

Policy Policy Mgmt Copy Copy Versions Versions Retain Retain Copy Mode Copy Serializ- Copy Copy Destin- Table of Last Update by Last Upda- Managing profile Changes
Domain Set Name Class Group Group Data Data Extra Only ation Frequency ation Contents (administrator) te Date/T- Pending
Name Name Name Type Exists Deleted Versions Version (TOC) Desti- ime
nation
--------- --------- --------- --------- --------- -------- -------- -------- ------- ----------- -------------- --------- ------------ ------------ --------------- ---------- -------------------- ----------
DODB2HPV- ACTIVE DB2DAILY STANDARD Backup 1 0 0 0 Modified Shared Static 0 V7DB2CYB V7DB2CYB DSMITH 06/15/2017 No
TL 15:23:46
DODB2HPV- PODB2HPV- DB2DAILY STANDARD Backup 1 0 0 0 Modified Shared Static 0 V7DB2CYB V7DB2CYB DSMITH 06/15/2017 No
TL TL 15:23:46


tsm: R2TSM01>q copy DODB2HPVtl * * t=a f=d

Policy Policy Mgmt Copy Copy Retain Retention Retain Copy Serializ- Copy Copy Mode Copy Destin- Last Update by Last Update Managing profile Changes
Domain Set Name Class Group Group Version Initiation Minimum ation Frequency ation (administrator) Date/Time Pending
Name Name Name Type Days
--------- --------- --------- --------- --------- -------- ---------- -------- -------------- --------- ----------- ------------ -------------------- -------------------- -------------------- ----------
DODB2HPV- ACTIVE DB2DAILY STANDARD Archive 15 Creation Shared Static CMD Absolute V7DB2CYB DSMITH 06/15/2017 15:24:03 No
TL
DODB2HPV- ACTIVE DB2LOGS STANDARD Archive 15 Creation Shared Static CMD Absolute V7DB2CYB DSMITH 06/15/2017 15:24:53 No


tsm: R2TSM01>q do DODB2HPVtl f=d

Policy Activated Activation Days Since Activated Number of Description Backup Archive Last Update by Last Upda- Managing profile Changes Active Data
Domain Policy Date/Time Activation Default Registered Retention Retention (administrator) te Date/T- Pending Pool List
Name Set Mgmt Nodes (Grace (Grace ime
Class Period) Period)
--------- --------- ---------- ---------- --------- ---------- ------------------------ --------- --------- --------------- ---------- -------------------- ---------- -----------
DODB2HPV- PODB2HPV- 06/15/2017 13 DB2DAILY 50 15 15 DSMITH 06/15/2017 No
TL TL 15:26:49 15:26:49

 

[moon-buddy]

Do a 'move data' (see help move data)

If you know the destination (new) stgpool name, you can move the volumes listed to the new stgpool.

 

[TeamTLR]

they dont show up from a q vol stg=v7db2cyb

tsm: R2TSM01>q vol stg=V7DB2CYB

Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
------------------------ ----------- ---------- --------- ----- --------
/tsmdb2/db200/db2cyblv05 V7DB2CYB V7DISK2VTL 2.0 T 0.0 Empty
/tsmdb2/db201/db2cyblv00 V7DB2CYB V7DISK2VTL 2.0 T 0.0 Filling
/tsmdb2/db202/db2cyblv01 V7DB2CYB V7DISK2VTL 2.0 T 0.0 Filling
/tsmdb2/db203/db2cyblv02 V7DB2CYB V7DISK2VTL 2.0 T 0.0 Empty
/tsmdb2/db204/db2cyblv03 V7DB2CYB V7DISK2VTL 2.0 T 0.0 Empty
/tsmdb2/db205/db2cyblv04 V7DB2CYB V7DISK2VTL 2.0 T 0.0 Filling

 

[moon-buddy]

So if these are not showing as active volumes, then you can disregard these.