Add the following lines to hlq.ERRORS.DATA(FOCPROF)
{ENGINE|SQL} DB2 SET SSID ssid
{ENGINE|SQL} DB2 SET PLAN planname
where:
Is the subsystem ID that was specified in Step 5 of Create the BIND Member and Submit the BIND Job.
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:
Is a value between 1 and 32000.
|
Information Builders |