Question & Answer
Question
How can I find out if a table was initially created using the "NOT LOGGED INITIALLY" option?
Answer
In DB2 V8.1 the LOG_ATTRIBUTE column in the SYSCAT.TABLES table was used to check if a table was created as NOT LOGGED INITIALLY. In DB2 V9.x this column is no longer being used and will always have a value of 0. Instead, you can use the db2look command to get DDL information on the table which would show you if the table was created as "NOT LOGGED INITIALLY"
Example:
db2look -d <database_name> -t <table_name> -e -o <output_file_name.out>
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tablespaces","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"Enterprise Server;Express;Personal;Personal Developer's;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21397932