The online resource adapter (ORA) must be enabled before you can start ISQL. ISQL accesses the application server to which the ORA is connected. The ORA connects multiple application servers at a time. You specify the application servers by the DBNAME parameter of the CIRB transaction.
After the online resource adapter is started, you can use the CIRA transaction to add connections to other DB2 Server for VSE & VM application servers. CIRA can be entered multiple times with different server_names to establish connections to the specified application server. With one CIRA command, you can also establish a list of server_names. The system operator or database administrator (DBA) usually performs these tasks.
While in ISQL you can enter a null CONNECT statement to display the connected user ID and application server names.
Before you can start ISQL, the following steps must be completed for you:
The first two tasks are usually performed by the system operator or the database administrator (DBA), and the SQLINIT EXEC is usually automatically run when you log on your user ID.
The SQLINIT EXEC establishes the required links and defines the name of the application server. If the SQLINIT EXEC is not automatically run for you, run the EXEC before you start ISQL. You must know the name of the application server. If you do not know the name of the application server, speak to your DBA. In the following example, to run the SQLINIT EXEC establishing a link to the SAMPLEDB server, type the following and press ENTER:
sqlinit dbname(sampledb)
If you want to use the SQLINIT EXEC, refer to the DB2 Server for VSE & VM Database Administration manual.