Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Regarding database Size

 
   Database Help (Home) -> DB2 RSS
Next:  PHP memory usage  
Author Message
sandeep.iitk

External


Since: Aug 24, 2008
Posts: 20



(Msg. 1) Posted: Fri Dec 19, 2008 1:55 pm
Post subject: Regarding database Size
Archived from groups: comp>databases>ibm-db2 (more info?)

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

 >> Stay informed about: Regarding database Size 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Size of a DB2 database - Hi all, Is there any way to determine the size of a DB2 database without using list tablespaces? I am working on db2 udb 8.2 fp12 on LUW Thanks

Is there anything else to gather database size info? - Hi folks, My database DB03 is circular logging. I called the db2 procedure: get_dbsize_info to get the database size as below: Parameter Name : SNAPSHOTTIMESTAMP Parameter Value : 2008-04-08-06.39.49.518070 Parameter Name : DATABASESIZE ..

db2 size and performance - Hi: We have a database made with Java. The format of the database is the same to DB2. We are concerned about the performance when the database size growing. Our computer configuration is: windows XP, 512M RAM, Intel P3. Could anybody tell how big a..

Table size in bytes - Hi! How can I see the actual size of a table is bytes? I could to a count on table and multiply by page size, but we are using VARCHARs and I'm affraid that is not the correct value. I could also find the file that a table is stored in, but I don't know...

size of numeric data - My DBA says that a column defined, for instance, as DECIMAL(11,2) and containing a value of 1.00 takes up no more space on the database disk than a column defined as DECIMAL(7,2) and containing a value of 1.00. I am honestly having a hard time believing...
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]