Backup PTDB before UTS conversion
Article ID: 370617
Updated On:
Products
Issue/Introduction
The following is noted in the Holddata for PTF LU09809:
Note: The best practice is to avoid using the Recover option in the
conversion process. The Recover option is based on UNLOAD/LOAD and
may affect the availability of objects even in online migration.
If you encounter a problem, do not attempt to convert already
migrated objects to their prior state. Try to fix the problem and
continue with the conversion. For assistance, contact Broadcom
Support.
Is it recommended to take a backup of the PTDB database prior to the UTS conversion?
Resolution
It is strongly recommended to take image copies of the PTDB Tablespaces and also record the internal object IDs before starting the conversion process. This is helpful if there is a need to use DSN1COPY to recover any objects.
As the recovery process using this backup is not straightforward, it is recommended that you reach out to Broadcom Support if you encounter any problems. It is preferable to address these problems and continue with the conversion rather than trying to recover the database.
If you are planning to install the UTS conversion maintenance (PTFs LU09808 to LU09819), please contact Broadcom Support so that the environment can be checked and prepared ahead of the conversion.
Additional Information
The following query can be used to record the internal object IDs prior to the process, to assist with any potential DSN1COPY disaster recovery:
SELECT TS.DBNAME, TS.NAME AS TS_NAME,
DATE(TS.CREATEDTS) AS CREATED_DATE,
TS.DBID, TS.PSID, T.NAME AS TABLE_NAMES, T.OBID AS TABLE_OBID,
CASE
WHEN TS.TYPE IN (' ','L') AND TS.SEGSIZE=0 AND TS.NTABLES=1
THEN 'SIMPLE'
WHEN TS.TYPE IN (' ','L') AND TS.SEGSIZE>0 THEN 'SEGMENTED'
WHEN TS.TYPE IN (' ','L') AND TS.PARTITIONS>0
THEN 'CLASSIC PARTITIONED'
WHEN TS.TYPE IN ('O') THEN 'LOB'
WHEN TS.TYPE IN ('G') AND TS.SEGSIZE>0 AND TS.NTABLES=1 AND
TS.MAXPARTITIONS>0 AND TS.PARTITIONS=1 THEN 'PBG'
WHEN TS.TYPE IN ('R') AND TS.SEGSIZE>0 AND TS.NTABLES=1 AND
TS.MAXPARTITIONS=0 AND TS.PARTITIONS>=1 THEN 'PBR'
END AS TYPE,
CASE
WHEN TS.NTABLES>1 THEN 'MULTI-TABLE'
ELSE ' '
END AS NUM_TABLES
FROM SYSIBM.SYSTABLESPACE TS, SYSIBM.SYSTABLES T
WHERE TS.DBNAME = '<Db2-Tools-DB>' AND
TS.NAME = T.TSNAME;
replacing <Db2-Tools-DB> with the database name; for example PTDB.
Feedback
