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