The DELETE command will create a log entry. Therefore, increase the
number of log files. If that don't work, run a couple of "delete" batch
transactions. Unfortunately, there is a limit when it comes to hardware
and software.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Dharmesh Kumar D. Bajpai
[mailto:db2udbdba-ezmlmshield-x38937546.[Email address protected]
Sent: Wednesday, June 27, 2007 9:28 AM
To: LazyDBA Discussion
Subject: Truncate command required (it should be a logged operation)
***********************
Your mail has been scanned by InterScan.
***********-***********
Dear All,
Dear all, though I had received couple of replies related to
truncate command. But it seems that these are non-logged operations and
hence will not reflect in my stand by site.
Request you all to kindly help me out with a DB2 truncate level
command which will be a logged operation. Also kindly let me know is
there any risk in using the same.
Thanks and regards
Dharmesh B
-----Original Message-----
From: Saiprasad_Parthasarathy
[mailto:db2udbdba-ezmlmshield-x16081335.[Email address protected]
Sent: Friday, June 22, 2007 10:51 AM
To: LazyDBA Discussion
Subject: RE: Truncate equivalent of Oracle required in DB2
***********************
Your mail has been scanned by InterScan.
***********-***********
Hi Dharmesh,
Try with this.
IMPORT FROM /dev/null OF DEL REPLACE INTO <table name>
Sai
-----Original Message-----
From: Dharmesh Kumar D. Bajpai
[mailto:db2udbdba-ezmlmshield-x73308630.[Email address protected]
Sent: Friday, June 22, 2007 10:30 AM
To: LazyDBA Discussion
Subject: Truncate equivalent of Oracle required in DB2
***********************
Your mail has been scanned by InterScan.
***********-***********
Dear All,
Kindly let me know 'truncate' equivalent of Oracle in DB2.
Regards
Dharmesh B
************************************************************************
***********
This message is for the named addressees' use only. It may contain NSDL
confidential, proprietary or legally privileged information. If you
receive
this message in error, please immediately delete it. You must not,
directly
or indirectly, use, disclose, distribute, print, or copy any part of
this message
if you are not the intended recipient.Unless otherwise stated, any
commercial
information given in this message does not constitute an offer to deal
on
any terms quoted. Any reference to the terms of executed transactions
should be treated as preliminary only and subject to our formal written
confirmation.
************************************************************************
***********
---------------------------------------------------------------------
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
************************************************************************
***********
This message is for the named addressees' use only. It may contain NSDL
confidential, proprietary or legally privileged information. If you
receive
this message in error, please immediately delete it. You must not,
directly
or indirectly, use, disclose, distribute, print, or copy any part of
this message
if you are not the intended recipient.Unless otherwise stated, any
commercial
information given in this message does not constitute an offer to deal
on
any terms quoted. Any reference to the terms of executed transactions
should be treated as preliminary only and subject to our formal written
confirmation.
************************************************************************
***********
---------------------------------------------------------------------
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