DB2 bind on z/OS

Source: Internet
Author: User
Tags db2

BIND and REBIND options for packages and plans

There is several options you can use for binding or rebinding plans and packages. Some of the options is common for both bind and rebind, and for both plans and packages.

Defaults:The defaultFor a option is the value of used if you omit the entire option.
    • A default of plan value for BIND package means, the default is the same as the value determined during the BI nd or rebind of the plan to which the package is appended at run time.
    • A default of existing value for REBIND PLAN or REBIND package means then the default is the value of it was determ ined during the previous bind or rebind of the plan or package that is rebinding.

Catalog Records: The Db2®catalog records information about plans and packages, chiefly in the tables SYSIBM. Sysplan and SYSIBM. Syspackage. The descriptions of the options record information omit the constant qualifier, SYSIBM, of those table names.

For all other cases, the option descriptions note the specific defaults, which DB2 assigns at bind time. If a specific default value exists, that's value is underlined.

    • Acquire bind option
      The acquire BIND option Specifiesthat resources for the packages in the plan is to be acquired whenthe application first Accesses them.
    • ACTION bind option
      The ACTION option determines whether the object (plan Orpackage) replaces an existing object with the same name or is new.
    • Apcompare bind option
      The Apcompare option determines whether the new access paths is different from the olderaccess paths.
    • Applcompat bind option
      The APPLCOMPAT option specifies the package compatibilitylevel behavior for static SQL.
    • Apretaindup bind option
      The Apretaindup option determines whether or not DB2 retains a old package copywhen access paths of the old copy is Iden Tical to the incoming copy.
    • Apreuse bind option
      The Apreuse option specifies whether DB2 tries toreuse previous access paths for SQL statements in a package. DB2 uses information about the previous access paths from the directory to create a hint.
    • Archivesensitive bind option
      The archivesensitive option determines whether references to archive-enabled tables Inboth static and dynamic SQL Statemen TS is affected by the value of the Sysibmadm. Get_archive globalvariable.
    • Bustimesensitive bind option
      The bustimesensitive option determines whether Referencesto application-period temporal tables in both static and dynamic Sqlstatements is affected by the value of the current temporal business_timespecial register.
    • CACHESIZE bind option
      The CACHESIZE option determines the size (in bytes) ofthe authorization cache acquired in the EDM pool for the plan.
    • Collid bind option
      The Collid option specifies that any dbrms in the Planare to being bound to packages.
    • Concurrentaccessresolution bind option
      The concurrentaccessresolution option specifies which concurrentaccess resolution option to use for statements in a PACKAG E.
    • COPY bind option
      The COPY option copies an existing package, and names Thatpackage.
    • CurrentData bind option
      The CurrentData option determines whether to require datacurrency for read-only and ambiguous cursors when the isolation L Evelof cursor stability is in effect. It also determines whether blockfetching can be used for distributed, ambiguous cursors.
    • Currentserver bind option
      The Currentserver option determines the location to ConnectTo before running a plan.
    • Dbprotocol bind option
      The Dbprotocol optionspecifies the protocol to is used when connecting to a remote site.
    • DEFER and Nodefer bind options
      The DEFER and Nodefer options determine whether to deferpreparation for dynamic SQL statements, refer to remote object S,or to prepare them immediately.
    • Degree bind option
      The degree option determines whether to attempt to Runa query using parallel processing to maximize performance.
    • DEPLOY bind option
      The DEPLOY option Deploysa non-inline SQL function or a native SQL procedure.
    • Descstat bind option
      The Descstat option determines whether DB2 builds a DESCRIBE SQL Descriptor area (SQLDA) When binding static SQL statements .
    • DISCONNECT bind option
      The DISCONNECT option determines which remote Connectionsto destroy during commit operations.
    • Dynamicrules bind option
      The Dynamicrules option determines the rules that applyat run time for certain dynamic SQL attributes.
    • ENABLE and DISABLE bind options
      The ENABLE and DISABLE options determines which connectionscan use a plan or package.
    • ENCODING bind option
      The ENCODING option specifies the application encodingfor all host variables in static statements in a plan or package.
    • EXPLAIN bind option
      The EXPLAIN option causes the bindprocess to obtain information what is SQL statements in the Packageor packages is to Execute.
    • Extendedindicator bind option
      The Extendedindicator option determines whether DB2 recognizes extended indicatorvariables when the associated package is Run.
    • FILTER bind option
      The FILTER option lets you delete a set of queries in Thesysibm.sysquery table under a {tag} value that's specified by th Esysquery.userfilter column.
    • FLAG bind option
      The FLAG option determines the messages to display duringthe bind process.
    • GENERIC bind option
      The GENERIC option specifies one or more bind options Thatare supported by the target server, but is not supported as opt Ionsfor bind package or REBIND package on the DB2 for Z/os®subsystemon which the bind or REBIND command is issued.
    • Getaccelarchive bind option
      The getaccelarchive bind option specifies whether a staticsql query that's bound for acceleration retrieves archived data onthe Accelerator, instead of active data.
    • Immedwrite bind option
      The Immedwrite option indicates whether immediate writesare to being done for updates that is made to group buffer pool Depe Ndentpage Sets or partitions.
    • Isolation bind option
      The isolation option determines how far to isolate a applicationfrom the effects of other running applications.
    • Keepdynamic bind option
      The keepdynamic option determines whether DB2 keeps dynamic SQL statements after commit points. .
    • LIBRARY bind option
      The LIBRARY option determines whatpartitioned data set or ZFS file path to search for the DBRM thatis listed in the MEMBER Option.
    • MEMBER bind option
      The MEMBER option Determineswhat database request modules (Dbrms) to include in the package.
    • Opthint bind option
      The Opthint option controls whether access paths that arespecified in plan_table instances is used for static SQL Stateme Nts.
    • OPTIONS bind option
      The options option specifies which bind OPTIONS to usefor, the new package, when the COPY option is specified.
    • OWNER bind option
      The OWNER option determines the authorization ID of Theowner of a plan or package.
    • Package bind option
      The package option determines the packages to bind or rebind.
    • PATH bind option
      The path option determines the SQL PATH that DB2 uses to resolve unqualified stored procedurenames in call statements, in user-defined data types, and in functions.
    • Pathdefault bind option
      The Pathdefault option resets Thepath value for a package or plan to SYSIBM, Sysfun, Sysproc, Sysibmadm, Planqualifier , or to SYSIBM, Sysfun, Sysproc, Sysibmadm, packagequalifier .
    • Pklist and Nopklist bind options
      The Pklist option determines the packages to include the INA package list. The nopklist option deletes packages from a packagelist.
    • PLAN bind option
      The plan option determines the plan or plans to bind or rebind.
    • PLANMGMT bind option
      The PLANMGMT option retains, during a rebind Operation,all relevant package information (such as metadata, query text, DEP Endencies,authorizations, and access paths) in catalog tables and in the directory.
    • Progauth bind option
      The Progauth option specifies whether DB2 performs program authorization checking todetermine whether DB2 can executea pla N.
    • QUALIFIER bind option
      The QUALIFIER option determines the implicit qualifierfor unqualified names of tables, views, indexes, and aliases contain Edin the plan or package.
    • Queryacceleration bind option
      The queryacceleration bind option specifies whether a staticsql query is bound for acceleration, and if so, with what Beha Vior.
    • Queryid bind option
      The Queryid option frees entries in the SYSIBM. Sysquerytable, and the SYSIBM. Sysqueryplan table or the SYSIBM. Sysqueryoptstable.
    • RELEASE bind option
      The release option determines when to RELEASE Resourcesthat a program uses, either at each commit point or when the Progra Mterminates.
    • REOPT bind option
      The REOPT option specifies whether DB2 determines an access path at run time byusing the values of host variables, Paramet ER markers, and specialregisters.
    • Rounding bind option
      The rounding option specifies the rounding mode at Bindtime. Use rounding mode to manipulate decfloat data.
    • SQLERROR bind option
      The SQLERROR option determines whether to create a packageif SQL errors occur.
    • Sqlrules bind option
      The Sqlrules option determines whether you can Executea type 2 CONNECT statement to an existing SQL connection, Accordingt o DB2 rules.
    • SWITCH bind option
      The SWITCH option causes the previous copy or originalcopy of a package to become the current copy of the package.
    • Systimesensitive bind option
      The systimesensitive option specifies whether Referencesto system-period temporal tables in both static and dynamic SQL St Atementsare affected by the value of the current temporal system_time specialregister.
    • VALIDATE bind option
      The VALIDATE option determines whether to recheck, at runtime, errors of the types ' OBJECT not FOUND ' and ' not AUTHORIZED ' That is found during bind or rebind.

DB2 bind on z/OS

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.