![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB2
文章平均质量分 53
Mainframer
这个作者很懒,什么都没留下…
展开
-
DB2 BIND
BIND1. Two method of BINDl Bind all DBRMs directly into one application plan as belowBIND PLAN(PLAN1) MEMBER(Main,Sub1,Sub2)l原创 2008-03-02 17:38:00 · 2268 阅读 · 0 评论 -
Privileges granted to users after database created
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原创 2008-05-27 15:20:00 · 827 阅读 · 0 评论 -
Unique Constraint, Primary Key and Unique Index
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原创 2008-05-27 15:06:00 · 1480 阅读 · 0 评论 -
General Guidelines for Better Performance
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原创 2008-04-11 11:00:00 · 555 阅读 · 0 评论 -
Typical Access Paths
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原创 2008-04-11 10:56:00 · 588 阅读 · 0 评论 -
Indicator Variables
Indicator Variables1. Function: Processing NULL Data2. The value of Indicator Variable (SMALLINT)l >=0 (usually 0), indicate that the column is not NULLl l原创 2008-04-11 10:54:00 · 1831 阅读 · 0 评论 -
Scrollable Cursors
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原创 2008-04-11 10:55:00 · 823 阅读 · 0 评论 -
DB2 隔离级别
DB2 Isolation Level1.Repeatable ReadIf a transaction scans 1000 rows but only retrieves 10, locks are acquired and held on all 100原创 2008-03-22 16:36:00 · 607 阅读 · 0 评论 -
LOAD
Load 1. LOAD JCL//LEBRONJ JOB (12345678),LEBRON,MSGCLASS=H, // MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID //UTIL EXEC DSNUPROC,SYSTEM=DB8G,UID原创 2008-03-04 19:50:00 · 1100 阅读 · 0 评论 -
UNLOAD
UNLOAD1. UNLOAD JCL//LEBRONJ JOB (12345678),LEBRON,MSGCLASS=H, // MSGLEVEL=(1,1),CLASS=A,NOTIFY=&SYSUID //UTIL EXEC DSNUPROC,原创 2008-03-04 19:44:00 · 1020 阅读 · 0 评论 -
Referential Integrity
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原创 2008-03-02 17:35:00 · 1345 阅读 · 0 评论 -
DB2 Data Type
DB2 Data Type原创 2008-05-27 15:40:00 · 819 阅读 · 0 评论