Ok what am I doing wrong:
# db2adutl query
[...]
Query for database TSMTEST
Retrieving FULL DATABASE BACKUP information.
1 Time: 20030424140412 Oldest log: S0000000.LOG Node: 0 Sessions: 1
2 Time: 20030423090141 Oldest log: S0000000.LOG Node: 0 Sessions: 1
3 Time: 20030423085934 Oldest log: S0000000.LOG Node: 0 Sessions: 1
4 Time: 20030422094132 Oldest log: S0000000.LOG Node: 0 Sessions: 1
Retrieving INCREMENTAL DATABASE BACKUP information.
1 Time: 20030424142104 Oldest log: S0000000.LOG Node: 0 Sessions: 1
2 Time: 20030423090226 Oldest log: S0000000.LOG Node: 0 Sessions: 1
3 Time: 20030423090206 Oldest log: S0000000.LOG Node: 0 Sessions: 1
[...]
# db2 restore db tsmtest use tsm taken at 20030424140412 without rolling forward
SQL2576N Tablespace "SYSCATSPACE" is being restored as part of an incremental
RESTORE operation, but the RESTORE command did not specify the INCREMENTAL
clause.
# db2 restore db tsmtest incremental use tsm taken at 20030424142104 without rolling forward
SQL2537N Roll-forward is required following the Restore.
# db2 rollforward db tsmtest complete
SQL1119N A connection to or activation of database "TSMTEST" cannot be made
because a previous restore is incomplete. SQLSTATE=57019
Cheers
Henrik Morsing
Certified AIX 4.3 Systems Administration
& p690 Technical Support