Установил DB2-Express-C 9.74 под Windows 2008 R2 (с включенным Hyper-V). Вся установка по стандарту.

Подключил базу с удаленного узла DB2.

При вызове коннекта неимоверное просто ожидание, т.е. выполняю db2cmd -> db2 connect to mydb user myuser using ***** и ничего, висим минуту!!!, а узел в локальной сети, старые сервера win2003 на ура соединяются 1-2 сек. Куда рыть даже и не знаю.

Заметил еще такой момент, если первый запуск db2cmd и вызов коннекта первый, соединяется в пределах нормы 2-3 сек. , последующие вызовы коннекта провисают неимоверно.

Мониторил это добро - сам процесс db2bp.exe, procmon -ом из поставки sysinternals, особых отличий между нормальной работой не нашел, кроме того что перед зависанием завершается пара потоков.

Куда еще порыть ? Что поглядеть ?

Евгений Хабаров,

Спасибо за ответ и за утилиту. Результаты запуска такие:

====1 запуск======

2011-08-19 20:54:13.073: Begin.
2011-08-19 20:54:13.26: Driver loaded.
2011-08-19 20:54:37.736: Connected.
2011-08-19 20:54:37.752: Statement created.
2011-08-19 20:54:37.799: Resultset received.
2011-08-19 20:54:37.799: Result : 20:54:37
2011-08-19 20:54:37.799: Resultset closed.
2011-08-19 20:54:37.799: Statement closed.
2011-08-19 20:54:37.799: Connection closed.

===2 запуск=======

2011-08-19 21:02:12.211: Begin.
2011-08-19 21:02:12.43: Driver loaded.
2011-08-19 21:02:36.625: Connected.
2011-08-19 21:02:36.641: Statement created.
2011-08-19 21:02:36.688: Resultset received.
2011-08-19 21:02:36.688: Result : 21:02:36
2011-08-19 21:02:36.703: Resultset closed.
2011-08-19 21:02:36.703: Statement closed.
2011-08-19 21:02:36.703: Connection closed.

и там и там пометил момент подключения, задержка 20 секунд, коннект был по IP, умышленно, что-бы исключить проблемы с DNS. Т.е. результат опять не очень - 20 секунд это очень долго для локальной сети. Протокол работы самой утилиты я не очень понял:

[jcc] BEGIN TRACE_XML_CONFIGURATION_FILE
[jcc] dsdriverConfigFile=null

[jcc] BEGIN TRACE_DRIVER_CONFIGURATION
[jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 3.62.56
[jcc] Compatible JRE versions: { 1.4, 1.5, 1.6 }
[jcc] Target server licensing restrictions: { z/OS: disabled; SQLDS: disabled; iSeries: disabled; 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: SW01342108002/10.13.142.2
[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.6.0_27
[jcc] Java Runtime Environment vendor = Sun Microsystems Inc.
[jcc] Java vendor URL = http://java.sun.com/
[jcc] Java installation directory = C:\Program Files\Java\jre6
[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 = 20.2-b06
[jcc] Java Virtual Machine implementation vendor = Sun Microsystems Inc.
[jcc] Java Virtual Machine implementation name = Java HotSpot(TM) 64-Bit Server VM
[jcc] Java Runtime Environment specification version = 1.6
[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 = 50.0
[jcc] Java class path = .;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar
[jcc] Java native library path = C:\Program Files\Java\jre6\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0\;c:\program files\ibm\gsk8\lib64;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;.
[jcc] Path of extension directory or directories = C:\Program Files\Java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext
[jcc] Operating system name = Windows Server 2008 R2
[jcc] Operating system architecture = amd64
[jcc] Operating system version = 6.1
[jcc] File separator ("/" on UNIX) = \
[jcc] Path separator (":" on UNIX) = ;
[jcc] User's account name = db2admin
[jcc] User's home directory = C:\Users\db2admin
[jcc] User's current working directory = C:\Users\db2admin\Desktop
[jcc] JCC outputDirectory = C:\Users\db2admin\AppData\Local\Temp\
[jcc] Dumping all system properties: { java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=20.2-b06, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, sun.java.launcher=SUN_STANDARD, user.country=RU, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Users\db2admin\Desktop, java.runtime.version=1.6.0_27-b07, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jre6\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\db2admin\AppData\Local\Temp\, line.separator=\r\n, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows Server 2008 R2, sun.jnu.encoding=Cp1251, java.library.path=C:\Program Files\Java\jre6\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0\;c:\program files\ibm\gsk8\lib64;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;., java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=6.1, user.home=C:\Users\db2admin, user.timezone=Europe/Moscow, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1251, java.specification.version=1.6, java.class.path=.;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar, user.name=db2admin, java.vm.specification.version=1.0, , java.home=C:\Program Files\Java\jre6, sun.arch.data.model=64, user.language=ru, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.6.0_27, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\lib\modules\jdk.boot.jar;C:\Program Files\Java\jre6\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=amd64 }
[jcc] Dumping all file properties: { }
[jcc] pureQuery present = false
[jcc] END TRACE_DRIVER_CONFIGURATION
[jcc] BEGIN TRACE_CONNECTS
[jcc] Attempting connection to 192.168.0.11:50000/toolsdb
[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=toolsdb, IFX_XASTDCOMPLIANCE_XAEND=null, decimalSeparator=0, DBPATH=., emulateParameterMetaDataForZCalls=0, decimalRoundingMode=-2147483647, serverName=192.168.0.11, 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=db2admin, connectionCloseWithInFlightTransaction=0, fullyMaterializeLobData=true, enableClientAffinitiesList=0, clientUser=null, portNumber=50000, 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=58295, enableRowsetSupport=0, clientDebugInfo=null, dataSourceName=null, enableAlternateServerListFirstConnect=0, maxRetriesForClientReroute=-1, fetchSize=-1, queryDataSize=0, queryTimeoutInterruptProcessingMode=1, clientRerouteAlternateServerName=null, DBTEMP=/tmp, enableT2zosLBF=0, SUBQCACHESZ=10, ssid=null, currentMaintainedTableTypesForOptimization=null, traceFile=TestCon_trc.txt, currentExplainSnapshot=null, DBDATE=Y4MD-, SLABEL=null, enableMultirowInsertSupport=true, currentFunctionPath=null, 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][Connection@6910fe28] BEGIN TRACE_CONNECTS
[jcc][Connection@6910fe28] Successfully connected to server jdbc:db2://192.168.0.11:50000/toolsdb
[jcc][Connection@6910fe28] User: db2admin
[jcc][Connection@6910fe28] Database product name: DB2/NT
[jcc][Connection@6910fe28] Database product version: SQL08029
[jcc][Connection@6910fe28] Driver name: IBM DB2 JDBC Universal Driver Architecture
[jcc][Connection@6910fe28] Driver version: 3.62.56
[jcc][Time:2011-08-19-21:02:36.625][Thread:main][Connection@6910fe28] getDB2Correlator () returned GA0D8E02.LCDB.110819170236
[jcc][Connection@6910fe28] DB2 Application Correlator: GA0D8E02.LCDB.110819170236.0000
[jcc][Connection@6910fe28] 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-08-19-21:02:36.625][Thread:main][Connection@6910fe28] setDB2ClientWorkstation (null) called
[jcc][Time:2011-08-19-21:02:36.641][Thread:main][Connection@6910fe28] createStatement () called
[jcc][Time:2011-08-19-21:02:36.641][Thread:main][Connection@6910fe28] createStatement () returned Statement@630045eb
[jcc][Time:2011-08-19-21:02:36.641][Thread:main][Statement@630045eb] executeQuery (SELECT CURRENT TIME FROM SYSIBM.SYSDUMMY1) called
[jcc][ResultSetMetaData@1be1a408] BEGIN TRACE_RESULT_SET_META_DATA
[jcc][ResultSetMetaData@1be1a408] Result set meta data for statement Statement@630045eb
[jcc][ResultSetMetaData@1be1a408] Number of result set columns: 1
isDescribed=true[jcc][ResultSetMetaData@1be1a408] Column 1: { label=1, name=1, type name=TIME, type=92, nullable=0, precision=8, scale=0, schema name=, table name=, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=8, sqlType=388, sqlCcsid=1251, sqlArrExtent=<null>, sqlName=1, sqlLabel=null, sqlUnnamed=1, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxOptlck=0, sqlxCorname=null, sqlxName=null, sqlxBasename=null, sqlxUpdatable=0, sqlxSchema=null, sqlxRdbnam=TOOLSDB, internal type=92, is locator parameter=false }
[jcc][ResultSetMetaData@1be1a408] { sqldHold=1, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=85, sqldKeytype=0, sqldRdbnam=, sqldSchema=null }
[jcc][ResultSetMetaData@1be1a408] END TRACE_RESULT_SET_META_DATA
[jcc][Time:2011-08-19-21:02:36.688][Thread:main][Statement@630045eb] executeQuery () returned ResultSet@6513cf0
[jcc][Time:2011-08-19-21:02:36.688][Thread:main][ResultSet@6513cf0] next () called
[jcc][Time:2011-08-19-21:02:36.688][Thread:main][ResultSet@6513cf0] next () returned true
[jcc][Time:2011-08-19-21:02:36.688][Thread:main][ResultSet@6513cf0] getString (1) called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] getString () returned 21:02:36
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] next () called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] closeX (null, com.ibm.db2.jcc.t4.b@6910fe28) called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] completeLocalCommit (false, true) called
[jcc][Connection@6910fe28] DB2 LUWID: GA0D8E02.LCDB.110819170236.0001
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] markClosed () called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] next () returned false
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] close () called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][ResultSet@6513cf0] closeX (null, com.ibm.db2.jcc.t4.b@6910fe28) called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][Statement@630045eb] close () called
[jcc][Time:2011-08-19-21:02:36.703][Thread:main][Connection@6910fe28] close () called
[jcc][Connection@6910fe28] DB2 LUWID: GA0D8E02.LCDB.110819170236.0002
[jcc][Connection@6910fe28] DB2 LUWID: GA0D8E02.LCDB.110819170236.0003

P.S. Для чистоты эксперемента удалил виртуальную сеть Hyper-V, результат тот-же....

Что еще поглядеть ??

Hunterik,

Да в том то и дело что база уже поднята, там работают пользователи, я создал еще один сервер 2008 R2 на VirtualBox-е, накатил ту-же db2 и он гад почему-то работает нормально !!! Я просто уже не понимаю, в чем трабла ? Сервера из одной компашки, db2 - из одного дистриба, брендмауэр отрубил у всех ....

Hunterik,

первым делом проверил, коннект по порту 50000 к удаленному серверу проходит без задержек, выполнил 4 замера, все одинаково по времени отклика.

Нашел причину, от чего зависят тормоза, где исправить правда пока не нашел. Причина в домене. Если сервер в домене (АД на Win2008) то тормозит безбожно, если не в домене все пашет на ура. Пока перелопатил настройки брендмауэр и политики домена, ущу дальше.