Alter table not logged initially

by on September 23, 2009

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}”;

Leave a Comment

Previous post:

Next post: