From V8 UDB LUW, dropped table recovery ON has been the default for REGULAR
tablespaces. So it depends when and how the tablespace was created. You may
be in luck and be able to use the RECOVER DROPPED TABLE option of the
ROLLFORWARD DB command - check the entry on syscat.tablespaces to see if
it's regular (DATATYPE = 'A') and table-recoverable (DROP_RECOVERY = 'Y').
If this won't hack it for you, the following series of steps will (assuming
you can get the downtime):
a. back up current database offline
b. restore image with the undropped table and rollforward to a PIT before
the drop.
c. db2look the table and all dependent objects, export the data
d. restore the a. backup
e. run the db2look and load/import
Regards
Alex Levy
Sustainable Software Ltd.
-----Original Message-----
From: PANGJ [mailto:db2udbdba-ezmlmshield-x81032167.[Email address protected]
Sent: 19 February 2008 13:43
To: LazyDBA Discussion
Subject: Re: How To Restore Table in UDB
You can restore the tablespace that contains your dropped table from the
database level backup.
RESTORE DATABASE source-database-alias { restore-options | CONTINUE | ABORT
}
restore-options:
[USER username [USING password]] [TABLESPACE [ONLINE] |
TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |
HISTORY FILE [ONLINE] | LOGS [ONLINE] | COMPRESSION LIBRARY [ONLINE]]
[INCREMENTAL [AUTOMATIC | ABORT]] [USE {TSM | XBSA} [OPEN num-sess
SESSIONS]
[OPTIONS {options-string | options-filename}] |
FROM dir/dev [{,dir/dev} ... ] | LOAD shared-lib [OPEN num-sess SESSIONS]
[OPTIONS {options-string | options-filename}]] [TAKEN AT date-time]
[[TO target-directory] | [ON path[{,path}...][DBPATH ON path]]]
[INTO target-database-alias] [LOGTARGET directory]
[NEWLOGPATH directory] [WITH num-buff BUFFERS] [BUFFER buffer-size]
[DLREPORT file-name] [REPLACE HISTORY FILE] [REPLACE EXISTING] [REDIRECT]
[PARALLELISM n] [COMPRLIB lib-name] [COMPROPTS options-string]
[WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]
Thanks,
Jenny
"Som_Kundu " <db2udbdba-ezmlmshield-x84857977.[Email address protected]
02/19/2008 07:44 AM
From
"Som_Kundu " <db2udbdba-ezmlmshield-x84857977.[Email address protected] To
"LazyDBA Discussion" <[Email address protected] cc
Subject
How To Restore Table in UDB
Hi All,
Is it possible to restore a table in DB2-UDB after I have dropped it??
I had taken a database level backup sometime ago. Can I use that backup to
restore my table??
If not then what is the method to restore a dropped table?
Thanks & Regards
Som Subhro Kundu
HCU Enterprise Applications
EA - ESO - DBA Services
Satyam Computer Services Limited
Hyderabad
Work : (+91) 40 30636089
Cell : (+91) 9703242200
-----Original Message-----
From: Raghunandan [mailto:db2udbdba-ezmlmshield-x57083152.[Email address
protected]
Sent: Tuesday, February 05, 2008 10:56 AM
To: LazyDBA Discussion
Subject: connecting to db2 instance with blank(null) password
Dear All,
How to connect to a db2 instance that has blank password.
I have an instance db2inst1 and the instance password is changed to blank
using the command "passwd db2inst1"
I'm issuing the command "db2 attach to db2inst1 user db2inst1"
This command is prompting for password and if I press enter, it is not
accepting blank and gives the error password missing.
Please let me know how to solve this issue
Regards
Raghu
*****************************************************************
This e-mail and its attachments contain confidential information from
HUAWEI, which is intended only for the person or entity whose address is
listed above. Any use of the information contained herein in any way
(including, but not limited to, total or partial disclosure, reproduction,
or dissemination) by persons other than the intended recipient(s) is
prohibited. If you receive this e-mail in error, please notify the sender by
phone or email immediately and delete it!
*****************************************************************
---------------------------------------------------------------------
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
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page