Mainframer的专栏

                                              BIND1.         Two method of BINDl         Bind all DBRMs directly into one application plan as belowBIND PLAN(PLAN1) MEMBER(Main,Sub1,Sub2)l     

                                  Referential Integrity1.       A PARENR KEY value must be UNIQUE, and can’t be NULL.2.       A FOREIGN KEY value must match a PARENT KEY or be NULL3.       DB2 e

                                  UNLOAD1.       UNLOAD JCL//LEBRONJ  JOB (12345678),LEBRON,MSGCLASS=H,            //        MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID         //UTIL EXEC DSNUPROC,

                    Load 1.       LOAD JCL//LEBRONJ  JOB (12345678),LEBRON,MSGCLASS=H,             //        MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID          //UTIL EXEC DSNUPROC,SYSTEM=DB8G,UID

                                                                  DB2 Isolation Level1．Repeatable ReadIf a transaction scans 1000 rows but only retrieves 10, locks are acquired and held on all 100

Scrollable Cursors1.       What is scrollable cursors?When a cursor is declared as scrollable, you can use FETCH statements to:l         Jump around and directly retrieve a row which is located

 Indicator Variables1.       Function: Processing NULL Data2.       The value of Indicator Variable (SMALLINT)l         >=0 (usually 0), indicate that the column is not NULLl         l    

 Typical Access PathsDb2 determine an access path for every executable SQL statement. To do this, it looks at several things, such as the catalog statistics and configuration parameters. It takes

General Guidelines for Better Performance1．  Avoid unnecessary conversions2．  Select what you need, avoid select *3．  Minimize DB2 Sorts, as sorting increases CPU requirements and possibly addit

Unique Constraint, Primary Key and Unique Index1.       Unique ConstraintEnsure no duplicate value exists in the columns for which unique constraint has been defined.Regardless of when a unique

      Privileges granted to users after database created1． To Database Owner     DBADM authority, along with CONNECT, CREATETAB, BINDADD, CREATE_NOT_FENCED, IMPLICIT_SCHEMA, and LOAD privileges, a

DB2 Data Type