"zeb nest" <ka******@tiscali.fr> wrote in
news:ci**********@news.tiscali.fr:
First, thanks...I really appreciate any thoughts you might have.
Do you have another error messages in the db2diag.log ?
Yes, please see below
the answer of the ulimit command : are you using the userid of the
instance owner ?
Yes
? do you have a db2 list tablespaces show detail before the restore ?
Yes, this is the tablespace in question of the database being restored
Tablespace ID = 5
Name = TBS_IDX
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1000000
Useable pages = 999808
Used pages = 604864
Free pages = 394944
High water mark (pages) = 910720
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 128
Number of containers = 4
Minimum recovery time = 2004-09-10-12.49.31.000000
do you have a db2 list tablespace containers for x before the restore
Yes
Tablespace Containers for Tablespace 5
Container ID = 0
Name = /db2idx/scioltpt/baseidx/sieb01
_idx.dat
Type = File
Container ID = 1
Name = /db2idx/scioltpt/baseidx/sieb02
_idx.dat
Type = File
Container ID = 2
Name = /db2idx/scioltpt/baseidx/sieb03
_idx.dat
Type = File
Container ID = 3
Name = /db2idx/scioltpt/baseidx/sieb04
_idx.dat
Type = File
This is the way the containers are defined in the restore script
set tablespace containers for 5 using
(File '/siebel/db2/instance/siebdev/idx/siebts01_idx4k.dat' 250000,
File '/siebel/db2/instance/siebdev/idx/siebts02_idx4k.dat' 250000,
File '/siebel/db2/instance/siebdev/idx/siebts03_idx4k.dat' 250000,
File '/siebel/db2/instance/siebdev/idx/siebts04_idx4k.dat' 250000)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
here are the entries from the db2diag.log when the redirected restore
script is started. I don't know if the unexpected end of file is typical
of entries for a redirected restore.
2004-09-12-10.07.59.075466 Instance:siebdev Node:000
PID:58916(db2agent (SIEBEL) 0) TID:1 Appid:
*LOCAL.siebdev.00EB32140759
buffer pool services sqlbReadBufferPoolTable Probe:905
DIA8506C Unexpected end of file was reached.
ZRC=0x870F0009
Immediately after that entry, I get many, many repeated entries of
ZRC=0xFFFFFBA1 This translates to SQL1119 The restore utility is most
definitely terminated before the restore..to the point where I have been
restarting db2 between runs, so I don't understand this message.
SQL1119N A connection to or activation of database "<name>" cannot be
made because a previous restore is incomplete.
Explanation: The database is in an inconsistent state because a system
error occurred during a restore function.
No connection was made.
Federated system users: this situation can be detected by the data
source.
User Response: Issue the RESTORE command and then try the command again.
2004-09-12-10.07.59.298834 Instance:siebdev Node:000
PID:58916(db2agent (SIEBEL) 0) TID:1 Appid:
*LOCAL.siebdev.00EB32140759
buffer pool services sqlbinit Probe:620
Database will come up with hidden buffer pools.
totalBufferPoolPages: 0000 0000 0000 0040
........@
2004-09-12-10.07.59.366280 Instance:siebdev Node:000
PID:58916(db2agent (SIEBEL) 0) TID:1 Appid:
*LOCAL.siebdev.00EB32140759
database utilities sqludPrintStartingMsg Probe:1 Database:SIEBEL
Starting a full database restore.
Agent PID: 58916
2004-09-12-10.07.59.823955 Instance:siebdev Node:000
PID:78808(db2bm.58916.0 0) TID:1 Appid:none
database utilities sqludProcessHistoryFile Probe:3
An empty database history has been detected.
The database history will be overwritten by the backup image.
2004-09-12-10.11.41.039258 Instance:siebdev Node:000
PID:21150(db2agent (SIEBEL) 0) TID:1 Appid:
*LOCAL.siebdev.040912141141
base sys utilities sqleCheckForBackupRestore Probe:10
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBA1".
2004-09-12-10.11.41.081622 Instance:siebdev Node:000
PID:21150(db2agent (SIEBEL) 0) TID:1 Appid:
*LOCAL.siebdev.040912141141
base sys utilities sqlePrepareForSerialization Probe:20
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBA1".
Could these be referring to the image copy of the database?
Also, I am wondering if large file enabling is set on the target system.