Prev: License problems (and coredump) after Fixpack
Next: Db2 going down frequently
From: sandeep.iitk on 19 Dec 2008 16:55
Hi,
on one of my dev server is giving following error when i am trying to
get the db size

> db2 'call get_dbsize_info(?,?,?,1)'
SQL0443N Routine "*IZE_INFO" (specific name "") has returned an error
SQLSTATE with diagnostic text "SQL0444 Reason code or token:
*TAMPDIFF,
SQL020422182517115". SQLSTATE=38553

while the above command is working fine on PROD.
As a background, i just restored the backup image of PROD on DEV and
created a new db with prod image.
I used following 3 commands/steps to do it (might be helpful):-

(1)db2 -v restore database prddb from <backupimagelocation> to
<installdir>into devdb newlogpath <logdir> redirect without rolling
forward

(2) setting up containers

(3) db2 -v restore database prddb continue

IS SOMETHING LIKE REBIND IS NECESSARY. please help

Thanks and Regards
sandy
 | 
Pages: 1
Prev: License problems (and coredump) after Fixpack
Next: Db2 going down frequently