Re: Dsmserv format/loadformat problem

While we are on the subject of a loadformat/loaddb -

Has anyone actually done this with a larger Tsm DB?
Ours is 32Gig and the loaddb has been running for
more than 20 hours.

The unload took just over an hour - this seems a
bit like an overkill when the db is being reloaded.

Cheers
Christo

> That's correct....
> This below is my log...
> 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.
> ANR0300I Recovery log format started; assigned capacity 2000 megabytes.
> ANR0301I Recovery log format in progress; 4 megabytes of 2000.
> ANR0301I Recovery log format in progress; 8 megabytes of 2000.
> ANR0301I Recovery log format in progress; 12 megabytes of 2000.
> ANR0301I Recovery log format in progress; 16 megabytes of 2000.
> ANR0301I Recovery log format in progress; 20 megabytes of 2000.
> ANR0301I Recovery log format in progress; 24 megabytes of 2000.
> ...
> ...
> ...
>
> ANR0301I Recovery log format in progress; 1984 megabytes of 2000.
> ANR0301I Recovery log format in progress; 1988 megabytes of 2000.
> ANR0301I Recovery log format in progress; 1992 megabytes of 2000.
> ANR0301I Recovery log format in progress; 1996 megabytes of 2000.
> ANR0301I Recovery log format in progress; 2000 megabytes of 2000.
> ANR0302I Recovery log formatting took 302143 milliseconds.
> ANR0303I Format rate:  1694.6 pages/second.
> ANR0304I Page service time:     0.6 ms.
> ANR0305I Recovery log format complete.
> ANR0306I Recovery log volume mount in progress.
> ANR0353I Recovery log analysis pass in progress.
> ANR0354I Recovery log redo pass in progress.
> ANR0355I Recovery log undo pass in progress.
> ANR0352I Transaction recovery complete.
> ANR1004I Server formatting complete, database ready for loading.
> ANR7800I DSMSERV generated at 08:47:38 on May 22 2001.
>
>         After this you can continue with loaddb.....
>         Hope this help...
>
> 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 : T.chintawongvanich AT shell DOT com
> *Group EMail : ITS_AsiaPacific AT ssi.shell.com DOT my
>
> -----Original Message-----
> From: rouzen AT univ.haifa.ac DOT il [mailto:rouzen AT univ.haifa.ac DOT il]
> Sent: Monday, October 08, 2001 6:22 AM
> To: Chintawongvanich, Thida T SITI-ISPS/31
> Subject: FW: Dsmserv format/loadformat problem
>
>  Hi Thida
>
> The problem is I didn't received any error but when I run:
>   Dsmserv loadformat x log1 log2...logx y db1 db2 db3 ....dbY
> Theprocess did the log's only and give me my prompt again without any errors
> or comments just ignore the y db1 db2 db3 .....dbY
>
> Thanks Robert
>
> -----Original Message-----
> From: Thida Chin
> To: ADSM-L AT VM.MARIST DOT EDU
> Sent: 07/10/2001 18:53 PM
> Subject: Re: Dsmserv format/loadformat problem
>
> Hi Robert,
>
>
> You can run loadformat by the same syntax as what you run in dsmserv
> format....
> Dsmserv loadformat x log1 log2...logx y db1 db2 db3 ....dbY
> You mention like you got error from loadformat? Which error?
>
> From my experience
> If you want to use dsmserv loaddb need to use dsmserv loadformat as well
> If you want to use dsmserv restoredb then you can use dsmserv format...
> And it correct that it will seems like only format your log not db..but
> actually it do all for you....also will make your dsmserv.dsk change as
> what
> you set format( x log and y db)
> Loadb the configure of db an log no need to be the same (e.g source is 5
> dbs
> 4logs, target can be 1 db 1 log, just need enough space)
> Restoredb all configure need to be the same both number of log/db and
> size
> of each log/db.
> Hope this help...
>
> 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 : T.chintawongvanich AT shell DOT com
> *Group EMail : ITS_AsiaPacific AT ssi.shell.com DOT my
>
> -----Original Message-----
> From: Robert Ouzen [mailto:rouzen AT UNIV.HAIFA.AC DOT IL]
> Sent: Sunday, October 07, 2001 6:49 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Dsmserv format/loadformat problem
>
> Hi
>
> My TSM version is 3.7.4 I tried to run a dsmserv loadformat but got an
> syntax error message instead I run dsmserv format successfully.
>
> My command was: DSMSERV FORMAT 2 /lgaa1dk2/lg /lgaa1dk2/lg1 4
> /dbaa1dk2/db
> /dbaa1dk3/db /dbaa1dk10/db /dbaa1dk11/db
>
> The process of the log format run successfully and didn't continue to
> the db
> format process ( 4 volumes ...) without any further comments.
>
> When trying to continue with the dsmserv loaddb I occur an error message
> that the database need to be initialized before.
>
> Any suggestion why the format of database didn't started !!!!!!
>
> T.I.A Regards Robert
> E-Mail: rouzen AT univ.haifa.ac DOT il

______________________________________________
"The information contained in this communication is confidential and
may be legally privileged.  It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it.  If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action
in reliance of the contents of this information is strictly prohibited
and may be unlawful.  Absa is neither liable for the proper, complete
transmission of the information contained in this communication, any
delay in its receipt or that the mail is virus-free."