Hi,
I've done as you all recommended..
dsmserv unloaddb devc=devc_backupdb
(it was backup to /local/export as in devc_backupdb and it generate file
name by itself...which I need to get from unix level for load command)
dsmserv loadformat 1 /local/dat01/adsm.new/logvol01 1
/local/dat00/adsm.new/dbvol01
dsmserv loaddb devc=devc_backupdb vol=/local/export/02270763.dmp (if didn't
put the vol=... it can't loaddb..error show needs to put )
But I've got error ( not sure error or warning) as shown below...Is this ok?
I unload from a lot of dbvol and logvol then load to a big dbvol and
logvol...
And another question is why dumpdb doesn't work.. even I dsmfmt the
newdb to be biggersize(from 33xx to 45xx)during that time it still show that
92% reach...94%...96...98%.... Then fail....which the data entries just not
half way yet..but now I dsmfmt only 3500 and it's seems to be ok...
Can anybody explain this. please?...
UNLOADDB
ANR4013I UNLOADDB: Dumped 13378806 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 13622000 database entries (cumulative).
ANR4013I UNLOADDB: Dumped 13911450 database entries (cumulative).
ANR9999D sminit.c(509): ThreadId<24> SM Failed to Initialize - Time Out.
ANR9999D mmsshr.c(340): ThreadId<24> Timed out waiting for session manager
initialization.
ANR4402I UNLOADDB: Database update activity resumed
ANR1361I Output volume /local/export/02270763.DMP closed.
ANR4031I UNLOADDB: Copied 510955 database pages.
ANR4033I UNLOADDB: Copied 0 bit vectors.
ANR4034I UNLOADDB: Encountered 0 bad database pages.
ANR4036I UNLOADDB: Copied 20352459 database entries.
ANR4037I UNLOADDB: 1256 Megabytes copied.
ANR4026I UNLOADDB: Process 0, database dump has completed.
ANR4006I UNLOADDB: Volume 1 written by process is
/local/export/02270763.DMP.
ANR7800I DSMSERV generated at 08:47:38 on May 22 2001.
LOADDB
ANR4039I LOADDB: Loaded 19410643 database entries (cumulative).
ANR4039I LOADDB: Loaded 19756329 database entries (cumulative).
ANR4039I LOADDB: Loaded 20099875 database entries (cumulative).
ANR1365I Volume /local/export/02270763.dmp closed (end reached).
ANR9999D pspvrfio.c(446): ThreadId<17> Error 9 flushing FILE volume .
ANR9999D pvrfil64.c(1064): ThreadId<17> Error 30 flushing FILE volume
/local/export/02270763.dmp.
ANR4039I LOADDB: Loaded 20352459 database entries (cumulative).
ANR4032I LOADDB: Copied 510935 database records.
ANR4033I LOADDB: Copied 0 bit vectors.
ANR4035I LOADDB: Encountered 0 bad database records.
ANR4036I LOADDB: Copied 20352459 database entries.
ANR4037I LOADDB: 1256 Megabytes copied.
ANR4004I LOADDB: Database load process completed.
ANR4404I LOADDB: Loaded a consistent dump image - a database audit (AUDITDB)
is NOT required.
ANR2106I : Quiescing database update activity.
ANR2107I : Database update activity is now quiesced.
regards,
Thida Chintawongvanich
SAP Infrastructure Support Team (SITI-ISPS/31)
Shell Information Technology International Sdn., Bhd.
___________________________________________________________
2340 Century Square
Jln Ushawan 63000 Cyberjaya, Kuala Lumpur, Malaysia
(Tel : +603 8313 3446 : Fax : +603 251 2788 )
*Personal EMail : [EMAIL PROTECTED]
*Group EMail : [EMAIL PROTECTED]
-----Original Message-----
From: Pothula S Paparao [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 10:07 AM
To: [EMAIL PROTECTED]
Subject: Re: Error on UNLOADDB process
Hi robert,
Are u using Shared - library or mannual ? however, if u try creating
sequetial device class 'FILE' in disk and try to unload db using the said
device class , you may find the unloaddb may not distrub you any more. try
doing this.
-------------------
1)define a device class - FILE type
2) dsmserv unloaddb devclass=????????
3) dsmserv loadformat 1 logfile 1 dbfile
4) dsmserv loaddb devclass=?????????
make sure that you have volhistory file backedup before doing this.
Hope this helps
regards
sreekumar.
Robert Ouzen <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 10/04/2001
18:24:10
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Error on UNLOADDB process
Hi to all
I run a dsmserv unloaddb devclass=scalarclass scratch=yes and received this
message:
ANR4013I UNLOADDB: Dumped 7324392 database entries (cumulative).
ANR9999D sminit.c(440): SM failed to Initialize - Time Out.
ANR9999D mmsshr.c(301): Time Out waiting for session manager
initialization.
ANR1361I Output volume 000029 closed.
ANR4013I UNLOADDB: Copied 807684 database pages.
ANR4013I UNLOADDB: Copied 728 bit vectors.
ANR4013I UNLOADDB: Encountered 0 bad database pages.
ANR4013I UNLOADDB: Copied 31351842 database entries.
ANR4013I UNLOADDB: 2011 Megabytes copied.
ANR4013I UNLOADDB: Process 0, database dump has completed.
ANR4013I UNLOADDB: database update activity resumed.
ANR4013I UNLOADDB: Volume 1 written by process is 000029.
Did the UNLOADDB process really succeed even though we got ANR9999D
message ????. And the VOLHIST.FILE was corrupted at the end of the process
we didn't get any information about the DBDUMP volume. We had before the
process a database size of 830,593 database pages and 3643392 database
entries.
We didn't continue with dsmserv loadformat just return to the original
database.
Does anybody have an experience with this problem.
T.I.A Robert Ouzen
E-Mail: [EMAIL PROTECTED]
