Add the following lines to hlq.ERRORS.DATA(FOCPROF)

{ENGINE|SQL} DB2 SET SSID ssid

{ENGINE|SQL} DB2 SET PLAN planname

where:

ssid

Is the subsystem ID that was specified in Step 5 of Create the BIND Member and Submit the BIND Job.

planname

Is the plan that was specified in Step 6 of Create the BIND Member and Submit the BIND Job.

The following additional default parameters can be placed in FOCPROF.

{ENGINE|SQL} DB2 SET AUTODISCONNECT {ON FIN|ON COMMIT} 

{ENGINE|SQL} DB2 SET AUTOCLOSE {ON FIN|ON COMMIT} 

{ENGINE|SQL} DB2 SET AUTOCOMMIT {ON COMMAND|ON CRTFORM|ON FIN}

{ENGINE|SQL} DB2 SET ISOLATION {CS|RR|RS|UR} 

{ENGINE|SQL} DB2 SET ERRORTYPE {FOCUS|DBMS} 

{ENGINE|SQL} DB2 SET DBSPACE database.tablespace 

{ENGINE|SQL} DB2 SET FETCHSZIE n 

where:

n

Is a value between 1 and 32000.