As for as I know you can't restore a single table unless you have taken
a Export from the Table and have a File kept before dropping the table.
And I guess you can either use the Recovery YES option but it will make
thing's a complicated.
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: Som_Kundu
[mailto:db2udbdba-ezmlmshield-x84857977.[Email address protected]
Sent: Tuesday, February 19, 2008 6:15 PM
To: LazyDBA Discussion
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
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