OS/390 DB2 V6.1 parms

Bob Jeandron

OS/390 DB2 V6.1 parms
Any bad experiences with new parms, these or some not listed, at your shop?
Panel Descriptions:
CONTRACT THREAD STG===> NO Periodically free unused thread stg
LIMIT BACKOUT ===> AUTO Limit backout processing. AUTO, YES, NO
BACKOUT DURATION ===> 5 Checkpoints processed during backout if
LIMIT BACKOUT = AUTO or YES. 0-255.
RO SWITCH CHKPTS ===> 5 Checkpoints to read-only switch. 1-32767
RO SWITCH TIME ===> 10 Minutes to read-only switch. 0-32767
LEVELID UPDATE FREQ===> 5 Checkpoints between updates. 0-32767

USE FOR DYNAMICRULES ===> YES YES or NO
DESCRIBE FOR STATIC ===> NO Allow DESCRIBE for STATIC SQL. NO or YES

U LOCK FOR RR/RS ===> NO Lock mode for update cursor with
RR or RS isolation. YES or NO

X LOCK FOR SEARCHED U/D ===> NO Use X lock for serached updates or
deletes. NO or YES.

OPTIMIZATION HINTS ===> NO Enable optimization hints. NO or YES
VARCHAR FROM INDEX ===> NO Get VARCHAR data from index. NO or YES
RELEASE LOCKS ===> YES Release cursor with hold locks. YES,NO
MAX DEGREE ===> 0 Maximum degree of parallelism. 0-254
UPDATE PART KEY COLS ===> YES Allow update of partitioning key
columns. YES, NO, SAME

LOG APPLY STORAGE ===> 0M Maximum ssnmDBM1 storage in MB for
fast log apply (0-100M)

MAX TYPE 1 INACTIVE ===> 0 Max number of type 1 inactive threads
EXTRA BLOCKS REQ ===> 100 Maximum extra query blocks when DB2 acts
as a requester. 0-100

EXTRA BLOCKS SRV ===> 100 Maximum extra query blocks when DB2 acts
as a server. 0-100

DATABASE PROTOCOL ===> DRDA Protocol used for three-part name if
not specified on BIND. DRDA or PRIVATE.

AUTH AT HOP SITE ===> BOTH Authorization at hop site. BOTH or RUNNER.
TCP/IP KEEPALIVE ===> ENABLE ENABLE, DISABLE, or 1-65534
POOL THREAD TIMEOUT ===> 120 0-9999 seconds

Thanks in advance.



Alan Smith

OS/390 DB2 V6.1 parms
(in response to Bob Jeandron)
I wouldn't use VARCHAR FROM INDEX, as this means sometimes you will get a
varchar, sometimes a string padded with blanks, depending on the access
path. This could affect your program logic.

If you use 3-part names in DDF, beware of DATABASE PROTOCOL ===> DRDA.
Suddenly you will find that you need packages bound into your remote
subsystem as well as your local one (should be more efficient though).

Alan Smith



> ------------------------------
>
> Date: Tue, 19 Dec 2000 12:13:00 -0500
> From: BOB JEANDRON <[login to unmask email]>
> Subject: OS/390 DB2 V6.1 parms
>
> Any bad experiences with new parms, these or some not listed, at your shop?
> Panel Descriptions:
> CONTRACT THREAD STG===> NO Periodically free unused thread stg
> LIMIT BACKOUT ===> AUTO Limit backout processing. AUTO, YES, NO
> BACKOUT DURATION ===> 5 Checkpoints processed during backout if
> LIMIT BACKOUT = AUTO or YES. 0-255.
> RO SWITCH CHKPTS ===> 5 Checkpoints to read-only switch. 1-32767
> RO SWITCH TIME ===> 10 Minutes to read-only switch. 0-32767
> LEVELID UPDATE FREQ===> 5 Checkpoints between updates. 0-32767
>
> USE FOR DYNAMICRULES ===> YES YES or NO
> DESCRIBE FOR STATIC ===> NO Allow DESCRIBE for STATIC SQL. NO or YES
>
> U LOCK FOR RR/RS ===> NO Lock mode for update cursor with
> RR or RS isolation. YES or NO
>
> X LOCK FOR SEARCHED U/D ===> NO Use X lock for serached updates or
> deletes. NO or YES.
>
> OPTIMIZATION HINTS ===> NO Enable optimization hints. NO or YES
> VARCHAR FROM INDEX ===> NO Get VARCHAR data from index. NO or YES
> RELEASE LOCKS ===> YES Release cursor with hold locks. YES,NO
> MAX DEGREE ===> 0 Maximum degree of parallelism. 0-254
> UPDATE PART KEY COLS ===> YES Allow update of partitioning key
> columns. YES, NO, SAME
>
> LOG APPLY STORAGE ===> 0M Maximum ssnmDBM1 storage in MB for
> fast log apply (0-100M)
>
> MAX TYPE 1 INACTIVE ===> 0 Max number of type 1 inactive threads
> EXTRA BLOCKS REQ ===> 100 Maximum extra query blocks when DB2 acts
> as a requester. 0-100
>
> EXTRA BLOCKS SRV ===> 100 Maximum extra query blocks when DB2 acts
> as a server. 0-100
>
> DATABASE PROTOCOL ===> DRDA Protocol used for three-part name if
> not specified on BIND. DRDA or PRIVATE.
>
> AUTH AT HOP SITE ===> BOTH Authorization at hop site. BOTH or RUNNER.
> TCP/IP KEEPALIVE ===> ENABLE ENABLE, DISABLE, or 1-65534
> POOL THREAD TIMEOUT ===> 120 0-9999 seconds
>
> Thanks in advance.
>