Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    9

    Unanswered: question:how can i see current value of log index build of a table??

    db2 => alter table home01 log index build off


    how can i see current value of log index build of a table??

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    This information is stored in the packed descriptor, db2cat can be used to dump this info. The command is:

    db2cat -d <db name> -n <table name> -s <schema name> -o <output file>


    Example:

    db2cat -d sample -n employee -s test -o db2cat.out

    test@panipuri /home/test > grep -i build db2cat.out
    Log Index Build : OFF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •