Kevin,
The Number you specify when doing set table space is for the no of pages
need( Minimum) for the restore utility to complete. And for the second
question it is HWM ( HIGH WATER MARK ) number you have to take not the
total pages , normally take a 100 or more pages what is there currently
for a table space HWM say you have HWM as 1000 then use the set table
space container command with say 1200 or more to make sure that there
are no surprise alerts and restore gets aborted if they are less number
of pages which you declare.
Hope it clears , actually if you're restoring from a net backup you
don't need specify the set table space containers command are you doing
a REDIRECT RESTORE or just a Restore from PROD to DEV?
Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
>*:vishnuvardan.[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.
-----Original Message-----
From: Kevin_Corcoran
[mailto:db2udbdba-ezmlmshield-x46015222.[Email address protected]
Sent: Wednesday, January 30, 2008 10:29 AM
To: LazyDBA Discussion
Subject: SET TABLESPACE CONTAINERS QUESTION
Sorry if this questions sounds simple but I'm new to UDB.
I'm running UDB 8.2 on Solaris 5.10
I'm doing an 'alternate restore' in netbackup terms - in reality
restoring a Prod backup into a test environment.
My questions are:
1. Why do I have to specify a size when I do the "set tablespace
containers" command for DMS tablespaces? Surely during a restore this
file/container will just be overwritten by backed up blocks and so
preformatting is just wasted time?
2. (and this, I suppose, follows on) When specifying the number of pages
do I have to specify the Total page size of the source
tablepsace/container or can I use the Used pages value
TIA
************************************************************************
**********
The information contained in or attached to this message is intended
only for the people it is addressed to. If you are not the intended
recipient, any use, disclosure or copying of this information is
unauthorised and prohibited. This information may be confidential or
subject to legal privilege.
It is not the expressed view of Medibank Private Limited or any of its
subsidiaries unless it is authorised by a person with actual authority.
To the fullest extent allowed by law, Medibank Private cannot accept
liability for any virus damage caused by this message.
Medibank Private Limited ABN 47 080 890 259.
************************************************************************
***********
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Please do not print this email unless it is absolutely necessary. Spread environmental awareness.
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
DB2 & UDB email list listserv db2-l LazyDBA home page