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
DB2 & UDB email list listserv db2-l LazyDBA home page