Here is a little code that descripts the usage of "alter table not logged initially"
db2 "connect to SAMPLE";
DB2CMD1="alter table SAMPLE.employee activate not logged initially"
DB2CMD2="INSERT INTO SAMPLE.employee values(,,,,,,,,,,)"
DB2CMD3="commit"
db2 +c -tv "${DB2CMD1}"; db2 "${DB2CMD2}"; db2 "${DB2CMD3}";
Wednesday, September 23, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment