Verifying Adapter Installation

After creating the configuration files for accessing Db2 from FOCUS using CLI, you must verify that access to Db2 from FOCUS has been configured correctly.

Start FOCUS.

Issue the following commands:

SQL DB2 ?
SQL DB2
SELECT * FROM SYSIBM.SYSDUMMY1;
END

You should see output similar to the following.

>>sql db2 ?
(FOC1450) CURRENT DB2      INTERFACE SETTINGS ARE :
(FOC1656) DEFAULT SERVER NAME                 -  : CON01 dbm76
(FOC1424) ISOLATION LEVEL FOR DB2 TABLE INTERFACE IS  : RC
(FOC1496) AUTODISCONNECT OPTION IS            -  : ON FIN
(FOC1499) AUTOCOMMIT OPTION IS                -  : ON COMMAND
(FOC1706) ODBC CONCUR IS       -  : DEFAULT
(FOC1491) FETCH BUFFERING FACTOR              -  : 100
(FOC1531) INSERT BUFFERING FACTOR             -  : 1
(FOC1723) TRANSACTION MODE IS                 -  : ON
(FOC1441) WRITE FUNCTIONALITY IS              -  : ON
(FOC1445) OPTIMIZATION OPTION IS              -  : ON
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS        -  : ON
(FOC1484) SQL ERROR MESSAGE TYPE IS           -  : DBMS
(FOC1552) INTERFACE DEFAULT DATE TYPE         -  : NEW
(FOC1446) DEFAULT DBSPACE IS                  -  :

sql db2
select * from sysibm.sysdummy1;
end

PAGE     1


IBMREQD
-------
Y

If the request output displayed, the installation and connection were successful. Issue the following command to exit FOCUS.

FIN

If you disabled Direct SQL Passthru, instead of getting the report output, you will get the following message.

(FOC1570) DIRECT PASSTHRU DISABLED ON THIS SERVER.

You should then run the following version of the request that does not use Direct SQL Passthru.

CREATE SYNONYM _edatemp/SYSDUM1 DROP
   FOR SYSIBM.SYSDUMMY1
   DBMS DB2
END
TABLE FILE _edatemp/SYSDUM1
PRINT *
END

If the request output displayed, the installation and connection were successful.