版次注意事項


10.6 db2look - DB2 Statistics Extraction Tool

The syntax diagram should appear as follows:

>>-db2look---d--DBname----+--------------+---+-----+---+-----+-->
                          '--u--Creator--'   '--s--'   '--g--'
 
>-----+-----+---+-----+---+-----+---+-----+---+-----+----------->
      '--a--'   '--h--'   '--r--'   '--c--'   '--p--'
 
>-----+------------+---+-------------------+-------------------->
      '--o--Fname--'   '--e--+----------+--'
                             '--t Tname-'
 
>-----+-------------------+---+-----+---+-----+----------------->
      '--m--+----------+--'   '--l--'   '--x--'
            '--t Tname-'
 
>-----+---------------------------+---+-----+------------------><
      '--i--userid---w--password--'   '--f--'
 

|The -td x parameter has been added following the -c parameter. |Its definition is as follows:

|Specifies the statement delimiter for SQL statements generated |by db2look. If this option is not specified, the defaults is the semicolon |';'. It is recommened that this option be used if the -e option is specified. |In this case, the extracted objects may contain triggers or SQL routines.

|The following example will also be added:

|Generate the DDL statements for objects created by all users |in the database DEPARTMENT. The db2look output is sent to file db2look.sql:

|db2look -d department -a -e -td % -o db2look.sql
|db2 -td% -f db2look.sql


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]