![]() You cannot have a clone table without a base table. A clone table only exists if there was originally a base table. They can be populated by: INSERT LOAD etc. Consider the employee table with column PROJECT nullable. like a normal DB2 table Like a normal DB2 table, after creation, the clone objects (table, indexes, aux objects, etc.) are empty.What do you need to do before you do EXPLAIN?.What is the difference between primary key and unique index ?.The meaning is image copy is needed on table space. If table is loaded with LOG NO option then it get's into cpoy pending status. You can write the rexx script to build connection to Db2 subsystem and then execute the same command.Let me find the sample and send to you. Db2-managed archiving (also known as transparent archiving) was introduced with Db2 11 for z/OS Optimize access performance for popular rows (i.e. CHECK utility needs to be run on table space. That means table space is loaded without enforcing constraints. If the table is loaded with ENFORCE NO option then the table space get into check pending status. Check pending status of a table is set on when you are loading into table with log no and that table has some referencial constarint with other table.Ĭopy pending status is set on when you are loading into a table without a NOCOPYPEND option. What is check pending and copy pending status in D.ġ. In z/OS there is a similar, I think, menu in TSO. More DBA job interview questions and answers at You say you manually issue the commands in the DB2 commands screen. ![]() What is check pending and copy pending status in
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |