Troubleshooting
Problem
PureScale database using Tivoli Storage Manager (TSM) to manage the logs returns the following error:
db2 rollforward database sample to end of logs and complete SQL1273N An operation reading the logs on database "SAMPLE" cannot continue because of a missing log file "S0000000.LOG" on database partition "0" and log stream "2".
Cause
Each PureScale member is unable to see log files belonging to other PureScale members.
Environment
PureScale
Diagnosing The Problem
Each PureScale member is unable to see log files belonging to other PureScale members. Verify by running db2adutl from each member:
For example, from below output each member sees only its own "Log stream".
Member 1:
$ db2adutl query logs db sample Query for database SAMPLE
Retrieving LOG ARCHIVE information. Log file: S0000000.LOG, Chain Num: 0, Log stream: 1, Taken at: 2018-11-01-10.47.54 Log file: S0000001.LOG, Chain Num: 0, Log stream: 1, Taken at: 2018-11-01-10.48.22
Member 2:
$ db2adutl query logs db sample Query for database SAMPLE Retrieving LOG ARCHIVE information. Log file: S0000000.LOG, Chain Num: 0, Log stream: 2, Taken at: 2018-11-01-10.01.35 Log file: S0000001.LOG, Chain Num: 0, Log stream: 2, Taken at: 2018-11-01-10.02.14
Check the output to see if they only see logs belonging to the member where it was run, or if it shows logs from all members.
Resolving The Problem
Configure proxy node in TSM by following
Configuring a Tivoli Storage Management client
.
"If you want to use TSM in your Db2 pureScale® environment, proxy node configurations are recommended because each member can be represented as a TSM client or node and be mapped to a common proxy node"
Another alternative is to restore a database and NOT rollforward the logs.
Related Information
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"PureScale","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
21 January 2019
UID
ibm10796114