IBM Support

Error message: DBT1008N executing db2inidb command after split mirror.

Troubleshooting


Problem

Error message: DBT1008N executing db2inidb command after split mirror using a DB2 ACS snapshot.

Symptom

DB2® Advanced Copy Services (ACS) enables you to use the fast copying technology of a storage device to perform the data copying part of backup and restore operations.

In a traditional backup or restore operation, the database manager copies data to or from disk or a storage device using operating system calls. Being able to use the storage device to perform the data copying makes the backup and restore operations much faster. A backup operation that uses DB2 ACS is called a 'snapshot backup'.

The following steps will result in: "DBT1008N" if you try to initialise the target database with db2inidb as a 'snapshot' if you have used the DB2 ACS scripted interface to backup the database:

1) Backup the target database:
db2 "backup database SAMPLE online USE SNAPSHOT SCRIPT <path to ACS script>"

2) The SAMPLE database disks and filesystems will be flashcopied to the target flashcopy disks using the ACS scripted interface.

See: "Related URL" section.

3) Clone the target server:


a) Mount the flash target disks from step 2)
b) Verify the contents of all key DB2 filesystems.
c) Then run: db2inidb SAMPLE as snapshot

The db2inidb command will fail with: "DBT1008N Database "SAMPLE " is not a split mirror image."

Cause

This failure occurs because if you use the DB2 ACS scripted interface to backup the database you must use a: db2 "restore db use snapshot" command to restore it.

See: "Related URL" section.

Resolving The Problem

Use a restore command and not db2inidb:

db2 "restore db SAMPLE use snapshot"


db2inidb can be used as long as you use: db2inidb SAMPLE as acs standby

This should avoid the DBT1008N message. However, this may not meet your requirements so a restore is the recommended approach.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - Cluster Management","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21986237