Hay varios métodos para iniciar el rastreo para la actividad ODCB, en función del sistema operativo que se esté utilizando.
En Windows, utilice el separador
Trazas de la función ODBC:
Para detener el rastreo ODBC, en el separador Trazas, pulse Detener traza ahora y luego Aceptar.
La información de rastreo se envía a la ubicación que se especifica en el archivo .odbc.ini, o en la configuración ODBC en Windows. Por omisión, esta ubicación es /var/wmqi/odbc/odbctrace.out en sistemas que no son Windows.
De forma predeterminada, el archivo de salida de rastreo se graba en <component_HFS>/output/, en un archivo denominado db2appltrace.. Cada espacio de direcciones tiene un número exclusivo añadido al final de db2appltrace..
Este número exclusivo, añadido al archivo ODBC, es el número SE del espacio de direcciones del grupo de ejecución JOBLOG.
Debe buscar el valor de SE en el JOBLOG cuyo rastreo ODBC desea ver y encontrar el archivo que se denomina db2appltrace.<SE number>.
DB2 en WebSphere Event Broker para z/OS
[2008-09-24 15:49:20.544123] SQLAllocStmt( hDbc=2, phStmt=&1c7f9554 ) [2008-09-24 15:49:20.544156] SQLAllocStmt( phStmt=1 ) [2008-09-24 15:49:20.544163] ---> SQL_SUCCESS [2008-09-24 15:49:20.544179] SQLFreeStmt( hStmt=1, fOption=SQL_CLOSE ) [2008-09-24 15:49:20.544189] SQLFreeStmt( ) [2008-09-24 15:49:20.544194] ---> SQL_SUCCESS [2008-09-24 15:49:20.544205] SQLPrepare( hStmt=1 ) [2008-09-24 15:49:20.544212] ( pszSqlStr="SELECT TESTTABLE.ID FROM WMQI77.TESTTABLE TESTTABLE", cbSqlStr=-3 ) [2008-09-24 15:49:20.587083] SQLPrepare( ) [2008-09-24 15:49:20.587101] ---> SQL_ERROR [2008-09-24 15:49:20.587157] SQLError( hEnv=0, hDbc=0, hStmt=1, pszSqlState=&3902af28, pfNativeError=&3902af24, pszErrorMsg=&1b88b0b0, cbErrorMsgMax=1024, pcbErrorMsg=&3902aefc ) [2008-09-24 15:49:20.587190] SQLError( pszSqlState="42501", pfNativeError=-551, pszErrorMsg="{DB2 FOR OS/390}{ODBC DRIVER}{DSN09015} DSNT408I SQLCODE = -551, ERROR: WMQI83 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT WMQI77.TESTTABLE DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOSC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ERRLOC=1:13:2", pcbErrorMsg=623 ) [2008-09-24 15:49:20.587666] ---> SQL_SUCCESS [2008-09-24 15:49:20.587725] SQLError( hEnv=0, hDbc=0, hStmt=1, pszSqlState=&3902af28, pfNativeError=&3902af24, pszErrorMsg=&1b88b0b0, cbErrorMsgMax=1024, pcbErrorMsg=&3902aefc ) [2008-09-24 15:49:20.587752] SQLError( ) [2008-09-24 15:49:20.587757] ---> SQL_NO_DATA_FOUND [2008-09-24 15:49:20.588049] SQLFreeStmt( hStmt=1, fOption=SQL_DROP ) [2008-09-24 15:49:20.588075] SQLFreeStmt( ) [2008-09-24 15:49:20.588080] ---> SQL_SUCCESS [2008-09-24 15:49:20.593800] SQLTransact( hEnv=1, hDbc=0, fType=SQL_COMMIT ) [2008-09-24 15:49:20.593887] SQLTransact( ) [2008-09-24 15:49:20.593893] ---> SQL_SUCCESS
[2008-09-24 16:00:25.287052] SQLAllocStmt( hDbc=1, phStmt=&1c7f8e54 ) [2008-09-24 16:00:25.287068] SQLAllocStmt( phStmt=1 ) [2008-09-24 16:00:25.287075] ---> SQL_SUCCESS [2008-09-24 16:00:25.287088] SQLFreeStmt( hStmt=1, fOption=SQL_CLOSE ) [2008-09-24 16:00:25.287098] SQLFreeStmt( ) [2008-09-24 16:00:25.287104] ---> SQL_SUCCESS [2008-09-24 16:00:25.287114] SQLPrepare( hStmt=1 ) [2008-09-24 16:00:25.287121] ( pszSqlStr="SELECT TESTTABLE.ID FROM WMQI77.TESTTABLE TESTTABLE", cbSqlStr=-3 ) [2008-09-24 16:00:25.302484] SQLPrepare( ) [2008-09-24 16:00:25.302510] ---> SQL_SUCCESS [2008-09-24 16:00:25.302539] SQLFreeStmt( hStmt=1, fOption=SQL_CLOSE ) [2008-09-24 16:00:25.302555] SQLFreeStmt( ) [2008-09-24 16:00:25.302560] ---> SQL_SUCCESS [2008-09-24 16:00:25.302573] SQLExecute( hStmt=1 ) [2008-09-24 16:00:25.302622] SQLExecute( ) [2008-09-24 16:00:25.302628] ---> SQL_SUCCESS [2008-09-24 16:00:25.302660] SQLNumResultCols( hStmt=1, pcCol=&3902c7fa ) [2008-09-24 16:00:25.302672] SQLNumResultCols( pcCol=1 ) [2008-09-24 16:00:25.302679] ---> SQL_SUCCESS [2008-09-24 16:00:25.302697] SQLDescribeCol( hStmt=1, iCol=1, pszColName=&3902cb10, cbColNameMax=200, pcbColName=&3902c804, pfSQLType=&3902c802, pcbColDef=&3902c858, pibScale=&3902c800, pfNullable=&3902c7fe ) [2008-09-24 16:00:25.302733] SQLDescribeCol( pszColName="ID", pcbColName=2, pfSQLType=SQL_CHAR, pcbColDef=10, pibScale=0, pfNullable=SQL_NULLABLE ) [2008-09-24 16:00:25.302819] ---> SQL_SUCCESS [2008-09-24 16:00:25.302826] SQLColAttribute( hStmt=1, iCol=1, fDescType=SQL_DESC_OCTET_LENGTH, rgbDesc=NULL, cbDescMax=0, pcbDesc=NULL, pfDesc=&3902c864 ) [2008-09-24 16:00:25.302850] SQLColAttribute( pfDesc=10 ) [2008-09-24 16:00:25.302857] ---> SQL_SUCCESS [2008-09-24 16:00:25.302866] SQLBindCol( hStmt=1, iCol=1, fCType=SQL_C_CHAR, rgbValue=&1b48829c, cbValueMax=12, pcbValue=&1b488298 ) [2008-09-24 16:00:25.302888] SQLBindCol( ) [2008-09-24 16:00:25.302894] ---> SQL_SUCCESS [2008-09-24 16:00:25.302901] SQLSetStmtAttr( hStmt=1, fAttribute=SQL_ATTR_ROW_BIND_TYPE, pvParam=&10, iStrLen=0 ) [2008-09-24 16:00:25.302917] SQLSetStmtAttr( ) [2008-09-24 16:00:25.302922] ---> SQL_SUCCESS [2008-09-24 16:00:25.302928] SQLSetStmtAttr( hStmt=1, fAttribute=Unknown value 9, pvParam=&20, iStrLen=0 ) [2008-09-24 16:00:25.302943] SQLSetStmtAttr( ) [2008-09-24 16:00:25.302949] ---> SQL_SUCCESS [2008-09-24 16:00:25.302956] SQLExtendedFetch( hStmt=1, fFetchType=SQL_FETCH_NEXT,iRow=0, pcRow=&1c7f6894, rgfRowStatus=&1bca17d0 ) [2008-09-24 16:00:25.317947] ( Row=1, iCol=1, fCType=SQL_C_CHAR, rgbValue="TABLG ", pcbValue=10 ) [2008-09-24 16:00:25.317980] ( Row=2, iCol=1, fCType=SQL_C_CHAR, rgbValue="TABLF ", pcbValue=10 ) [2008-09-24 16:00:25.318001] ( Row=3, iCol=1, fCType=SQL_C_CHAR, r gbValue="TABLE ", pcbValue=10 ) [2008-09-24 16:00:25.318022] ( Row=4, iCol=1, fCType=SQL_C_CHAR, rgbValue="TABLD ", pcbValue=10 ) [2008-09-24 16:00:25.318044] ( Row=5, iCol=1, fCType=SQL_C_CHAR, rgbValue="TABLC ", pcbValue=10 ) [2008-09-24 16:00:25.318065] ( Row=6, iCol=1, fCType=SQL_C_CHAR, rgbValue="TABLB ", pcbValue=10 ) [2008-09-24 16:00:25.318087] ( Row=7, iCol=1, fCType=SQL_C_CHAR, rgbValue="TABLA ", pcbValue=10 ) [2008-09-24 16:00:25.318109] SQLExtendedFetch( pcRow=7 )