Hi all,
I�ve problems with dumpdb and loaddb
I have so many dbvol and so many log vol and wanted to make it to be only
one dbvol and one logvol
My dbsize is 3304M which actually use only 67.1% of it
My logsize is 824 which also use less�
I�ve create newdbvol 3500M and logvol 1200M
Got error as below�
It�s seems like dbvol that I�ve assigned is not big enough..Hmm�. but
previous 33xx to be 3500 still not enough?
Anybody know, please kindly help!!!!
ANR4039I LOADDB: Loaded 7100934 database entries
(cumulative).
ANR0362W Database usage exceeds 96 %% of its assigned
capacity.
ANR4039I LOADDB: Loaded 7198164 database entries
(cumulative).
ANR0362W Database usage exceeds 98 %% of its assigned
capacity.
ANR0102E dlload.c(1824): Error 4 inserting row in table
"BF.Super.Bitfiles".
ANR0102E dlload.c(1824): Error 4 inserting row in table
"Backup.Objects".
ANR0102E dlload.c(1824): Error 4 inserting row in table
"Expiring.Objects".
ANR0102E dlload.c(1824): Error 4 inserting row in table
"Object.Ids".
ANR4039I LOADDB: Loaded 7263493 database entries
(cumulative).
ANR4039I LOADDB: Loaded 7263493 database entries
(cumulative).
ANR4039I LOADDB: Loaded 7263493 database entries
(cumulative).
(from dumpdb)
ANR4013I DUMPDB: Dumped 19880824 database entries (cumulative).
ANR1361I Output volume /local/export/051001.dmp closed.
ANR4031I DUMPDB: Copied 553474 database pages.
ANR4033I DUMPDB: Copied 0 bit vectors.
ANR4034I DUMPDB: Encountered 0 bad database pages.
ANR4036I DUMPDB: Copied 22167794 database entries.
TSM:CBJ0008_TSM> q db
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY DB
Available Assigned Maximum Maximum Page Total
Used Pct Max.
Space Capacity Extension Reduction Size Usable
Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages
Util
--------- -------- --------- --------- ------- ---------
---------
--------- ----- -----
--------- ----- -----
3,304 3,304 0 52 4,096 3,304
3,304 0 52 4,096 845,824
567,738 67.1 67.1
TSM:CBJ0008_TSM> q log
ANR2017I Administrator SERVER_CONSOLE issued command: QUERY LOG
Available Assigned Maximum Maximum Page Total
Used Pct Max.
Space Capacity Extension Reduction Size Usable
Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages
Util
--------- -------- --------- --------- ------- ---------
---------
--------- ----- -----
--------- ----- -----
824 824 0 820 4,096 824
824 0 820 4,096 210,432
196 0.1 0.1
root@cbj0008 # dsmserv dumpdb devc=devc_backupdb
vol=/local/export/051001.dmp
ANR7800I DSMSERV generated at 08:47:38 on May 22 2001.
Tivoli Storage Manager for AIX-RS/6000
Version 4, Release 2, Level 0.0
Licensed Materials - Property of IBM
5698-TSM (C) Copyright IBM Corporation 1999,2001. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR0900I Processing options file dsmserv.opt.
ANR0990I Server restart-recovery in progress.
ANR0200I Recovery log assigned capacity is 824 megabytes.
ANR0201I Database assigned capacity is 3304 megabytes.
ANR4000I DUMPDB: Database dump process started.
ANR8340I FILE volume /local/export/051001.dmp mounted.
ANR1360I Output volume /local/export/051001.dmp opened (sequence number 1).
ANR4013I DUMPDB: Dumped 4182608 database entries (cumulative).
ANR4013I DUMPDB: Dumped 9698943 database entries (cumulative).
ANR4013I DUMPDB: Dumped 14331333 database entries (cumulative).
ANR4013I DUMPDB: Dumped 19880824 database entries (cumulative).
ANR1361I Output volume /local/export/051001.dmp closed.
ANR4031I DUMPDB: Copied 553474 database pages.
ANR4033I DUMPDB: Copied 0 bit vectors.
ANR4034I DUMPDB: Encountered 0 bad database pages.
ANR4036I DUMPDB: Copied 22167794 database entries.
ANR4037I DUMPDB: 1368 Megabytes copied.
ANR4001I DUMPDB: Database dump process completed.
|
