To query the current status of a job that is running, use the CMS immediate command SQLQRY by typing #SQLQRY directly from the terminal. The SQLQRY command cannot be used from a Database Services Utility control file.
You can use SQLQRY to determine the application server you are currently connected to. The output you receive from SQLQRY will be similar to that shown in Figure 14. For more information on the SQLQRY command, see the DB2 Server for VSE & VM Database Administration manual.
| Note: | The output from SQLQRY varies depending on the operating environment. |
Figure 14. Sample Output from SQLQRY
+--------------------------------------------------------------------------------+
|15:54:48 * MSG FROM SQLUSER6: Status of Database Conversations on 1999-06-30 |
|15:54:48 * MSG FROM SQLUSER6: EXTNAME = SQLUSER6.1 |
|15:54:48 * MSG FROM SQLUSER6: RDBMS = SQLRDB1 SQLDS/VM V3.3.0 |
|15:54:48 * MSG FROM SQLUSER6: STATUS = COMM TIME = 1999-06-30.15:54:38 |
|15:54:48 * MSG FROM SQLUSER6: LUWID = IBMNET01.*IDENT.45F2ABCD236D42 |
|15:54:48 * MSG FROM SQLUSER6: |
|15:54:48 * MSG FROM SQLUSER6: EXTNAME = SQLUSER6.2 |
|15:54:48 * MSG FROM SQLUSER6: RDBMS = IBMSTLDB2 DB2 V2.3.0 |
|15:54:48 * MSG FROM SQLUSER6: STATUS = APPL TIME = 1999-06-30.15:30:25 |
|15:54:48 * MSG FROM SQLUSER6: LUWID = IBMNET01.TORLU001.45F2ABCD236DFE |
|15:54:48 * MSG FROM SQLUSER6: LU = STLMVS04 |
|15:54:48 * MSG FROM SQLUSER6: TPN = "6DB (X'07F6C4C2') |
|15:54:48 * MSG FROM SQLUSER6: |
|15:54:48 * MSG FROM SQLUSER6: EXTNAME = SQLUSER6.2 |
|15:54:48 * MSG FROM SQLUSER6: RDBMS = SQLMACGM DB2/VM n/a |
|15:54:48 * MSG FROM SQLUSER6: STATUS = VRA TIME = 1999-06-30.15:30:25 |
|15:54:48 * MSG FROM SQLUSER6: TCP/IP = 9.21.4.194 PORT 6100 |
+--------------------------------------------------------------------------------+