Here's the trace file for one select. The trace shows the driver is definitely seeing the currentFunctionPath setting (line 53). It then executes the unqualified statement (line 155). It receives SQLCODE -204 (line 237). Finally, lines 379-380 seem to imply that the SQL command SET CURRENT FUNCTION PATH ="DB2TST6" was applied to the connection and the transport. The question is, did DB2 do anything with it? It doesn’t look like it. It looks to me like the problem lies with DB2 or DRDA rather than the driver.
[jcc] BEGIN TRACE_XML_CONFIGURATION_FILE
[jcc] dsdriverConfigFile=null
[jcc] BEGIN TRACE_DRIVER_CONFIGURATION
[jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 3.61.84
[jcc] Compatible JRE versions: { 1.4, 1.5, 1.6 }
[jcc] Target server licensing restrictions: { z/OS: enabled; SQLDS: enabled; iSeries: enabled; DB2 for Unix/Windows: enabled; Cloudscape: enabled; Informix: enabled }
[jcc] Range checking enabled: true
[jcc] Bug check level: 0xff
[jcc] Default fetch size: 64
[jcc] Default isolation: 2
[jcc] Collect performance statistics: false
[jcc] No security manager detected.
[jcc] Detected local client host: AMACHIN/661.345.936.669
[jcc] Access to package sun.io is permitted by security manager.
[jcc] JDBC 1 system property jdbc.drivers = null
[jcc] Java Runtime Environment version 1.5.0_24-rev
[jcc] Java Runtime Environment vendor = Sun Microsystems Inc.
[jcc] Java vendor URL = http://java.sun.com/
[jcc] Java installation directory = C:\Program Files\Java\jdk1.5.0_24\jre
[jcc] Java Virtual Machine specification version = 1.0
[jcc] Java Virtual Machine specification vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine specification name = Java Virtual Machine Specification
[jcc] Java Virtual Machine implementation version = 1.5.0_24-rev-b04
[jcc] Java Virtual Machine implementation vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine implementation name = Java HotSpot(TM) Client VM
[jcc] Java Runtime Environment specification version = 1.5
[jcc] Java Runtime Environment specification vendor = Sun Microsystems Inc.
[jcc] Java Runtime Environment specification name = Java Platform API Specification
[jcc] Java class format version number = 49.0
[jcc] Java class path = .;jjjjj.jar;lib\ojdbc14.jar;lib\log4j.jar;lib\db2jcc.jar;lib\db2jcc_license_cisuz.jar;lib\db2jcc_javax.jar
[jcc] Java native library path = C:\Program Files\Java\jdk1.5.0_24\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_24\bin;C:\Oracle9\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\ant\apache-ant-1.7.0;C:\Program Files\E!TCP\;C:\Program Files\TortoiseSVN\bin
[jcc] Path of extension directory or directories = C:\Program Files\Java\jdk1.5.0_24\jre\lib\ext
[jcc] Operating system name = Windows XP
[jcc] Operating system architecture = x86
[jcc] Operating system version = 5.1
[jcc] File separator ("/" on UNIX) = \
[jcc] Path separator (":" on UNIX) = ;
[jcc] User's account name = xyz1
[jcc] User's home directory = C:\Documents and Settings\xyz1
[jcc] User's current working directory = c:\data\jjjjj
[jcc] JCC outputDirectory = C:\Temp\
[jcc] Loaded global properties file: C:\Data\jjjjj\DB2JccConfiguration.properties
[jcc] Using global properties:
[jcc] db2.jcc.traceFile = jccTrace_TableExample, file
[jcc] db2.jcc.traceDirectory = C:/Data/jjjjj/Trace, file
[jcc] db2.jcc.traceFileAppend = false, file
[jcc] db2.jcc.traceLevel = -1, file
[jcc] Dumping all system properties: { java.runtime.name=Java(TM) Platform, Standard Edition for Business, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_24\jre\bin, java.vm.version=1.5.0_24-rev-b04, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=US, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=c:\data\jjjjj, java.runtime.version=1.5.0_24-rev-b04, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, db2.jcc.propertiesFile=C:/Data/jjjjj/DB2JccConfiguration.properties, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_24\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Temp\, line.separator=\r\n, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_24\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_24\bin;C:\Oracle9\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\ant\apache-ant-1.7.0;C:\Program Files\E!TCP\;C:\Program Files\TortoiseSVN\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\xyz1, user.timezone=America/Los_Angeles, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, java.class.path=.;jjjjj.jar;lib\ojdbc14.jar;lib\log4j.jar;lib\db2jcc.jar;lib\db2jcc_license_cisuz.jar;lib\db2jcc_javax.jar, user.name=xyz1, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_24\jre, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.5.0_24-rev, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_24\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_24\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_24\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86 }
[jcc] Dumping all file properties: { db2.jcc.traceFileAppend=false, db2.jcc.traceFile=jccTrace_TableExample, db2.jcc.traceDirectory=C:/Data/jjjjj/Trace, db2.jcc.traceLevel=-1 }
[jcc] pureQuery present = false
[jcc] END TRACE_DRIVER_CONFIGURATION
[jcc] BEGIN TRACE_CONNECTS
[jcc] Attempting connection to ABCD:6666/DB2SYS
[jcc] Using properties: { currentPackagePath=null, currentLockTimeout=-2147483647, timerLevelForQueryTimeOut=0, optimizationProfileToFlush=null, timeFormat=1, monitorPort=0, sendCharInputsUTF8=0, LOCKSSFU=null, sendDataAsIs=false, stripTrailingZerosForDecimalNumbers=0, returnAlias=1, supportsAsynchronousXARollback=2, sessionTimeZone=null, pkList=null, atomicMultiRowInsert=0, DEBUG=null, IFX_UPDDESC=1, traceDirectory=null, maxRowsetSize=32767, driverType=4, extendedDiagnosticLevel=240, accountingInterval=null, monitoredDataSourceName=null, concurrentAccessResolution=0, LKNOTIFY=yes, clientProgramName=null, connectNode=-1, progressiveStreaming=0, DBMAXPROC=null, INFORMIXSTACKSIZE=null, databaseName=DB2SYS, IFX_XASTDCOMPLIANCE_XAEND=null, decimalSeparator=0, DBPATH=., emulateParameterMetaDataForZCalls=0, decimalRoundingMode=-2147483647, serverName=ABCD, DUMPDIR=null, allowUnassignedParameters=0, streamBufferSize=1048576, STMT_CACHE_DEBUG=null, downgradeHoldCursorsUnderXa=false, currentRefreshAge=-9223372036854775807, kerberosServerPrincipal=null, DB_LOCALE=null, description=null, DUMPCORE=null, queryCloseImplicit=0, keepDynamic=0, PSORT_NPROCS=null, user=xyz1, connectionCloseWithInFlightTransaction=0, fullyMaterializeLobData=true, enableClientAffinitiesList=0, clientUser=null, portNumber=6666, resultSetHoldability=0, allowNextOnExhaustedResultSet=0, NOSORTINDEX=null, enableConnectionConcentrator=false, monitorServerName=null, STMT_CACHE=null, PSORT_DBTEMP=null, sqljEnableClassLoaderSpecificProfiles=false, clientAccountingInformation=null, IFX_EXTDIRECTIVES=null, clientProgramId=null, IFX_DIRECTIVES=null, enableSeamlessFailover=0, GCORE=null, SQLSTATS=null, LOCKDOWN=no, currentExplainMode=null, SORTINDEX=null, timestampFormat=5, retryIntervalForClientReroute=-1, password=****, updateCountForBatch=0, reportLongTypes=0, xaNetworkOptimization=true, plugin=null, pdqProperties=null, currentSchema=null, CR_LOCKBLOB=null, traceLevel=-1, enableRowsetSupport=0, clientDebugInfo=null, dataSourceName=null, enableAlternateServerListFirstConnect=0, maxRetriesForClientReroute=-1, fetchSize=-1, queryDataSize=0, clientRerouteAlternateServerName=null, DBTEMP=/tmp, enableT2zosLBF=0, SUBQCACHESZ=10, ssid=null, currentMaintainedTableTypesForOptimization=null, traceFile=null, currentExplainSnapshot=null, DBDATE=Y4MD-, SLABEL=null, enableMultirowInsertSupport=true, currentFunctionPath=db2tst6, monitorEnabled=0, enableNamedParameterMarkers=0, PDQPRIORITY=null, supportsRawDateTimeRetrieval=false, useCachedCursor=true, pluginName=null, charOutputSize=0, maxTransportObjects=2147483647, NOSHMSG=null, resultSetHoldabilityForCatalogQueries=0, monitorLevel=0, IFX_FLAT_UCSQ=null, affinityFailbackInterval=0, planName=null, SQL_FROM_DBIMPORT=null, interruptProcessingMode=1, floatingPointStringFormat=0, currentPackageSet=null, timestampPrecisionReporting=0, clientRerouteAlternatePortNumber=null, useTransactionRedirect=false, dateTimeMutation=false, securityMechanism=3, statementConcentrator=0, timestampOutputType=0, allowNullResultSetForExecuteQuery=0, sysSchema=null, decimalStringFormat=0, blockingReadConnectionTimeout=0, DBANSIWARN=false, sslTrustStorePassword=null, DELIMIDENT=false, clientWorkstation=null, currentQueryOptimization=-2147483647, clientApplicationInformation=null, DUMPSHMEM=null, translateForBitData=0, monitorCollectionInterval=0, sslTrustStoreLocation=null, optimizationProfile=null, retrieveMessagesFromServerOnGetMessage=false, readOnly=false, INFORMIXOPCACHE=null, useRowsetCursor=true, traceFileAppend=false, clientRerouteServerListJNDIName=null, enableSysplexWLB=false, useJDBC4ColumnNameAndLabelSemantics=0, recordTemporalHistory=0, NODEFDAC=no, sslConnection=false, dateFormat=1, OPTOFC=null, cliSchema=null, retryWithAlternativeSecurityMechanism=0, DBSPACETEMP=null, enableExtendedIndicators=0, PLOAD_LO_PATH=null, encryptionAlgorithm=0, DBUPSPACE=null, cursorSensitivity=0, jdbcCollection=NULLID, fullyMaterializeInputStreams=false, currentSQLID=null, loginTimeout=0, useIdentityValLocalForAutoGeneratedKeys=false, OPTCOMPIND=null, LIGHT_SCANS=null, defaultIsolationLevel=2, deferPrepares=true, currentDegree=null, DUMPMEM=null }
[jcc] END TRACE_CONNECTS
[jcc][t4] [time:2011-03-18-10:22:33.950][Thread:main][tracepoint:950]searching the server list cache for key ABCD:6666
[jcc][t4] [time:2011-03-18-10:22:34.013][Thread:main][tracepoint:315]creating a socket to ABCD at 10.44.21.40
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: EXCSAT (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 009CD04100010096 10410048115E8482 ...A.....A.H.^.. ..}....o.....;db
[jcc][t4] 0010 F29183836D819797 93898381A3899695 ....m........... 2jcc_application
[jcc][t4] 0020 4040D1C3C3F0F3F6 F1F0F3F0F0000000 @@.............. JCC03610300...
[jcc][t4] 0030 0000000000000000 0000000000000000 ................ ................
[jcc][t4] 0040 0000000000000000 000000000060F0F0 .............`.. .............-00
[jcc][t4] 0050 F0F10016116DC1F1 F1F7F8F0F8404040 .....m.......@@@ 01..._AMACHIN
[jcc][t4] 0060 4040404040404040 000C115AD1C3C3F0 @@@@@@@@...Z.... ...!JCC0
[jcc][t4] 0070 F3F6F1F0001C1404 1403000A2407000A ............$... 3610............
[jcc][t4] 0080 1C0804B8240F0008 1440000914740008 ....$....@...t.. ......... ......
[jcc][t4] 0090 000C1147D8C4C2F2 61D1E5D4 ...G....a... ....QDB2/JVM
[jcc][t4]
[jcc][t4] SEND BUFFER: ACCSEC (ASCII) (EBCDIC)
[jcc][t4] 0000 0026D00100020020 106D000611A20003 .&..... .m...... ..}......_...s..
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 404040404040 @@@@@@
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: EXCSATRD (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 0092D0430001008C 14430044115EC4C2 ...C.....C.D.^.. .k}..........;DB
[jcc][t4] 0010 F2F24BC3C1C9C3C2 C3C4C2F2F2000000 ..K............. 22.DB2SYS...
[jcc][t4] 0020 0000000000000000 0000000000000000 ................ ................
[jcc][t4] 0030 0000000000000000 0000000000001800 ................ ................
[jcc][t4] 0040 0000000000000000 000000000000001C ................ ................
[jcc][t4] 0050 1404140300072407 00071C080000240F ......$.......$. ................
[jcc][t4] 0060 0007144000071474 000500081147D8C4 ...@...t.....G.. ... ..........QD
[jcc][t4] 0070 C2F20014116DC3C1 C9C3C2C3C4C2F2F2 .....m.......... B2..._DB2SYS
[jcc][t4] 0080 404040404040000C 115AC4E2D5F0F9F0 @@@@@@...Z...... ...!DSN090
[jcc][t4] 0090 F1F0 .. 10
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: ACCSECRD (ASCII) (EBCDIC)
[jcc][t4] 0000 0010D0030002000A 14AC000611A20003 ................ ..}..........s..
[jcc][t4]
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: SECCHK (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 003AD04100010034 106E000611A20003 .:.A...4.n...... ..}......>...s..
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 4040404040400008 11A09384F494000C @@@@@@.......... ....xyz1..
[jcc][t4] 0030 11A15C5C5C5C5C5C 5C5C ..\\\\\\\\ .~********
[jcc][t4]
[jcc][t4] SEND BUFFER: ACCRDB (ASCII) (EBCDIC)
[jcc][t4] 0000 00C7D001000200C1 200100162110C3C1 ........ ...!... .G}....A......CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 0006210F2407000C 112ED1C3C3F0F3F6 ..!.$........... ..........JCC036
[jcc][t4] 0030 F1F0007221046DD1 C3C3F0F3F6F1F0C1 ...r!.m......... 10...._JCC03610A
[jcc][t4] 0040 F1F1F7F8F0F84040 4040404040404040 ......@@@@@@@@@@ 117808
[jcc][t4] 0050 408482F29183836D 81979793898381A3 @......m........ db2jcc_applicat
[jcc][t4] 0060 89969540409384F4 944040404036D1C3 ...@@....@@@@6.. ion xyz1 .JC
[jcc][t4] 0070 C3F0F3F6F1F0C1F1 F1F7F8F0F8404040 .............@@@ C03610AMACHIN
[jcc][t4] 0080 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@
[jcc][t4] 0090 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@
[jcc][t4] 00A0 40404040000D002F D8E3C4E2D8D3C1E2 @@@@.../........ ....QTDSQLAS
[jcc][t4] 00B0 C300160035000611 9C04B80006119D04 ....5........... C...............
[jcc][t4] 00C0 B00006119E04B8 ....... .......
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:34.169][Thread:main][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: SECCHKRM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 0015D0420001000F 1219000611490000 ...B.........I.. ..}.............
[jcc][t4] 0010 000511A400 ..... ...u.
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: ACCRDBRM (ASCII) (EBCDIC)
[jcc][t4] 0000 00A0D0020002009A 2201000611490000 ........"....I.. ..}.............
[jcc][t4] 0010 000D002FD8E3C4E2 D8D3F3F7F0000C11 .../............ ....QTDSQL370...
[jcc][t4] 0020 2EC4E2D5F0F9F0F1 F000160035000611 ............5... .DSN09010.......
[jcc][t4] 0030 9C04B80006119E04 B80006119D04B000 ................ ................
[jcc][t4] 0040 172135C7C1F2F2F8 F8F4F54BC8F0F7F4 .!5........K.... ...GA228845.H074
[jcc][t4] 0050 C77CF70C8B5A001E 244E0006244C0001 .|...Z..$N..$L.. G@7..!...+...<..
[jcc][t4] 0060 0014244D0006244F FFFF000A11E80A2C ..$M..$O......., ...(...|.....Y..
[jcc][t4] 0070 1528139D00222103 00000000128C9AE8 .(..."!......... ...............Y
[jcc][t4] 0080 C7C1F2F2F8F8F4F5 C8F0F7F440404040 ............@@@@ GA228845H074
[jcc][t4] 0090 C77CF70C8B5A000A 11E80A2C1528139E .|...Z.....,.(.. G@7..!...Y......
[jcc][t4]
[jcc][Time:2011-03-18-10:22:34.169][Thread:main][Connection@14eaec9] getHostAddressFromIpaddr (6, { 0xa, 0x2c, 0x15, 0x28, 0x13, 0x9e }) called
[jcc][Time:2011-03-18-10:22:34.169][Thread:main][Connection@14eaec9] getHostAddressFromIpaddr () returned ABCD.ABCD.net
[jcc][Time:2011-03-18-10:22:34.185][Thread:main][Connection@14eaec9] setCurrentFunctionPath () called
[jcc][Connection@14eaec9] BEGIN TRACE_CONNECTS
[jcc][Connection@14eaec9] Successfully connected to server jdbc:db2://ABCD:6666/DB2SYS
[jcc][Connection@14eaec9] User: xyz1
[jcc][Connection@14eaec9] Database product name: DB2
[jcc][Connection@14eaec9] Database product version: DSN09010
[jcc][Connection@14eaec9] Driver name: IBM DB2 JDBC Universal Driver Architecture
[jcc][Connection@14eaec9] Driver version: 3.61.84
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] getDB2Correlator () returned GA228845.H074.C77CF70C8B5A
[jcc][Connection@14eaec9] DB2 Application Correlator: GA228845.H074.C77CF70C8B5A.0000
[jcc][Connection@14eaec9] END TRACE_CONNECTS
[jcc][t4] DRDA manager levels: { SQLAM=7, AGENT=7, CMNTCPIP=5, RDB=7, SECMGR=7, XAMGR=7, SYNCPTMGR=7, RSYNCMGR=5 }
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] createStatement () called
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] createStatement () returned Statement@1295fe8
[jcc][SystemMonitor:start]
[jcc][Time:2011-03-18-10:22:45.434][Thread:AWT-EventQueue-0][Statement@1295fe8] executeQuery (select * from rpl_process ) called
[jcc] [t4][time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: EXCSQLIMM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 005BD05100010055 200A00442113C3C1 .[.Q...U ..D!... .$}...........CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
[jcc][t4] 0030 4040E2E8E2D3C8F2 F0F0404040404040 @@........@@@@@@ SYSLH200
[jcc][t4] 0040 404040405359534C 564C303101810005 @@@@SYSLVL01.... ...<.<...a..
[jcc][t4] 0050 2105F10008190080 000000 !.......... ..1........
[jcc][t4]
[jcc][t4] SEND BUFFER: SQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 002AD04300010024 2414000000001A53 .*.C...$$......S ..}.............
[jcc][t4] 0010 4554204355525245 4E54205041544820 ET CURRENT PATH ........+..&....
[jcc][t4] 0020 3D20646232747374 36FF = db2tst6. ..........
[jcc][t4]
[jcc][t4] SEND BUFFER: PRPSQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 0060D0510002005A 200D00442113C3C1 .`.Q...Z ..D!... .-}....!......CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
[jcc][t4] 0030 4040E2E8E2D3C8F2 F0F0404040404040 @@........@@@@@@ SYSLH200
[jcc][t4] 0040 404040405359534C 564C303100010005 @@@@SYSLVL01.... ...<.<......
[jcc][t4] 0050 2116F10005214604 0008190080000000 !....!F......... ..1.............
[jcc][t4]
[jcc][t4] SEND BUFFER: SQLATTR (ASCII) (EBCDIC)
[jcc][t4] 0000 001ED05300020018 2450000000000E46 ...S....$P.....F ..}......&......
[jcc][t4] 0010 4F52205245414420 4F4E4C5920FF OR READ ONLY . |.......|+<...
[jcc][t4]
[jcc][t4] SEND BUFFER: SQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 002AD04300020024 2414000000001A73 .*.C...$$......s ..}.............
[jcc][t4] 0010 656C656374202A20 66726F6D2072706C elect * from rpl .%........?_...%
[jcc][t4] 0020 5F70726F63657373 20FF _process . ...?......
[jcc][t4]
[jcc][t4] SEND BUFFER: OPNQRY (ASCII) (EBCDIC)
[jcc][t4] 0000 0063D0010003005D 200C00442113C3C1 .c.....] ..D!... ..}....)......CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
[jcc][t4] 0030 4040E2E8E2D3C8F2 F0F0404040404040 @@........@@@@@@ SYSLH200
[jcc][t4] 0040 404040405359534C 564C303100010008 @@@@SYSLVL01.... ...<.<......
[jcc][t4] 0050 211400007FFF0005 215D030008190080 !.......!]...... ...."....)......
[jcc][t4] 0060 000000 ... ...
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:45.481][Thread:AWT-EventQueue-0][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 000BD05300010005 2408FF ...S....$.. ..}........
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: MONITORRD (ASCII) (EBCDIC)
[jcc][t4] 0000 0016D04300010010 1C00000C19010000 ...C............ ..}.............
[jcc][t4] 0010 0000000042BF ....B. ......
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLDARD (ASCII) (EBCDIC)
[jcc][t4] 0000 0064D0530002005E 241100FFFFFF3434 .d.S...^$.....44 ..}....;........
[jcc][t4] 0010 3237303444534E58 4F544C2000FFFFFE 2704DSNXOTL .... ......+.|.<.....
[jcc][t4] 0020 0C00000000000000 00FFFFFFFF000000 ................ ................
[jcc][t4] 0030 0000000000202020 2020202020202020 ..... ................
[jcc][t4] 0040 000A434149434243 4442323200104C44 ..DB2SYS..LD ..............<.
[jcc][t4] 0050 344D2E52504C5F50 524F434553530000 4M.RPL_PROCESS.. .(..&<.&.|......
[jcc][t4] 0060 FFFF0000 .... ....
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: MONITORRD (ASCII) (EBCDIC)
[jcc][t4] 0000 0016D04300020010 1C00000C19010000 ...C............ ..}.............
[jcc][t4] 0010 000000003A25 ....:% ......
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: OPNQFLRM (ASCII) (EBCDIC)
[jcc][t4] 0000 0026D05200030020 2212000611490008 .&.R... "....I.. ..}.............
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 404040404040 @@@@@@
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC)
[jcc][t4] 0000 005FD00300030059 240800FFFFFDFE32 ._.....Y$......2 ..}.............
[jcc][t4] 0010 3635303144534E58 4552543200FFFFFE 6501DSNXERT2.... ......+.........
[jcc][t4] 0020 D000000000000000 00FFFFFFFF000000 ................ }...............
[jcc][t4] 0030 0000000000202020 2020202020202020 ..... ................
[jcc][t4] 0040 000A434149434243 44423232000E5351 ..DB2SYS..SQ ................
[jcc][t4] 0050 4C5F4355524C4832 303043310000FF L_CURLH200C1... <....<.........
[jcc][t4]
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] java.sql.SQLException
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] DB2 SQLCA from server
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlCode = -204
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrd = { -500, 0, 0, -1, 0, 0 }
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrmc = xyz1.RPL_PROCESS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrmcTokens = { xyz1.RPL_PROCESS }
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrp = DSNXOTL
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlState = 42704
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlWarn =
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] SQL state = 42704
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Error code = -204
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Tokens = xyz1.RPL_PROCESS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Stack trace follows
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=xyz1.RPL_PROCESS, DRIVER=3.61.84
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.hn.c(hn.java:2554)
at com.ibm.db2.jcc.am.hn.d(hn.java:2542)
at com.ibm.db2.jcc.am.hn.a(hn.java:2034)
at com.ibm.db2.jcc.am.hn.a(hn.java:2012)
at com.ibm.db2.jcc.t4.cb.g(cb.java:135)
at com.ibm.db2.jcc.t4.cb.a(cb.java:40)
at com.ibm.db2.jcc.t4.q.a(q.java:32)
at com.ibm.db2.jcc.t4.rb.i(rb.java:135)
at com.ibm.db2.jcc.am.hn.gb(hn.java:2005)
at com.ibm.db2.jcc.am.hn.a(hn.java:3029)
at com.ibm.db2.jcc.am.hn.a(hn.java:667)
at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:651)
at com.ABCD.jjjjjapps.models.JDBCAdapter.executeQuery(JDBCAdapter.java:80)
at com.ABCD.jjjjjapps.TableExample.fetch(TableExample.java:413)
at com.ABCD.jjjjjapps.TableExample$2.actionPerformed(TableExample.java:110)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:246)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[jcc] END TRACE_DIAGNOSTICS
[jcc][ResultSetMetaData@1c18a4c] BEGIN TRACE_RESULT_SET_META_DATA
[jcc][ResultSetMetaData@1c18a4c] Result set meta data for statement Statement@1295fe8
[jcc][ResultSetMetaData@1c18a4c] Number of result set columns: 0
isDescribed=true[jcc][ResultSetMetaData@1c18a4c] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=null, sqldSchema=null }
[jcc][ResultSetMetaData@1c18a4c] END TRACE_RESULT_SET_META_DATA
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] java.sql.SQLException
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] DB2 SQLCA from server
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlCode = -514
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrd = { -304, 0, 0, -1, 0, 0 }
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrmc = SQL_CURLH200C1
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrmcTokens = { SQL_CURLH200C1 }
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrp = DSNXERT2
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlState = 26501
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlWarn =
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] SQL state = 26501
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Error code = -514
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Tokens = SQL_CURLH200C1
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Stack trace follows
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.61.84
at com.ibm.db2.jcc.am.ed.a(ed.java:679)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.hn.c(hn.java:2554)
at com.ibm.db2.jcc.am.hn.a(hn.java:2061)
at com.ibm.db2.jcc.t4.cb.n(cb.java:844)
at com.ibm.db2.jcc.t4.cb.i(cb.java:265)
at com.ibm.db2.jcc.t4.cb.c(cb.java:54)
at com.ibm.db2.jcc.t4.q.c(q.java:44)
at com.ibm.db2.jcc.t4.rb.j(rb.java:147)
at com.ibm.db2.jcc.am.hn.ib(hn.java:2056)
at com.ibm.db2.jcc.am.hn.a(hn.java:3032)
at com.ibm.db2.jcc.am.hn.a(hn.java:667)
at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:651)
at com.ABCD.jjjjjapps.models.JDBCAdapter.executeQuery(JDBCAdapter.java:80)
at com.ABCD.jjjjjapps.TableExample.fetch(TableExample.java:413)
at com.ABCD.jjjjjapps.TableExample$2.actionPerformed(TableExample.java:110)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:246)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[jcc] END TRACE_DIAGNOSTICS
[jcc] [t4][time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: RDBCMM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 000AD00100010004 200E ........ . ..}.......
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: ENDUOWRM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 0030D0520001002A 220C000611490004 .0.R...*"....I.. ..}.............
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 4040404040400005 2115010005119FF2 @@@@@@..!....... .........2
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC)
[jcc][t4] 0000 000BD05300010005 2408FF ...S....$.. ..}........
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 0034D0030001002E 2414000000002453 .4......$.....$S ..}.............
[jcc][t4] 0010 4554204355525245 4E542046554E4354 ET CURRENT FUNCT ........+....+..
[jcc][t4] 0020 494F4E2050415448 203D224442325453 ION PATH ="DB2TS .|+.&...........
[jcc][t4] 0030 543622FF T6". ....
[jcc][t4]
[jcc][Connection@14eaec9] DB2 LUWID: GA228845.H074.C77CF70C8B5A.0001
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:204]parseSQLSTTList :
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:220]On Connection: : SET CURRENT FUNCTION PATH ="DB2TST6"
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:220]On Transport : : SET CURRENT FUNCTION PATH ="DB2TST6"
[jcc][SystemMonitor:stop] core: 69.488939ms | network: 42.952379ms | server: 31.972ms
[jcc] dsdriverConfigFile=null
[jcc] BEGIN TRACE_DRIVER_CONFIGURATION
[jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 3.61.84
[jcc] Compatible JRE versions: { 1.4, 1.5, 1.6 }
[jcc] Target server licensing restrictions: { z/OS: enabled; SQLDS: enabled; iSeries: enabled; DB2 for Unix/Windows: enabled; Cloudscape: enabled; Informix: enabled }
[jcc] Range checking enabled: true
[jcc] Bug check level: 0xff
[jcc] Default fetch size: 64
[jcc] Default isolation: 2
[jcc] Collect performance statistics: false
[jcc] No security manager detected.
[jcc] Detected local client host: AMACHIN/661.345.936.669
[jcc] Access to package sun.io is permitted by security manager.
[jcc] JDBC 1 system property jdbc.drivers = null
[jcc] Java Runtime Environment version 1.5.0_24-rev
[jcc] Java Runtime Environment vendor = Sun Microsystems Inc.
[jcc] Java vendor URL = http://java.sun.com/
[jcc] Java installation directory = C:\Program Files\Java\jdk1.5.0_24\jre
[jcc] Java Virtual Machine specification version = 1.0
[jcc] Java Virtual Machine specification vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine specification name = Java Virtual Machine Specification
[jcc] Java Virtual Machine implementation version = 1.5.0_24-rev-b04
[jcc] Java Virtual Machine implementation vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine implementation name = Java HotSpot(TM) Client VM
[jcc] Java Runtime Environment specification version = 1.5
[jcc] Java Runtime Environment specification vendor = Sun Microsystems Inc.
[jcc] Java Runtime Environment specification name = Java Platform API Specification
[jcc] Java class format version number = 49.0
[jcc] Java class path = .;jjjjj.jar;lib\ojdbc14.jar;lib\log4j.jar;lib\db2jcc.jar;lib\db2jcc_license_cisuz.jar;lib\db2jcc_javax.jar
[jcc] Java native library path = C:\Program Files\Java\jdk1.5.0_24\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_24\bin;C:\Oracle9\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\ant\apache-ant-1.7.0;C:\Program Files\E!TCP\;C:\Program Files\TortoiseSVN\bin
[jcc] Path of extension directory or directories = C:\Program Files\Java\jdk1.5.0_24\jre\lib\ext
[jcc] Operating system name = Windows XP
[jcc] Operating system architecture = x86
[jcc] Operating system version = 5.1
[jcc] File separator ("/" on UNIX) = \
[jcc] Path separator (":" on UNIX) = ;
[jcc] User's account name = xyz1
[jcc] User's home directory = C:\Documents and Settings\xyz1
[jcc] User's current working directory = c:\data\jjjjj
[jcc] JCC outputDirectory = C:\Temp\
[jcc] Loaded global properties file: C:\Data\jjjjj\DB2JccConfiguration.properties
[jcc] Using global properties:
[jcc] db2.jcc.traceFile = jccTrace_TableExample, file
[jcc] db2.jcc.traceDirectory = C:/Data/jjjjj/Trace, file
[jcc] db2.jcc.traceFileAppend = false, file
[jcc] db2.jcc.traceLevel = -1, file
[jcc] Dumping all system properties: { java.runtime.name=Java(TM) Platform, Standard Edition for Business, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_24\jre\bin, java.vm.version=1.5.0_24-rev-b04, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=US, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=c:\data\jjjjj, java.runtime.version=1.5.0_24-rev-b04, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, db2.jcc.propertiesFile=C:/Data/jjjjj/DB2JccConfiguration.properties, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_24\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\Temp\, line.separator=\r\n, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_24\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.5.0_24\bin;C:\Oracle9\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Windows Imaging\;C:\ant\apache-ant-1.7.0;C:\Program Files\E!TCP\;C:\Program Files\TortoiseSVN\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\xyz1, user.timezone=America/Los_Angeles, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, java.class.path=.;jjjjj.jar;lib\ojdbc14.jar;lib\log4j.jar;lib\db2jcc.jar;lib\db2jcc_license_cisuz.jar;lib\db2jcc_javax.jar, user.name=xyz1, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_24\jre, sun.arch.data.model=32, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.5.0_24-rev, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_24\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_24\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_24\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_24\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86 }
[jcc] Dumping all file properties: { db2.jcc.traceFileAppend=false, db2.jcc.traceFile=jccTrace_TableExample, db2.jcc.traceDirectory=C:/Data/jjjjj/Trace, db2.jcc.traceLevel=-1 }
[jcc] pureQuery present = false
[jcc] END TRACE_DRIVER_CONFIGURATION
[jcc] BEGIN TRACE_CONNECTS
[jcc] Attempting connection to ABCD:6666/DB2SYS
[jcc] Using properties: { currentPackagePath=null, currentLockTimeout=-2147483647, timerLevelForQueryTimeOut=0, optimizationProfileToFlush=null, timeFormat=1, monitorPort=0, sendCharInputsUTF8=0, LOCKSSFU=null, sendDataAsIs=false, stripTrailingZerosForDecimalNumbers=0, returnAlias=1, supportsAsynchronousXARollback=2, sessionTimeZone=null, pkList=null, atomicMultiRowInsert=0, DEBUG=null, IFX_UPDDESC=1, traceDirectory=null, maxRowsetSize=32767, driverType=4, extendedDiagnosticLevel=240, accountingInterval=null, monitoredDataSourceName=null, concurrentAccessResolution=0, LKNOTIFY=yes, clientProgramName=null, connectNode=-1, progressiveStreaming=0, DBMAXPROC=null, INFORMIXSTACKSIZE=null, databaseName=DB2SYS, IFX_XASTDCOMPLIANCE_XAEND=null, decimalSeparator=0, DBPATH=., emulateParameterMetaDataForZCalls=0, decimalRoundingMode=-2147483647, serverName=ABCD, DUMPDIR=null, allowUnassignedParameters=0, streamBufferSize=1048576, STMT_CACHE_DEBUG=null, downgradeHoldCursorsUnderXa=false, currentRefreshAge=-9223372036854775807, kerberosServerPrincipal=null, DB_LOCALE=null, description=null, DUMPCORE=null, queryCloseImplicit=0, keepDynamic=0, PSORT_NPROCS=null, user=xyz1, connectionCloseWithInFlightTransaction=0, fullyMaterializeLobData=true, enableClientAffinitiesList=0, clientUser=null, portNumber=6666, resultSetHoldability=0, allowNextOnExhaustedResultSet=0, NOSORTINDEX=null, enableConnectionConcentrator=false, monitorServerName=null, STMT_CACHE=null, PSORT_DBTEMP=null, sqljEnableClassLoaderSpecificProfiles=false, clientAccountingInformation=null, IFX_EXTDIRECTIVES=null, clientProgramId=null, IFX_DIRECTIVES=null, enableSeamlessFailover=0, GCORE=null, SQLSTATS=null, LOCKDOWN=no, currentExplainMode=null, SORTINDEX=null, timestampFormat=5, retryIntervalForClientReroute=-1, password=****, updateCountForBatch=0, reportLongTypes=0, xaNetworkOptimization=true, plugin=null, pdqProperties=null, currentSchema=null, CR_LOCKBLOB=null, traceLevel=-1, enableRowsetSupport=0, clientDebugInfo=null, dataSourceName=null, enableAlternateServerListFirstConnect=0, maxRetriesForClientReroute=-1, fetchSize=-1, queryDataSize=0, clientRerouteAlternateServerName=null, DBTEMP=/tmp, enableT2zosLBF=0, SUBQCACHESZ=10, ssid=null, currentMaintainedTableTypesForOptimization=null, traceFile=null, currentExplainSnapshot=null, DBDATE=Y4MD-, SLABEL=null, enableMultirowInsertSupport=true, currentFunctionPath=db2tst6, monitorEnabled=0, enableNamedParameterMarkers=0, PDQPRIORITY=null, supportsRawDateTimeRetrieval=false, useCachedCursor=true, pluginName=null, charOutputSize=0, maxTransportObjects=2147483647, NOSHMSG=null, resultSetHoldabilityForCatalogQueries=0, monitorLevel=0, IFX_FLAT_UCSQ=null, affinityFailbackInterval=0, planName=null, SQL_FROM_DBIMPORT=null, interruptProcessingMode=1, floatingPointStringFormat=0, currentPackageSet=null, timestampPrecisionReporting=0, clientRerouteAlternatePortNumber=null, useTransactionRedirect=false, dateTimeMutation=false, securityMechanism=3, statementConcentrator=0, timestampOutputType=0, allowNullResultSetForExecuteQuery=0, sysSchema=null, decimalStringFormat=0, blockingReadConnectionTimeout=0, DBANSIWARN=false, sslTrustStorePassword=null, DELIMIDENT=false, clientWorkstation=null, currentQueryOptimization=-2147483647, clientApplicationInformation=null, DUMPSHMEM=null, translateForBitData=0, monitorCollectionInterval=0, sslTrustStoreLocation=null, optimizationProfile=null, retrieveMessagesFromServerOnGetMessage=false, readOnly=false, INFORMIXOPCACHE=null, useRowsetCursor=true, traceFileAppend=false, clientRerouteServerListJNDIName=null, enableSysplexWLB=false, useJDBC4ColumnNameAndLabelSemantics=0, recordTemporalHistory=0, NODEFDAC=no, sslConnection=false, dateFormat=1, OPTOFC=null, cliSchema=null, retryWithAlternativeSecurityMechanism=0, DBSPACETEMP=null, enableExtendedIndicators=0, PLOAD_LO_PATH=null, encryptionAlgorithm=0, DBUPSPACE=null, cursorSensitivity=0, jdbcCollection=NULLID, fullyMaterializeInputStreams=false, currentSQLID=null, loginTimeout=0, useIdentityValLocalForAutoGeneratedKeys=false, OPTCOMPIND=null, LIGHT_SCANS=null, defaultIsolationLevel=2, deferPrepares=true, currentDegree=null, DUMPMEM=null }
[jcc] END TRACE_CONNECTS
[jcc][t4] [time:2011-03-18-10:22:33.950][Thread:main][tracepoint:950]searching the server list cache for key ABCD:6666
[jcc][t4] [time:2011-03-18-10:22:34.013][Thread:main][tracepoint:315]creating a socket to ABCD at 10.44.21.40
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: EXCSAT (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 009CD04100010096 10410048115E8482 ...A.....A.H.^.. ..}....o.....;db
[jcc][t4] 0010 F29183836D819797 93898381A3899695 ....m........... 2jcc_application
[jcc][t4] 0020 4040D1C3C3F0F3F6 F1F0F3F0F0000000 @@.............. JCC03610300...
[jcc][t4] 0030 0000000000000000 0000000000000000 ................ ................
[jcc][t4] 0040 0000000000000000 000000000060F0F0 .............`.. .............-00
[jcc][t4] 0050 F0F10016116DC1F1 F1F7F8F0F8404040 .....m.......@@@ 01..._AMACHIN
[jcc][t4] 0060 4040404040404040 000C115AD1C3C3F0 @@@@@@@@...Z.... ...!JCC0
[jcc][t4] 0070 F3F6F1F0001C1404 1403000A2407000A ............$... 3610............
[jcc][t4] 0080 1C0804B8240F0008 1440000914740008 ....$....@...t.. ......... ......
[jcc][t4] 0090 000C1147D8C4C2F2 61D1E5D4 ...G....a... ....QDB2/JVM
[jcc][t4]
[jcc][t4] SEND BUFFER: ACCSEC (ASCII) (EBCDIC)
[jcc][t4] 0000 0026D00100020020 106D000611A20003 .&..... .m...... ..}......_...s..
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 404040404040 @@@@@@
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: EXCSATRD (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 0092D0430001008C 14430044115EC4C2 ...C.....C.D.^.. .k}..........;DB
[jcc][t4] 0010 F2F24BC3C1C9C3C2 C3C4C2F2F2000000 ..K............. 22.DB2SYS...
[jcc][t4] 0020 0000000000000000 0000000000000000 ................ ................
[jcc][t4] 0030 0000000000000000 0000000000001800 ................ ................
[jcc][t4] 0040 0000000000000000 000000000000001C ................ ................
[jcc][t4] 0050 1404140300072407 00071C080000240F ......$.......$. ................
[jcc][t4] 0060 0007144000071474 000500081147D8C4 ...@...t.....G.. ... ..........QD
[jcc][t4] 0070 C2F20014116DC3C1 C9C3C2C3C4C2F2F2 .....m.......... B2..._DB2SYS
[jcc][t4] 0080 404040404040000C 115AC4E2D5F0F9F0 @@@@@@...Z...... ...!DSN090
[jcc][t4] 0090 F1F0 .. 10
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: ACCSECRD (ASCII) (EBCDIC)
[jcc][t4] 0000 0010D0030002000A 14AC000611A20003 ................ ..}..........s..
[jcc][t4]
[jcc] [t4][time:2011-03-18-10:22:34.028][Thread:main][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: SECCHK (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 003AD04100010034 106E000611A20003 .:.A...4.n...... ..}......>...s..
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 4040404040400008 11A09384F494000C @@@@@@.......... ....xyz1..
[jcc][t4] 0030 11A15C5C5C5C5C5C 5C5C ..\\\\\\\\ .~********
[jcc][t4]
[jcc][t4] SEND BUFFER: ACCRDB (ASCII) (EBCDIC)
[jcc][t4] 0000 00C7D001000200C1 200100162110C3C1 ........ ...!... .G}....A......CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 0006210F2407000C 112ED1C3C3F0F3F6 ..!.$........... ..........JCC036
[jcc][t4] 0030 F1F0007221046DD1 C3C3F0F3F6F1F0C1 ...r!.m......... 10...._JCC03610A
[jcc][t4] 0040 F1F1F7F8F0F84040 4040404040404040 ......@@@@@@@@@@ 117808
[jcc][t4] 0050 408482F29183836D 81979793898381A3 @......m........ db2jcc_applicat
[jcc][t4] 0060 89969540409384F4 944040404036D1C3 ...@@....@@@@6.. ion xyz1 .JC
[jcc][t4] 0070 C3F0F3F6F1F0C1F1 F1F7F8F0F8404040 .............@@@ C03610AMACHIN
[jcc][t4] 0080 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@
[jcc][t4] 0090 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@
[jcc][t4] 00A0 40404040000D002F D8E3C4E2D8D3C1E2 @@@@.../........ ....QTDSQLAS
[jcc][t4] 00B0 C300160035000611 9C04B80006119D04 ....5........... C...............
[jcc][t4] 00C0 B00006119E04B8 ....... .......
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:34.028][Thread:main][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:34.169][Thread:main][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: SECCHKRM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 0015D0420001000F 1219000611490000 ...B.........I.. ..}.............
[jcc][t4] 0010 000511A400 ..... ...u.
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: ACCRDBRM (ASCII) (EBCDIC)
[jcc][t4] 0000 00A0D0020002009A 2201000611490000 ........"....I.. ..}.............
[jcc][t4] 0010 000D002FD8E3C4E2 D8D3F3F7F0000C11 .../............ ....QTDSQL370...
[jcc][t4] 0020 2EC4E2D5F0F9F0F1 F000160035000611 ............5... .DSN09010.......
[jcc][t4] 0030 9C04B80006119E04 B80006119D04B000 ................ ................
[jcc][t4] 0040 172135C7C1F2F2F8 F8F4F54BC8F0F7F4 .!5........K.... ...GA228845.H074
[jcc][t4] 0050 C77CF70C8B5A001E 244E0006244C0001 .|...Z..$N..$L.. G@7..!...+...<..
[jcc][t4] 0060 0014244D0006244F FFFF000A11E80A2C ..$M..$O......., ...(...|.....Y..
[jcc][t4] 0070 1528139D00222103 00000000128C9AE8 .(..."!......... ...............Y
[jcc][t4] 0080 C7C1F2F2F8F8F4F5 C8F0F7F440404040 ............@@@@ GA228845H074
[jcc][t4] 0090 C77CF70C8B5A000A 11E80A2C1528139E .|...Z.....,.(.. G@7..!...Y......
[jcc][t4]
[jcc][Time:2011-03-18-10:22:34.169][Thread:main][Connection@14eaec9] getHostAddressFromIpaddr (6, { 0xa, 0x2c, 0x15, 0x28, 0x13, 0x9e }) called
[jcc][Time:2011-03-18-10:22:34.169][Thread:main][Connection@14eaec9] getHostAddressFromIpaddr () returned ABCD.ABCD.net
[jcc][Time:2011-03-18-10:22:34.185][Thread:main][Connection@14eaec9] setCurrentFunctionPath () called
[jcc][Connection@14eaec9] BEGIN TRACE_CONNECTS
[jcc][Connection@14eaec9] Successfully connected to server jdbc:db2://ABCD:6666/DB2SYS
[jcc][Connection@14eaec9] User: xyz1
[jcc][Connection@14eaec9] Database product name: DB2
[jcc][Connection@14eaec9] Database product version: DSN09010
[jcc][Connection@14eaec9] Driver name: IBM DB2 JDBC Universal Driver Architecture
[jcc][Connection@14eaec9] Driver version: 3.61.84
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] getDB2Correlator () returned GA228845.H074.C77CF70C8B5A
[jcc][Connection@14eaec9] DB2 Application Correlator: GA228845.H074.C77CF70C8B5A.0000
[jcc][Connection@14eaec9] END TRACE_CONNECTS
[jcc][t4] DRDA manager levels: { SQLAM=7, AGENT=7, CMNTCPIP=5, RDB=7, SECMGR=7, XAMGR=7, SYNCPTMGR=7, RSYNCMGR=5 }
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] createStatement () called
[jcc][Time:2011-03-18-10:22:34.200][Thread:main][Connection@14eaec9] createStatement () returned Statement@1295fe8
[jcc][SystemMonitor:start]
[jcc][Time:2011-03-18-10:22:45.434][Thread:AWT-EventQueue-0][Statement@1295fe8] executeQuery (select * from rpl_process ) called
[jcc] [t4][time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: EXCSQLIMM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 005BD05100010055 200A00442113C3C1 .[.Q...U ..D!... .$}...........CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
[jcc][t4] 0030 4040E2E8E2D3C8F2 F0F0404040404040 @@........@@@@@@ SYSLH200
[jcc][t4] 0040 404040405359534C 564C303101810005 @@@@SYSLVL01.... ...<.<...a..
[jcc][t4] 0050 2105F10008190080 000000 !.......... ..1........
[jcc][t4]
[jcc][t4] SEND BUFFER: SQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 002AD04300010024 2414000000001A53 .*.C...$$......S ..}.............
[jcc][t4] 0010 4554204355525245 4E54205041544820 ET CURRENT PATH ........+..&....
[jcc][t4] 0020 3D20646232747374 36FF = db2tst6. ..........
[jcc][t4]
[jcc][t4] SEND BUFFER: PRPSQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 0060D0510002005A 200D00442113C3C1 .`.Q...Z ..D!... .-}....!......CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
[jcc][t4] 0030 4040E2E8E2D3C8F2 F0F0404040404040 @@........@@@@@@ SYSLH200
[jcc][t4] 0040 404040405359534C 564C303100010005 @@@@SYSLVL01.... ...<.<......
[jcc][t4] 0050 2116F10005214604 0008190080000000 !....!F......... ..1.............
[jcc][t4]
[jcc][t4] SEND BUFFER: SQLATTR (ASCII) (EBCDIC)
[jcc][t4] 0000 001ED05300020018 2450000000000E46 ...S....$P.....F ..}......&......
[jcc][t4] 0010 4F52205245414420 4F4E4C5920FF OR READ ONLY . |.......|+<...
[jcc][t4]
[jcc][t4] SEND BUFFER: SQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 002AD04300020024 2414000000001A73 .*.C...$$......s ..}.............
[jcc][t4] 0010 656C656374202A20 66726F6D2072706C elect * from rpl .%........?_...%
[jcc][t4] 0020 5F70726F63657373 20FF _process . ...?......
[jcc][t4]
[jcc][t4] SEND BUFFER: OPNQRY (ASCII) (EBCDIC)
[jcc][t4] 0000 0063D0010003005D 200C00442113C3C1 .c.....] ..D!... ..}....)......CA
[jcc][t4] 0010 C9C3C2C3C4C2F2F2 4040404040404040 ........@@@@@@@@ ABCDDB22
[jcc][t4] 0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
[jcc][t4] 0030 4040E2E8E2D3C8F2 F0F0404040404040 @@........@@@@@@ SYSLH200
[jcc][t4] 0040 404040405359534C 564C303100010008 @@@@SYSLVL01.... ...<.<......
[jcc][t4] 0050 211400007FFF0005 215D030008190080 !.......!]...... ...."....)......
[jcc][t4] 0060 000000 ... ...
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:45.450][Thread:AWT-EventQueue-0][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:45.481][Thread:AWT-EventQueue-0][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 000BD05300010005 2408FF ...S....$.. ..}........
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: MONITORRD (ASCII) (EBCDIC)
[jcc][t4] 0000 0016D04300010010 1C00000C19010000 ...C............ ..}.............
[jcc][t4] 0010 0000000042BF ....B. ......
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLDARD (ASCII) (EBCDIC)
[jcc][t4] 0000 0064D0530002005E 241100FFFFFF3434 .d.S...^$.....44 ..}....;........
[jcc][t4] 0010 3237303444534E58 4F544C2000FFFFFE 2704DSNXOTL .... ......+.|.<.....
[jcc][t4] 0020 0C00000000000000 00FFFFFFFF000000 ................ ................
[jcc][t4] 0030 0000000000202020 2020202020202020 ..... ................
[jcc][t4] 0040 000A434149434243 4442323200104C44 ..DB2SYS..LD ..............<.
[jcc][t4] 0050 344D2E52504C5F50 524F434553530000 4M.RPL_PROCESS.. .(..&<.&.|......
[jcc][t4] 0060 FFFF0000 .... ....
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: MONITORRD (ASCII) (EBCDIC)
[jcc][t4] 0000 0016D04300020010 1C00000C19010000 ...C............ ..}.............
[jcc][t4] 0010 000000003A25 ....:% ......
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: OPNQFLRM (ASCII) (EBCDIC)
[jcc][t4] 0000 0026D05200030020 2212000611490008 .&.R... "....I.. ..}.............
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 404040404040 @@@@@@
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC)
[jcc][t4] 0000 005FD00300030059 240800FFFFFDFE32 ._.....Y$......2 ..}.............
[jcc][t4] 0010 3635303144534E58 4552543200FFFFFE 6501DSNXERT2.... ......+.........
[jcc][t4] 0020 D000000000000000 00FFFFFFFF000000 ................ }...............
[jcc][t4] 0030 0000000000202020 2020202020202020 ..... ................
[jcc][t4] 0040 000A434149434243 44423232000E5351 ..DB2SYS..SQ ................
[jcc][t4] 0050 4C5F4355524C4832 303043310000FF L_CURLH200C1... <....<.........
[jcc][t4]
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] java.sql.SQLException
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] DB2 SQLCA from server
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlCode = -204
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrd = { -500, 0, 0, -1, 0, 0 }
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrmc = xyz1.RPL_PROCESS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrmcTokens = { xyz1.RPL_PROCESS }
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlErrp = DSNXOTL
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlState = 42704
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23][Sqlca@457d21] SqlWarn =
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] SQL state = 42704
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Error code = -204
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Tokens = xyz1.RPL_PROCESS
[jcc][Thread:AWT-EventQueue-0][SQLException@104fc23] Stack trace follows
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=xyz1.RPL_PROCESS, DRIVER=3.61.84
at com.ibm.db2.jcc.am.ed.a(ed.java:676)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.hn.c(hn.java:2554)
at com.ibm.db2.jcc.am.hn.d(hn.java:2542)
at com.ibm.db2.jcc.am.hn.a(hn.java:2034)
at com.ibm.db2.jcc.am.hn.a(hn.java:2012)
at com.ibm.db2.jcc.t4.cb.g(cb.java:135)
at com.ibm.db2.jcc.t4.cb.a(cb.java:40)
at com.ibm.db2.jcc.t4.q.a(q.java:32)
at com.ibm.db2.jcc.t4.rb.i(rb.java:135)
at com.ibm.db2.jcc.am.hn.gb(hn.java:2005)
at com.ibm.db2.jcc.am.hn.a(hn.java:3029)
at com.ibm.db2.jcc.am.hn.a(hn.java:667)
at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:651)
at com.ABCD.jjjjjapps.models.JDBCAdapter.executeQuery(JDBCAdapter.java:80)
at com.ABCD.jjjjjapps.TableExample.fetch(TableExample.java:413)
at com.ABCD.jjjjjapps.TableExample$2.actionPerformed(TableExample.java:110)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:246)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[jcc] END TRACE_DIAGNOSTICS
[jcc][ResultSetMetaData@1c18a4c] BEGIN TRACE_RESULT_SET_META_DATA
[jcc][ResultSetMetaData@1c18a4c] Result set meta data for statement Statement@1295fe8
[jcc][ResultSetMetaData@1c18a4c] Number of result set columns: 0
isDescribed=true[jcc][ResultSetMetaData@1c18a4c] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=null, sqldSchema=null }
[jcc][ResultSetMetaData@1c18a4c] END TRACE_RESULT_SET_META_DATA
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] java.sql.SQLException
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] DB2 SQLCA from server
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlCode = -514
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrd = { -304, 0, 0, -1, 0, 0 }
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrmc = SQL_CURLH200C1
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrmcTokens = { SQL_CURLH200C1 }
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlErrp = DSNXERT2
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlState = 26501
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7][Sqlca@1fa681c] SqlWarn =
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] SQL state = 26501
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Error code = -514
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Tokens = SQL_CURLH200C1
[jcc][Thread:AWT-EventQueue-0][SQLException@15e92d7] Stack trace follows
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.61.84
at com.ibm.db2.jcc.am.ed.a(ed.java:679)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.am.hn.c(hn.java:2554)
at com.ibm.db2.jcc.am.hn.a(hn.java:2061)
at com.ibm.db2.jcc.t4.cb.n(cb.java:844)
at com.ibm.db2.jcc.t4.cb.i(cb.java:265)
at com.ibm.db2.jcc.t4.cb.c(cb.java:54)
at com.ibm.db2.jcc.t4.q.c(q.java:44)
at com.ibm.db2.jcc.t4.rb.j(rb.java:147)
at com.ibm.db2.jcc.am.hn.ib(hn.java:2056)
at com.ibm.db2.jcc.am.hn.a(hn.java:3032)
at com.ibm.db2.jcc.am.hn.a(hn.java:667)
at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:651)
at com.ABCD.jjjjjapps.models.JDBCAdapter.executeQuery(JDBCAdapter.java:80)
at com.ABCD.jjjjjapps.TableExample.fetch(TableExample.java:413)
at com.ABCD.jjjjjapps.TableExample$2.actionPerformed(TableExample.java:110)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:246)
at java.awt.Component.processMouseEvent(Component.java:5517)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3129)
at java.awt.Component.processEvent(Component.java:5282)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3984)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1791)
at java.awt.Component.dispatchEvent(Component.java:3819)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[jcc] END TRACE_DIAGNOSTICS
[jcc] [t4][time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:1][Request.flush]
[jcc][t4] SEND BUFFER: RDBCMM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 000AD00100010004 200E ........ . ..}.......
[jcc][t4]
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:101]Request flushed.
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:102]Reply to be filled.
[jcc] [t4][time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:2][Reply.fill]
[jcc][t4] RECEIVE BUFFER: ENDUOWRM (ASCII) (EBCDIC)
[jcc][t4] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
[jcc][t4] 0000 0030D0520001002A 220C000611490004 .0.R...*"....I.. ..}.............
[jcc][t4] 0010 00162110C3C1C9C3 C2C3C4C2F2F24040 ..!...........@@ ....DB2SYS
[jcc][t4] 0020 4040404040400005 2115010005119FF2 @@@@@@..!....... .........2
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLCARD (ASCII) (EBCDIC)
[jcc][t4] 0000 000BD05300010005 2408FF ...S....$.. ..}........
[jcc][t4]
[jcc][t4] RECEIVE BUFFER: SQLSTT (ASCII) (EBCDIC)
[jcc][t4] 0000 0034D0030001002E 2414000000002453 .4......$.....$S ..}.............
[jcc][t4] 0010 4554204355525245 4E542046554E4354 ET CURRENT FUNCT ........+....+..
[jcc][t4] 0020 494F4E2050415448 203D224442325453 ION PATH ="DB2TS .|+.&...........
[jcc][t4] 0030 543622FF T6". ....
[jcc][t4]
[jcc][Connection@14eaec9] DB2 LUWID: GA228845.H074.C77CF70C8B5A.0001
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:204]parseSQLSTTList :
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:220]On Connection: : SET CURRENT FUNCTION PATH ="DB2TST6"
[jcc][t4] [time:2011-03-18-10:22:45.512][Thread:AWT-EventQueue-0][tracepoint:220]On Transport : : SET CURRENT FUNCTION PATH ="DB2TST6"
[jcc][SystemMonitor:stop] core: 69.488939ms | network: 42.952379ms | server: 31.972ms