GLOBAL 块

GLOBAL 块允许您指定将用于此执行的每次卸载的控制设置,除非在较低级别覆盖某个选项。 此块中的任何参数都将覆盖其等效安装缺省值。

以下语法图显示了 GLOBAL 块。 全球 关键字指定 GLOBAL 块的开头。 GLOBAL 块是可选的; 但是,如果使用此块,那么控制文件中只能有此关键字的一个实例。

注意: 此块以分号结尾。
图 1. 全球区块

1  GLOBAL?  CONNECT TO database_name?  DBCCSID
2.1 n
2.1 UTF8?  URL "hostname PORT "number"?  SSL
2.1 NO
2.1 YES?  DB2
2.1 YES
2.1 NO
2.1 FORCE?  HEADER
2.1 FIRST
2.1 NONE
2.1 ALL
2.1  EXTERNAL "filename"?  HIDDEN
2.1 NO
2.1 YES?  IGNORE_LOAD_ERROR
2.1 NO
2.1 YES?  IGNORE_NONEXISTENT_TABLE
2.1 NO
2.1 YES?  LOCK
2.1 YES
2.1 NO?  FLUSH BUFFERPOOLS
2.1 YES
2.1 NO?  SIZELIMIT
2.1 integerK
2.1 integerM
2.1 integerG?  FILEMAXSIZE
2.1 integerK
2.1 integerM
2.1 integerG?  options_clause?  SCHEMA schema_name?  SHARED_DATAPART_PROCESSING
2.1 NO
2.1 YES?  TARGET KEYS  (
2.1 DEFAULT
2.1 CURRENT
2.1  PARTS
2.2.1  (
2.2.2.1! ALL
2.2.2.1 
2.2.2.2.1+ ,
2.2.2.2.1 nn
2.2.2.2.1 nn:nn
2.2.1 )
2.2.1?  IN ”filename” )?  TENANT tenant_name?  catalog_backup block?  NBCPU n?  MAXTHREADS n?  BLU_PARALLELISM n?  CLIENT APPLICATION NAME "application_name"
1  TARGET ENVIRONMENT ( target_db2nodes_specification?  IN dbname?  TENANT tenant_name?  REPART
2.1 NO
2.1 PMAP_4K
2.1 PMAP_32K )
2?  WORKING IN ( "dirname"? WITH FILES? 
3.1 UNIX
3.1 WINDOWS
2 PATH )
2?  UMASK "unmask_value"
2?  replace_string_clause
2?  translate_string_clause
2?  LOBINLINESIZE nnK
2?  DATAMASKING ODPP
3.1  PATH "odpp_path" VERSION "odpp_version"
3.1  LOAD "loader_lib" PARSER "parser_lib" ADAPTER "adapter_lib" PROVIDER "provider_lib"
1  OVERRIDE ( + , "original_dir" BY "new_dir" )
1  SEARCH (  "search_dir" )
3?  STAGING IN ( "dirname" )
3?  MAXUNSTAGING n
3?  MONITOR
4.1 NO
4.1 YES
1  loaddest_clause
4  ;
继续 TARGET environment 子句:
图 2. target_db2nodes_specification:

1  INSTANCE "instance_name"
2.1?  ON "hostname"
2.1  FILE "filename_with_template"?  EXCEPT PARTS (
2.1+ ,
2.1 nn
2.1 nn:nn
1 )