Troubleshooting
Problem
This document provides the requirements to successfully use the job trace diagnostic feature in the ODBC driver.
Resolving The Problem
The IBM i Access ODBC driver uses the STRTRC command for its "Enable job trace" diagnostic option.
Note: The same diagnostic options are available via Connection string keywords in all IBM i Access ODBC clients. See related link below.
To successfully use this diagnostic option, the user profile that is used to make the ODBC connection must have the following authorities:
*SERVICE special authority
*CHANGE authority to the QUSRSYS library
The user profile must also have authority to the following commands:
STRTRC
ENDTRC
DLTTRC
DLTPEXDTA
The authority can be granted by a *SECOFR class user profile by running the following CL commands:
Note: The user profile SAMPLE is used in the following example commands:
*SERVICE special authority
*CHANGE authority to the QUSRSYS library
The user profile must also have authority to the following commands:
STRTRC
ENDTRC
DLTTRC
DLTPEXDTA
The authority can be granted by a *SECOFR class user profile by running the following CL commands:
Note: The user profile SAMPLE is used in the following example commands:
CHGUSRPRF USRPRF(SAMPLE) SPCAUT(*SERVICE)
GRTOBJAUT OBJ(QUSRSYS) OBJTYPE(*LIB) USER(SAMPLE) AUT(*CHANGE)
GRTOBJAUT OBJ(STRTRC) OBJTYPE(*CMD) USER(SAMPLE) AUT(*USE)
GRTOBJAUT OBJ(ENDTRC) OBJTYPE(*CMD) USER(SAMPLE) AUT(*USE)
GRTOBJAUT OBJ(DLTTRC) OBJTYPE(*CMD) USER(SAMPLE) AUT(*USE)
GRTOBJAUT OBJ(DLTPEXDTA) OBJTYPE(*CMD) USER(SAMPLE) AUT(*USE)
The "Enable job trace" option will create spool file "QPSRVTRCJ" for the user that made the ODBC connection.
Remember to uncheck or disable the trace options after recreating the error.
Remember to uncheck or disable the trace options after recreating the error.
Related Information
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Component":"Data Access","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Historical Number
418063256
Was this topic helpful?
Document Information
Modified date:
02 May 2025
UID
nas8N1014913