How can we help you today?
Cannot connect to DB2 database even though server is pingable
1 Comment
Hans Bergsten
said
about 10 years ago
[This reply is migrated from our old forums.]
Re: Cannot connect to DB2 database even though server is pingable
Re: Cannot connect to DB2 database even though server is pingable
Hi Walter,
The error message is produced by the JDBC driver, so maybe you can get some help from the driver vendor. I suggest that you first upgrade DbVisualizer to the latest version and make sure that you have the latest driver version for your database.
Best Regards,
Hans
anonymous
creator of the JavaTM Graph Visualization Library yFiles, the UML-enabled
JavadocTM extension yDoc and the free Java obfuscation Ant task, yGuard
http://www.yworks.com
This application uses the Alloy Look & Feel from INCORS
http://www.incors.com
This product includes software developed by the Apache Software Foundation
http://www.apache.org
This product includes software developed by Sun Microsystems Inc.
http://www.sun.com
This product includes software developed by the NetBeans Community
http://www.netbeans.org
This product includes software developed by the JDOM project
http://www.jdom.org
This product includes software developed by JGoodies
http://www.jgoodies.com
This product includes software developed by OGNL.org
http://www.ognl.org
This product includes software developed by JIDE Software
http://www.jidesoft.com, dbvis.pervasive.PrependTableNames=true, dbvis.netezza.RunAtConnect=, dbvis.jdatastore.SinglePhysicalConnection=false, dbvis.h2.RequireUserid=false, dbvis.netezza.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.pervasive.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, log4j.appender.dbvis=org.apache.log4j.ConsoleAppender, dbvis.maxdb.ConnectWhenConnectAll=false, dbvis.jdatastore.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.db2.ScriptingPrependObjectName=false, dbvis.sybase-iq.SPBinaryEncoding=, dbvis.GenerateSqlWithVariables=true, dbvis.oracle.DateAsTimestamp=true, dbvis.neoview.RunAtDisconnect=, dbvis.sybase-asa.RemoveNewLineChars=false, exe4j.processCommFile=C:\Users\wpahk\AppData\Local\Temp\e4j_p6652.tmp, dbvis.SQLCommanderAppearance=tabs, dbvis.db2-iseries.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.KeymapName=$default$, dbvis.generic.ColorCriticalNodes=true, dbvis.progress.ConnectionMode=Development, dbvis.db2-iseries.ExplainSchema=, dbvis.hsql.QueryBuilderDialect=, dbvis.db2-zos.RequireUserid=false, dbvis.pervasive.QueryBuilderUseJoinClause=true, dbvis.db2.InlineEditorCommitBatchSize=100, dbvis.PrettySpaceOperator=Keep Unchanged, dbvis.-MonospaceFontMacOSX=Menlo-plain-12;Monaco-plain-12, dbvis.sybase-asa.CriticalThreshold=20, dbvis.informix.SetSchema=true, dbvis.cache.ExplainSchema=, dbvis.mimer.DefaultCatalogsSchemasVisible=false, dbvis.sybase-asa.CreateExplainTable=true, dbvis.SQLEditorExpandTab=true, dbvis.SQLHistoryMaxFiles=300, dbvis.pervasive.RequirePassword=false, dbvis.sybase-iq.AutoJoinEnabled=false, dbvis.neoview.CharForBitDataAsText=false, dbvis.mysql.RequirePassword=false, dbvis.h2.CriticalThreshold=20, dbvis.firebird.ShowEmptySchemas=true, dbvis.generic.DropExplainTable=false, dbvis.maxdb.ShowEmptySchemas=true, dbvis.derby.DelimitedIdentifierBegin=", dbvis.postgresql.ExportPrependObjectName=false, dbvis.informix.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.db2-zos.ExplainTable=, dbvis.neoview.ExplainTable=, dbvis.db2-zos.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, exe4j.semaphoreName=Local\c:_program_files_dbvisualizer-8.0.12_dbvis.exe, dbvis.oracle.AuthenticationMethod=SQL Server, dbvis.informix.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.sybase-ase.AuthenticationMethod=SQL Server, dbvis.sqlite.DateAsTimestamp=true, dbvis.pervasive.SinglePhysicalConnection=false, dbvis.BooleanTrueFormat=true, dbvis.informix.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.sqlserver.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.neoview.DelimitedIdentifierBegin=", dbvis.db2-iseries.SetSchema=true, log4j.logpattern.1=Full=%d{HH:mm:ss} [%p %t %c{1}.%M] %m%n, log4j.logpattern.0=Basic=%d{HH:mm:ss} [%p] %m%n, dbvis.db2-iseries.QueryBuilderDialect=, dbvis.VariableFormWindowGeometry=, dbvis.cache.ObjectTreeLabels=, dbvis.frontbase.SetSchema=true, dbvis.db2-zos.PrependColumnNames=true, dbvis.db2.SystemTablePrefix=, dbvis.GraphSearchAutoZoom=true, dbvis.sqlite.ScriptingPrependObjectName=false, dbvis.generic.ConnectWhenConnectAll=false, dbvis.progress.DelimitedIdentifierBegin=", dbvis.ObjectActionsPreviewEnabled=false, dbvis.generic.ConnectionMode=Development, dbvis.postgresql.RunConnectHook=true, dbvis.sybase-asa.AutoCommit=true, dbvis.informix.AutoCommitOffWarning=true, dbvis.mysql.ConnectWhenConnectAll=false, dbvis.informix.TransactionIsolation=TRANSACTION_NONE, dbvis.sybase-ase.ConfirmDropProcedureForEdit=true, dbvis.cache.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.derby.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.derby.AutoCommitOffWarningAlways=false, dbvis.jdatastore.PrependColumnNames=true, dbvis.frontbase.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.GridColumnLabelIsColumnAlias=true, dbvis.firebird.CharForBitDataAsText=false, dbvis.db2-zos.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.informix.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.maxdb.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.hsql.GraphPrependObjectName=false, dbvis.format.datetime.info.9=AM/PM marker, dbvis.oracle.QueryBuilderUseJoinClause=true, dbvis.maxdb.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, dbvis.format.datetime.info.8=Day in week, dbvis.format.datetime.info.7=Day of week in month, dbvis.format.datetime.info.6=Day in month, dbvis.format.datetime.info.5=Day in year, dbvis.informix.WarningThreshold=5, dbvis.format.datetime.info.4=Week in month, dbvis.format.datetime.info.3=Week in year, dbvis.format.datetime.info.2=Month in year, dbvis.netezza.DelimitedIdentifierEnd=", dbvis.format.datetime.info.1=Year, dbvis.hsql.ScriptingPrependObjectName=false, dbvis.format.datetime.info.0=Era Designator, dbvis.firebird.SinglePhysicalConnection=false, dbvis.db2.RunDisconnectHook=true, dbvis.db2-iseries.ConnectionPassword=Save Between Sessions, dbvis.sqlserver.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.sqlite.SetSchema=true, dbvis.derby.DateAsTimestamp=true, dbvis.h2.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.jdatastore.AutoJoinType=ByKeys, dbvis.netezza.RunConnectHook=true, dbvis.maxdb.DateAsTimestamp=true, dbvis.hsql.CharForBitDataAsText=false, dbvis.sqlite.ConfirmDropProcedureForEdit=true, dbvis.db2-zos.RunAtDisconnect=, dbvis.db2.AutoCommit=true, dbvis.derby.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.derby.TransactionIsolation=TRANSACTION_NONE, dbvis.ScriptsModifierDoubleClickAction=NewEditor, dbvis.firebird.ConfirmDropProcedureForEdit=true, dbvis.oracle.QueryBuilderDialect=oracle, dbvis.SSHKeepAliveInterval=60, sun.jnu.encoding=Cp1252, java.specification.version=1.6, dbvis.sybase-asa.ExportPrependObjectName=false, dbvis.hsql.RemoveNewLineChars=false, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, dbvis.sybase-asa.DropExplainTable=false, dbvis.sqlserver.ConnectionPassword=Save Between Sessions, dbvis.neoview.GraphPrependObjectName=false, dbvis.frontbase.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.format.number.pattern.2=Unformatted, dbvis.frontbase.ScriptingPrependObjectName=false, dbvis.generic.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, dbvis.format.number.pattern.1=#,###, dbvis.cache.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.db2-iseries.AutoJoinType=ByKeys, dbvis.DriverManagerDisplayOnError=false, dbvis.format.number.pattern.0=####, dbvis.progress.DelimitedIdentifierEnd=", dbvis.sybase-asa.TransactionIsolation=TRANSACTION_NONE, dbvis.db2-iseries.ObjectTreeLabels=, dbvis.neoview.RequireUserid=false, dbvis.postgresql.SinglePhysicalConnection=false, dbvis.DataMaxRowsInitial=-1, dbvis.progress.TransactionIsolation=TRANSACTION_NONE, dbvis.sqlserver.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.frontbase.RequireUserid=false, dbvis.neoview.SPBinaryEncoding=, dbvis.AutoCompletionAutoPopup=false, dbvis.derby.DelimitedIdentifiersExport=false, dbvis.db2-iseries.AutoJoinEnabled=false, dbvis.ShowBlobType=Size, dbvis.h2.ObjectTreeLabels=, dbvis.postgresql.RemoveNewLineChars=false, dbvis.frontbase.RunConnectHook=true, dbvis.db2.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.frontbase.PrependTableNames=true, dbvis.cache.TransactionIsolation=TRANSACTION_NONE, dbvis.mimer.AuthenticationMethod=SQL Server, dbvis.postgresql.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.PrettyBreakBeforeConcat=false, dbvis.jdatastore.RunAtDisconnect=, dbvis.derby.ColorCriticalNodes=true, dbvis.h2.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-iq.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.mysql.IgnoreMaxRowsForNonSELECT=false, dbvis.frontbase.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.maxdb.SinglePhysicalConnection=false, dbvis.format.datetime.letter.18=Z, dbvis.format.datetime.letter.17=z, dbvis.MaxCharsTruncatesValue=TruncateValuesVisually, dbvis.format.datetime.letter.16=S, dbvis.format.datetime.letter.15=s, dbvis.format.datetime.letter.14=m, dbvis.format.datetime.letter.13=h, dbvis.format.datetime.letter.12=K, dbvis.netezza.QueryBuilderUseJoinClause=true, dbvis.format.datetime.letter.11=k, dbvis.generic.ConfirmDropProcedureForEdit=true, dbvis.sybase-asa.ShowEmptySchemas=true, dbvis.format.datetime.letter.10=H, dbvis.db2-iseries.SinglePhysicalConnection=false, dbvis.sqlserver.WarningThreshold=5, dbvis.mysql.ShowEmptySchemas=true, dbvis.cache.DelimitedIdentifiersBehindTheScene=true, dbvis.postgresql.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.mimer.GraphPrependObjectName=false, dbvis.mimer.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.frontbase.SinglePhysicalConnection=false, exe4j.unextractedPosition=0, dbvis.jdatastore.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.sybase-iq.DelimitedIdentifiersBehindTheScene=true, dbvis.mysql.SystemTablePrefix=, dbvis.informix.RunAtConnect=, dbvis.generic.AutoCommitOffWarningAlways=false, dbvis.hsql.RequireUserid=false, dbvis.pervasive.CharForBitDataAsText=false, dbvis.GridNullBorder=, dbvis.mysql.InlineEditorCommitBatchSize=100, dbvis.db2-iseries.AutoCommitOffWarningAlways=false, dbvis.GridLinesColor=#d9d9d9, dbvis.informix.DelimitedIdentifierBegin=", dbvis.maxdb.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.SQLLineComment2=//, dbvis.cache.AutoCommit=true, dbvis.SQLLineComment1=--, dbvis.postgresql.WarningThreshold=5, dbvis.generic.CharForBitDataAsText=false, dbvis.mysql.CharForBitDataAsText=false, dbvis.progress.ExplainSchema=, dbvis.sybase-asa.RequirePassword=false, dbvis.format.timestamp.pattern.9=yyyyMMdd HHmmss, dbvis.derby.RunConnectHook=true, dbvis.format.timestamp.pattern.8=dd-mm-yyyy HH:mm:ss, dbvis.mimer.ObjectTreeLabels=, dbvis.format.timestamp.pattern.7=dd-MM-yyyy HH:mm:ss, dbvis.format.timestamp.pattern.6=dd.MM.yyyy HH:mm:ss, dbvis.h2.ConfirmDropProcedureForEdit=true, dbvis.format.timestamp.pattern.5=MM/dd/yyyy HH:mm:ss, dbvis.sqlite.RemoveNewLineChars=false, dbvis.format.timestamp.pattern.4=dd/MM/yyyy HH:mm:ss, dbvis.format.timestamp.pattern.3=yyyy/MM/dd HH:mm:ss, dbvis.db2-iseries.PrependColumnNames=true, dbvis.format.timestamp.pattern.2=yyyy-MM-dd-HH:mm:ss.SSSSSS, dbvis.format.timestamp.pattern.1=yyyy-MM-dd HH:mm:ss.SSSSSS, dbvis.format.timestamp.pattern.0=, dbvis.jdatastore.ConnectWhenConnectAll=false, dbvis.PrettyBreakAfterComma=true, dbvis.postgresql.SystemTablePrefix=, dbvis.db2-iseries.AutoCommitOffWarning=true, dbvis.derby.SystemTablePrefix=, dbvis.mimer.InlineEditorCommitBatchSize=100, dbvis.maxdb.PrependColumnNames=true, dbvis.db2-iseries.TransactionIsolation=TRANSACTION_NONE, dbvis.firebird.ExportPrependObjectName=false, dbvis.mimer.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.db2-zos.ColorCriticalNodes=true, dbvis.h2.RunConnectHook=true, dbvis.hsql.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.derby.DropExplainTable=false, dbvis.progress.SetSchema=true, dbvis.pervasive.ConnectWhenConnectAll=false, dbvis.firebird.InlineEditorCommitBatchSize=100, dbvis.mysql.RunDisconnectHook=true, dbvis.sybase-asa.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, sun.os.patch.level=Service Pack 1, dbvis.h2.RunAtConnect=, dbvis.jdatastore.DelimitedIdentifierBegin=", dbvis.cache.IgnoreMaxRowsForNonSELECT=false, dbvis.h2.AutoCommit=true, dbvis.SQLAllowGo=true, exe4j.moduleName=C:\Program Files\DbVisualizer-8.0.12\dbvis.exe, dbvis.db2.ConnectionPassword=Save Between Sessions, dbvis.sybase-iq.ConnectionMode=Development, dbvis.pervasive.DateAsTimestamp=true, dbvis.db2-iseries.RunAtConnect=, dbvis.sybase-ase.IgnoreMaxRowsForNonSELECT=true, dbvis.progress.PrependTableNames=true, dbvis.pervasive.ConnectionMode=Development, dbvis.ExplainGraphNodeContent=result-set-explainviewer-show-operation-data-command, dbvis.informix.AutoCommit=true, dbvis.PrettyTargetSQL=SQL, dbvis.GridColumnSeparatorWidth=-1, dbvis.jdatastore.ColorCriticalNodes=true, dbvis.jdatastore.ExplainSchema=, dbvis.sqlserver.PrependColumnNames=true, dbvis.sqlite.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.derby.ExplainTable=, dbvis.sqlite.ExplainSchema=, dbvis.GraphLayoutType=Hierarchic, dbvis.generic.SystemTablePrefix=, dbvis.netezza.ObjectTreeLabels=, dbvis.postgresql.RunDisconnectHook=true, dbvis.derby.RunDisconnectHook=true, dbvis.db2.ObjectTreeLabels=, dbvis.PrettySpaceParent=Keep Unchanged, dbvis.-LookAndFeelMacOSX=default, dbvis.maxdb.SPBinaryEncoding=, dbvis.sybase-asa.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.ShowDataFilter=false, dbvis.generic.DelimitedIdentifiersExport=false, dbvis.jdatastore.SystemTablePrefix=, dbvis.mimer.WarningThreshold=5, dbvis.PrettyBreakForJoin=true, dbvis.db2-iseries.DelimitedIdentifiersExport=false, dbvis.generic.RequireUserid=false, dbvis.sybase-ase.TransactionIsolation=TRANSACTION_NONE, dbvis.postgresql.RunAtDisconnect=, dbvis.db2.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.jdatastore.CharForBitDataAsText=false, dbvis.sqlserver.SinglePhysicalConnection=false, dbvis.derby.ShowEmptySchemas=true, dbvis.cache.PrependTableNames=true, dbvis.informix.RunAtDisconnect=, dbvis.mysql.DelimitedIdentifierEnd=`, dbvis.SQLEditorLineHighlight=#ffffd7, dbvis.hsql.UseUserDefinedExplainTable=false, dbvis.pervasive.DelimitedIdentifierBegin=", dbvis.sqlite.WarningThreshold=5, dbvis.firebird.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.postgresql.SetSchema=true, dbvis.DataMaxRows=1000, dbvis.generic.RunDisconnectHook=true, dbvis.DebugWindowAutoPopup=true, dbvis.hsql.PrependTableNames=true, dbvis.sybase-asa.SystemTablePrefix=, dbvis.SQLHistoryIgnoreErrorEntries=false, dbvis.sybase-ase.AutoCommit=true, dbvis.jdatastore.RunDisconnectHook=true, dbvis.db2-zos.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, sun.arch.data.model=64, dbvis.cache.AutoJoinEnabled=false, dbvis.netezza.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), user.home=\\inside.sears.ca\CTX_HomeDrive\wpahk, dbvis.h2.SystemTablePrefix=, dbvis.pervasive.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.generic.SPBinaryEncoding=, dbvis.sybase-iq.AutoJoinType=ByKeys, dbvis.format.number.info.4=Grouping separator, dbvis.format.number.info.3=Minus sign, dbvis.sqlserver.QueryBuilderDialect=t-sql, dbvis.format.number.info.2=Decimal separator or monetary decimal separator, dbvis.format.number.info.1=Digit, zero shows as absent, dbvis.derby.DefaultCatalogsSchemasVisible=false, dbvis.informix.QueryBuilderDialect=, dbvis.format.number.info.0=Digit, dbvis.db2.WarningThreshold=5, dbvis.firebird.RunConnectHook=true, dbvis.PrettyAlignmentOnComment=false, dbvis.ProxyPort=, dbvis.db2-iseries.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.frontbase.UseUserDefinedExplainTable=false, dbvis.neoview.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.derby.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, dbvis.SQLEditorStatusbarVisible=true, dbvis.AskQuit=false, dbvis.firebird.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.GridCopyBlobType=Value, dbvis.firebird.DelimitedIdentifierBegin=", dbvis.oracle.SinglePhysicalConnection=false, dbvis.pervasive.IgnoreMaxRowsForNonSELECT=false, dbvis.FileQuickLoad=true|true|false|false|true|200, dbvis.neoview.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-asa.RunDisconnectHook=true, sun.cpu.endian=little, dbvis.doc.drivers=/products/dbvis/doc/supports.jsp, dbvis.oracle.DelimitedIdentifiersAutoCompletion=false, dbvis.maxdb.GraphPrependObjectName=false, dbvis.derby.DelimitedIdentifiersScripting=false, dbvis.pervasive.AutoJoinType=ByKeys, dbvis.build.number=1776, dbvis.informix.UseUserDefinedExplainTable=false, dbvis.db2.DateAsTimestamp=true, dbvis.sybase-asa.ConnectionPassword=Save Between Sessions, dbvis.h2.RunDisconnectHook=true, dbvis.firebird.WarningThreshold=5, dbvis.netezza.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.firebird.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.firebird.RemoveNewLineChars=false, dbvis.sybase-iq.RemoveNewLineChars=false, dbvis.mimer.SinglePhysicalConnection=false, dbvis.db2-iseries.CriticalThreshold=20, dbvis.variable.9=values, dbvis.generic.AutoJoinType=ByKeys, dbvis.variable.8=columns, dbvis.variable.7=quoted-where-columns, dbvis.sqlserver.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.oracle.ExportPrependObjectName=false, dbvis.variable.6=where-columns, dbvis.RowFormWindowGeometry=, dbvis.variable.5=table-name, dbvis.MonitorAutoStart=false, dbvis.mimer.RemoveNewLineChars=false, dbvis.variable.4=table, dbvis.variable.3=schemaseparator, dbvis.variable.2=schema, dbvis.frontbase.CharForBitDataAsText=false, dbvis.variable.1=catalogseparator, dbvis.variable.0=catalog, dbvis.ExecutionTimeout=60, dbvis.db2-zos.InlineEditorCommitBatchSize=100, dbvis.sybase-iq.DefaultCatalogsSchemasVisible=false, dbvis.informix.ConnectionMode=Development, dbvis.db2.CharForBitDataAsText=false, dbvis.PrettyIndentCondition=false, dbvis.hsql.ExplainTable=, dbvis.oracle.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.db2.DelimitedIdentifiersScripting=false, dbvis.firebird.CreateExplainTable=true, dbvis.postgresql.RequireUserid=false, dbvis.derby.GraphPrependObjectName=false, dbvis.cache.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-iq.CreateExplainTable=true, dbvis.h2.ConnectWhenConnectAll=false, dbvis.sybase-asa.SinglePhysicalConnection=false, dbvis.mimer.CreateExplainTable=true, dbvis.postgresql.DelimitedIdentifierBegin=", dbvis.db2-iseries.ColorCriticalNodes=true, dbvis.derby.ScriptingPrependObjectName=false, dbvis.hsql.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.maxdb.AutoCommitOffWarningAlways=false, dbvis.pervasive.DelimitedIdentifiersAutoCompletion=false, dbvis.firebird.ExplainTable=, dbvis.SQLCommanderAskSave=true, dbvis.mimer.TransactionIsolation=TRANSACTION_NONE, dbvis.maxdb.ColorCriticalNodes=true, dbvis.license.type=Free, dbvis.sqlite.PrependTableNames=false, dbvis.postgresql.AutoJoinType=ByKeys, dbvis.h2.SinglePhysicalConnection=false, dbvis.firebird.DefaultCatalogsSchemasVisible=false, dbvis.oracle.ConfirmDropProcedureForEdit=true, dbvis.sybase-iq.CharForBitDataAsText=false, dbvis.sybase-asa.ConnectWhenConnectAll=false, dbvis.oracle.IgnoreMaxRowsForNonSELECT=false, dbvis.netezza.RemoveNewLineChars=false, dbvis.h2.DelimitedIdentifiersBehindTheScene=true, dbvis.jdatastore.WarningThreshold=5, dbvis.sybase-asa.SPBinaryEncoding=, dbvis.postgresql.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.oracle.WarningThreshold=5, dbvis.firebird.AutoJoinEnabled=false, dbvis.maxdb.DelimitedIdentifierBegin=", dbvis.sybase-asa.DateAsTimestamp=true, dbvis.cache.ConnectWhenConnectAll=false, dbvis.sqlserver.ColorCriticalNodes=true, dbvis.format.datetime.info.18=Time zone, dbvis.format.datetime.info.17=Time zone, dbvis.format.datetime.info.16=Millisecond, dbvis.format.datetime.info.15=Second in minute, dbvis.db2-zos.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.format.datetime.info.14=Minute in hour, dbvis.oracle.GraphPrependObjectName=false, dbvis.format.datetime.info.13=Hour in AM/PM (1-12), dbvis.pervasive.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.firebird.DelimitedIdentifiersScripting=false, dbvis.derby.ExplainSchema=, dbvis.format.datetime.info.12=Hour in AM/PM (0-11), dbvis.sqlite.QueryBuilderUseJoinClause=true, dbvis.format.datetime.info.11=Hour in day (1-24), dbvis.db2-iseries.DelimitedIdentifierBegin=", dbvis.format.datetime.info.10=Hour in day (0-23), dbvis.netezza.CreateExplainTable=true, dbvis.postgresql.InlineEditorCommitBatchSize=100, dbvis.sqlserver.InlineEditorCommitBatchSize=100, dbvis.neoview.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.neoview.UseUserDefinedExplainTable=false, dbvis.jdatastore.DefaultCatalogsSchemasVisible=false, dbvis.SQLCommanderProcessVariables=true, dbvis.hsql.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.mysql.ExplainTable=, dbvis.jdatastore.GraphPrependObjectName=false, dbvis.sybase-asa.RequireUserid=false, java.specification.vendor=Sun Microsystems Inc., dbvis.pervasive.RunAtConnect=, dbvis.oracle.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.informix.ConnectionPassword=Save Between Sessions, dbvis.pervasive.CreateExplainTable=true, dbvis.maxdb.DelimitedIdentifiersExport=false, dbvis.frontbase.GraphPrependObjectName=false, dbvis.maxdb.PrependTableNames=true, dbvis.generic.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.jdatastore.DelimitedIdentifiersScripting=false, dbvis.sybase-ase.CriticalThreshold=20, dbvis.db2-zos.DelimitedIdentifiersBehindTheScene=true, dbvis.db2.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.format.boolean.pattern.9='1'/'0', dbvis.frontbase.InlineEditorCommitBatchSize=100, dbvis.oracle.PrependColumnNames=true, dbvis.jdatastore.RequirePassword=false, dbvis.format.boolean.pattern.8=1/0, dbvis.format.boolean.pattern.7='on'/'off', dbvis.format.boolean.pattern.6=on/off, dbvis.hsql.ConnectionPassword=Save Between Sessions, dbvis.format.boolean.pattern.5='yes'/'no', dbvis.format.boolean.pattern.4=yes/no, dbvis.progress.ExplainTable=, dbvis.cache.GraphPrependObjectName=false, dbvis.sqlite.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.DataGenerateFilterWithSorting=true, dbvis.format.boolean.pattern.3='t'/'f', dbvis.format.boolean.pattern.2=t/f, dbvis.format.boolean.pattern.1='true'/'false', dbvis.format.boolean.pattern.0=true/false, dbvis.PrettySqlBetween=false, dbvis.sqlserver.DelimitedIdentifiersBehindTheScene=true, dbvis.informix.AuthenticationMethod=SQL Server, dbvis.informix.AutoCommitOffWarningAlways=false, dbvis.informix.GraphPrependObjectName=false, dbvis.sybase-ase.AutoJoinEnabled=false, dbvis.hsql.QueryBuilderUseJoinClause=true, dbvis.GraphAutoEdgeRouting=true, dbvis.sqlite.ExportPrependObjectName=false, dbvis.GridColumnsTruncatedBorder=, dbvis.postgresql.DelimitedIdentifiersAutoCompletion=false, dbvis.QBTableQuickAdd=200, dbvis.postgresql.ConnectionMode=Development, dbvis.VariableIdentifierSuffix=}$, dbvis.hsql.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.CommanderMaxColumns=-1, dbvis.firebird.AutoCommitOffWarning=true, dbvis.LogShowMessage=true, dbvis.progress.ExportPrependObjectName=false, dbvis.sybase-ase.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.postgresql.ConnectionPassword=Save Between Sessions, dbvis.h2.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.mimer.RunConnectHook=true, dbvis.mysql.RemoveNewLineChars=false, dbvis.frontbase.ObjectTreeLabels=, dbvis.oracle.AutoJoinEnabled=false, dbvis.mysql.WarningThreshold=5, dbvis.generic.ScriptingPrependObjectName=false, dbvis.ExplainDefaultView=graph, dbvis.mysql.PrependTableNames=true, dbvis.progress.DropExplainTable=false, dbvis.db2-iseries.ScriptingPrependObjectName=false, dbvis.db2.RunAtConnect=, dbvis.derby.SPBinaryEncoding=, dbvis.sybase-asa.DelimitedIdentifiersBehindTheScene=true, dbvis.SQLCommanderResultSetsPinNew=false, dbvis.mimer.RequirePassword=false, dbvis.postgresql.CharForBitDataAsText=false, dbvis.sqlite.AutoCommit=true, dbvis.sybase-iq.InlineEditorCommitBatchSize=100, dbvis.mysql.CreateExplainTable=true, dbvis.db2-iseries.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.frontbase.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.h2.GraphPrependObjectName=false, dbvis.ProxyType=http, dbvis.doc.dbvis=/products/dbvis/, dbvis.sqlite.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.sqlserver.DelimitedIdentifierBegin=", dbvis.hsql.AutoCommitOffWarning=true, dbvis.sybase-iq.QueryBuilderUseJoinClause=true, dbvis.hsql.TransactionIsolation=TRANSACTION_NONE, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, install4j.launcherId=2, dbvis.sqlserver.ConnectionMode=Development, dbvis.netezza.ConnectionMode=Development, dbvis.db2-iseries.DefaultCatalogsSchemasVisible=false, log4j.appender.dbvis.layout.ConversionPattern=Basic, dbvis.RunConnectAllAtStartup=false, dbvis.sybase-iq.RunAtDisconnect=, dbvis.db2-zos.QueryBuilderUseJoinClause=true, dbvis.derby.InlineEditorCommitBatchSize=100, dbvis.sybase-iq.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.jdatastore.AutoCommitOffWarningAlways=false, dbvis.hsql.AutoJoinEnabled=false, dbvis.hsql.DelimitedIdentifiersBehindTheScene=true, dbvis.mimer.ExplainSchema=, dbvis.pervasive.DelimitedIdentifierEnd=", dbvis.sybase-ase.ObjectTreeLabels=, dbvis.cache.ConnectionPassword=Save Between Sessions, dbvis.frontbase.DateAsTimestamp=true, dbvis.informix.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.derby.AutoCommit=true, dbvis.informix.DelimitedIdentifiersExport=false, dbvis.sybase-ase.RemoveNewLineChars=false, dbvis.HistoryWindowGeometry=, dbvis.PrettyBreakBeforeComma=false, dbvis.DebugDetailLevel=Full, dbvis.db2.ConfirmDropProcedureForEdit=true, dbvis.db2-iseries.DelimitedIdentifiersScripting=false, java.library.path=C:\Program Files (x86)\IBM\Notes\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Citrix\ICAService\;C:\Program Files\Citrix\System32\;C:\Program Files (x86)\Common Files\Citrix\System32\;c:\program files\dbvisualizer-8.0.12\jre\bin, dbvis.sqlite.ConnectionPassword=Save Between Sessions, dbvis.firebird.DateAsTimestamp=true, dbvis.progress.ShowEmptySchemas=true, dbvis.neoview.AutoCommitOffWarningAlways=false, dbvis.LogFilterWarnings=true, dbvis.ShowReleaseNotes=true, dbvis.sybase-ase.ExportPrependObjectName=false, dbvis.informix.PrependColumnNames=true, dbvis.sybase-ase.CreateExplainTable=true, dbvis.netezza.UseUserDefinedExplainTable=false, dbvis.generic.PrependTableNames=true, dbvis.frontbase.ConnectionMode=Development, dbvis.progress.RemoveNewLineChars=false, dbvis.sqlserver.RunAtDisconnect=, dbvis.sybase-asa.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, java.vm.specification.name=Java Virtual Machine Specification, dbvis.oracle.DelimitedIdentifierBegin=", dbvis.sybase-ase.DelimitedIdentifiersAutoCompletion=false, dbvis.LogShowSQL=false, dbvis.mimer.RunAtConnect=, dbvis.frontbase.ConnectionPassword=Save Between Sessions, dbvis.sqlite.CharForBitDataAsText=false, dbvis.db2.RequireUserid=false, dbvis.derby.UseUserDefinedExplainTable=false, dbvis.informix.RequirePassword=false, dbvis.title=DbVisualizer, dbvis.sqlserver.ExportPrependObjectName=false, dbvis.hsql.PrependColumnNames=true, file.separator=\, dbvis.generic.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.informix.PrependTableNames=true, dbvis.mimer.DelimitedIdentifierBegin=", dbvis.sqlserver.QueryBuilderUseJoinClause=true, dbvis.h2.AuthenticationMethod=SQL Server, exe4j.isInstall4j=true, dbvis.InlineEditorPermTest=No Confirm|Confirm|Confirm, dbvis.GridEvenBorder=, dbvis.jdatastore.DelimitedIdentifiersExport=false, dbvis.variable.20=DbVis-Fetch-Time, dbvis.derby.AutoJoinEnabled=false, dbvis.pervasive.AutoCommitOffWarning=true, dbvis.maxdb.AutoJoinEnabled=false, dbvis.postgresql.PrependColumnNames=true, dbvis.progress.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, dbvis.hsql.InlineEditorCommitBatchSize=100, dbvis.h2.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.format.time.pattern.8=Blank, dbvis.firebird.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.format.time.pattern.7=Unformatted, dbvis.sybase-iq.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.format.time.pattern.6=hh 'o''clock' a, z, dbvis.generic.AutoCommitOffWarning=true, dbvis.UseRelativePaths=false, dbvis.format.time.pattern.5=hh:mm:ss.SSS, dbvis.generic.TransactionIsolation=TRANSACTION_NONE, dbvis.format.time.pattern.4=HHmmss, dbvis.sybase-asa.PrependTableNames=true, dbvis.format.time.pattern.3=hh:mm a, dbvis.format.time.pattern.2=hh:mm:ss a, dbvis.mysql.AutoCommitOffWarning=true, dbvis.format.time.pattern.1=HH:mm, dbvis.sybase-ase.DateAsTimestamp=true, dbvis.format.time.pattern.0=HH:mm:ss, dbvis.cache.DropExplainTable=false, dbvis.GraphShowOneLink=false, dbvis.sybase-asa.DelimitedIdentifierBegin=", dbvis.mimer.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.variable.19=DbVis-Exec-Time, dbvis.sybase-iq.CriticalThreshold=20, dbvis.variable.18=DbVis-Time, dbvis.variable.17=DbVis-Date, dbvis.variable.16=create-primary-key, dbvis.maxdb.AutoJoinType=ByKeys, dbvis.variable.15=index-columns, dbvis.variable.14=unique, dbvis.derby.ConnectionMode=Development, dbvis.variable.13=index, dbvis.PrettyAlignmentOnKeyword=false, dbvis.variable.12=index-type, dbvis.db2-iseries.AuthenticationMethod=SQL Server, dbvis.variable.11=create-columns, dbvis.variable.10=column-values, dbvis.neoview.DelimitedIdentifiersExport=false, dbvis.h2.PrependColumnNames=true, dbvis.db2.QueryBuilderUseJoinClause=true, dbvis.neoview.RemoveNewLineChars=false, dbvis.netezza.GraphPrependObjectName=false, dbvis.postgresql.QueryBuilderDialect=, dbvis.firebird.ExplainSchema=, dbvis.IconSizeSubToolBars=small, dbvis.oracle.ColorCriticalNodes=true, dbvis.db2-iseries.SystemTablePrefix=, dbvis.cache.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.h2.DelimitedIdentifierBegin=", dbvis.-MonospaceFontOther=DejaVu Sans Mono-plain-12, dbvis.PrettyBreakForBrackets=true, dbvis.db2-iseries.RunAtDisconnect=, dbvis.neoview.CreateExplainTable=true, dbvis.cache.DelimitedIdentifiersAutoCompletion=false, dbvis.generic.QueryBuilderUseJoinClause=true, dbvis.netezza.AutoJoinEnabled=false, dbvis.jdatastore.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.netezza.ExplainSchema=, dbvis.cache.RunConnectHook=true, dbvis.cache.PrependColumnNames=true, dbvis.postgresql.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.MonitorShowAtStartup=false, dbvis.informix.ObjectTreeLabels=, dbvis.netezza.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.frontbase.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-ase.DefaultCatalogsSchemasVisible=false, dbvis.cache.ShowEmptySchemas=true, dbvis.sqlite.PrependColumnNames=true, dbvis.pervasive.SetSchema=true, dbvis.hsql.DateAsTimestamp=true, dbvis.PrettyBreakForCase=true, dbvis.db2-iseries.RunDisconnectHook=true, dbvis.cache.QueryBuilderDialect=t-sql, dbvis.frontbase.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.format.decimal.pattern.9=####.###, dbvis.DriverManagerSearchPath=${dbvis.prefsdir}/jdbc;${dbvis.home}/jdbc, dbvis.format.decimal.pattern.8=####.##, dbvis.format.decimal.pattern.7=####.#, dbvis.format.decimal.pattern.6=####, dbvis.maxdb.DelimitedIdentifiersBehindTheScene=true, dbvis.format.decimal.pattern.5=#,###.####################, dbvis.format.decimal.pattern.4=#,###.####, dbvis.format.decimal.pattern.3=#,###.###, dbvis.progress.GraphPrependObjectName=false, dbvis.sqlserver.SystemTablePrefix=, dbvis.format.decimal.pattern.2=#,###.##, dbvis.format.decimal.pattern.1=#,###.#, dbvis.format.decimal.pattern.0=#,###, dbvis.informix.MonitorRowCountCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-iq.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.maxdb.CharForBitDataAsText=false, dbvis.neoview.ConnectWhenConnectAll=false, user.name=wpahk, dbvis.jdatastore.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-ase.DelimitedIdentifiersScripting=false, dbvis.firebird.ConnectionPassword=Save Between Sessions, dbvis.sybase-iq.ConnectionPassword=Save Between Sessions, dbvis.frontbase.PrependColumnNames=true, dbvis.generic.RequirePassword=false, dbvis.progress.RequirePassword=false, dbvis.netezza.AutoCommitOffWarningAlways=false, dbvis.maxdb.ScriptingPrependObjectName=false, dbvis.hsql.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.ShowDialogWhenCreateDatabase=true, dbvis.pervasive.AutoCommitOffWarningAlways=false, dbvis.generic.UseUserDefinedExplainTable=false, dbvis.GridOddFG=#000000, dbvis.db2-iseries.DropExplainTable=false, sun.io.unicode.encoding=UnicodeLittle, dbvis.db2-iseries.UseUserDefinedExplainTable=false, dbvis.hsql.SetSchema=true, dbvis.MainFrameGeometry=, dbvis.mimer.QueryBuilderUseJoinClause=true, dbvis.derby.SetSchema=true, dbvis.mimer.DelimitedIdentifiersAutoCompletion=true, dbvis.AppFont=Default, os.version=6.1, dbvis.generic.ShowEmptySchemas=true, dbvis.sqlserver.RunDisconnectHook=true, dbvis.cache.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, dbvis.mimer.DateAsTimestamp=true, dbvis.mysql.RequireUserid=false, dbvis.postgresql.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.firebird.DelimitedIdentifiersBehindTheScene=true, awt.toolkit=sun.awt.windows.WToolkit, dbvis.maxdb.RunAtConnect=, dbvis.sybase-iq.WarningThreshold=5, dbvis.sybase-asa.AutoJoinType=ByKeys, dbvis.mysql.ConfirmDropProcedureForEdit=true, dbvis.oracle.CharForBitDataAsText=false, dbvis.pervasive.AutoJoinEnabled=false, dbvis.informix.ColorCriticalNodes=true, dbvis.sybase-asa.AutoCommitOffWarningAlways=false, dbvis.firebird.ConnectionMode=Development, dbvis.cache.AutoCommitOffWarningAlways=false, dbvis.mysql.AutoJoinEnabled=false, dbvis.sqlserver.AutoCommitOffWarningAlways=false, dbvis.h2.QueryBuilderUseJoinClause=true, dbvis.cache.ExportPrependObjectName=false, dbvis.sqlite.IgnoreMaxRowsForNonSELECT=false, dbvis.neoview.PrependTableNames=true, dbvis.sybase-ase.SystemTablePrefix=, dbvis.GridCopyClobType=Value, dbvis.netezza.ConnectionPassword=Save Between Sessions, dbvis.mysql.RunConnectHook=true, dbvis.mimer.ConfirmDropProcedureForEdit=true, dbvis.postgresql.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.firebird.SetSchema=true, dbvis.sqlserver.SetSchema=true, dbvis.oracle.InsertCommand=insert into $$schema$$$$schemaseparator$$$$table$$ ($$columns$$) values ($$column-values$$), dbvis.db2-iseries.ShowEmptySchemas=true, dbvis.mysql.DefaultCatalogsSchemasVisible=false, dbvis.hsql.ColorCriticalNodes=true, dbvis.RecentSQLFilesLimit=20, dbvis.mysql.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.sqlserver.ObjectTreeLabels=, dbvis.sybase-asa.SetSchema=true, dbvis.firebird.AutoCommit=true, dbvis.VariableIdentifierPrefix=${, dbvis.PrettyAlignmentOnDeclaration=false, dbvis.jdatastore.SetSchema=true, dbvis.netezza.DelimitedIdentifiersExport=false, dbvis.pervasive.ExplainSchema=, dbvis.pervasive.DelimitedIdentifiersExport=false, java.endorsed.dirs=c:\program files\dbvisualizer-8.0.12\jre\lib\endorsed, dbvis.db2.AutoCommitOffWarning=true, dbvis.mysql.DelimitedIdentifiersScripting=false, dbvis.db2.TransactionIsolation=TRANSACTION_NONE, dbvis.PrettyBreakAfterAndOr=false, dbvis.mysql.AutoCommit=true, dbvis.postgresql.ObjectTreeLabels=, dbvis.cache.AutoJoinType=ByKeys, dbvis.sqlite.DeleteWhereCommand=delete from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.postgresql.ColorCriticalNodes=true, dbvis.sybase-ase.RunDisconnectHook=true, dbvis.informix.ScriptingPrependObjectName=false, dbvis.GridOddBG=#f0f5fa, dbvis.hsql.ExplainSchema=, dbvis.netezza.DateAsTimestamp=true, dbvis.SQLEditorCaretBlink=true, dbvis.progress.SPBinaryEncoding=, dbvis.informix.ExplainTable=, dbvis.doc.purchase=/products/dbvis/purchase/, dbvis.oracle.UpdateCommand=update $$schema$$$$schemaseparator$$$$table$$ set $$column-values$$ where $$where-columns$$, dbvis.PendingTransactionsAction=Ask, dbvis.hsql.IgnoreMaxRowsForNonSELECT=false, dbvis.db2-iseries.GraphPrependObjectName=false, dbvis.h2.ColorCriticalNodes=true, dbvis.neoview.AutoCommit=true, dbvis.maxdb.QueryBuilderUseJoinClause=true, dbvis.db2-iseries.DropTableCommand=drop table $$schema$$$$schemaseparator$$$$table$$, dbvis.neoview.InlineEditorCommitBatchSize=100, dbvis.sybase-ase.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.sybase-asa.DelimitedIdentifiersExport=false, dbvis.cache.DelimitedIdentifiersExport=false, dbvis.sqlserver.DelimitedIdentifiersExport=false, dbvis.oracle.PrependTableNames=true, dbvis.cache.RunAtDisconnect=, dbvis.firebird.PrependColumnNames=true, dbvis.doc.evaluate=/products/dbvis/eval/, dbvis.sybase-iq.AutoCommitOffWarning=true, dbvis.mysql.ExportPrependObjectName=false, dbvis.sybase-iq.TransactionIsolation=TRANSACTION_NONE, dbvis.jdatastore.AutoCommit=true, dbvis.netezza.DropExplainTable=false, dbvis.informix.DelimitedIdentifiersScripting=false, dbvis.neoview.SelectAllCommand=select * from $$schema$$$$schemaseparator$$$$table$$, dbvis.SQLCommanderStopOnWarning=false, dbvis.frontbase.DelimitedIdentifiersScripting=false, dbvis.progress.SelectWhereCommand=select * from $$schema$$$$schemaseparator$$$$table$$ where $$where-columns$$, dbvis.sybase-asa.RunAtConnect=, dbvis.cache.ColorCriticalNodes=true, dbvis.h2.AutoCommitOffWarning=true, dbvis.db2-iseries.SelectCountCommand=select count(*) from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-iq.RequirePassword=false, dbvis.h2.TransactionIsolation=TRANSACTION_NONE, dbvis.prefsdir=\\inside.sears.ca\CTX_HomeDrive\wpahk\.dbvis, dbvis.maxdb.ExportPrependObjectName=false, dbvis.mysql.GraphPrependObjectName=false, dbvis.hsql.DefaultCatalogsSchemasVisible=false, dbvis.sybase-iq.ConnectWhenConnectAll=false, dbvis.h2.ExplainTable=, java.vm.specification.version=1.0, dbvis.sybase-ase.ExplainSchema=, dbvis.mysql.ConnectionPassword=Save Between Sessions, dbvis.sqlite.ColorCriticalNodes=true, dbvis.generic.DelimitedIdentifierEnd=", dbvis.sybase-asa.SelectAllColumnsCommand=select $$columns$$ from $$schema$$$$schemaseparator$$$$table$$, dbvis.sybase-iq.IgnoreMaxRowsForNonSELECT=false, dbvis.jdatastore.ScriptingPrependObjectName=false, dbvis.progress.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$, dbvis.db2.AutoJoinEnabled=false, dbvis.h2.MonitorRowCountChangeCommand=select '$$vib$$DbVis-Date$$vie$$ $$vib$$DbVis-Time$$vie$$' as PollTime, count(*) as NumRows, count(*) - $$vib$$NumRows||count(*)$$vie$$ as NumRowsChange from $$schema$$$$schemaseparator$$$$table$$ } [jcc] Dumping all file properties: { } [jcc] pureQuery present = false [jcc] END TRACE_DRIVER_CONFIGURATION [jcc] BEGIN TRACE_CONNECTS [jcc] Attempting connection to localhost:51150/prdbrm [jcc] Using properties: { maxStatements=0, currentPackagePath=null, currentLockTimeout=-2147483647, timerLevelForQueryTimeOut=0, optimizationProfileToFlush=null, timeFormat=1, monitorPort=0, sendCharInputsUTF8=0, LOCKSSFU=null, alternateGroupDatabaseName=null, sendDataAsIs=false, stripTrailingZerosForDecimalNumbers=0, returnAlias=1, supportsAsynchronousXARollback=2, sessionTimeZone=null, pkList=null, atomicMultiRowInsert=0, traceFileCount=2, DEBUG=null, IFX_UPDDESC=1, traceDirectory=null, maxRowsetSize=32767, driverType=4, extendedDiagnosticLevel=240, accountingInterval=null, monitoredDataSourceName=null, concurrentAccessResolution=0, LKNOTIFY=yes, clientProgramName=null, enableAlternateGroupSeamlessACR=false, connectNode=-1, traceFileSize=1048576, progressiveStreaming=0, profileName=null, DBMAXPROC=null, INFORMIXSTACKSIZE=null, databaseName=prdbrm, IFX_XASTDCOMPLIANCE_XAEND=null, xmlFormat=-2147483647, decimalSeparator=0, DBPATH=., emulateParameterMetaDataForZCalls=0, decimalRoundingMode=-2147483647, serverName=localhost, 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=db2retip, connectionCloseWithInFlightTransaction=0, fullyMaterializeLobData=true, enableClientAffinitiesList=0, clientUser=null, portNumber=51150, resultSetHoldability=0, allowNextOnExhaustedResultSet=0, NOSORTINDEX=null, enableConnectionConcentrator=false, implicitRollbackOption=0, monitorServerName=null, STMT_CACHE=null, PSORT_DBTEMP=null, IFX_EXTDIRECTIVES=null, sqljEnableClassLoaderSpecificProfiles=false, clientAccountingInformation=null, sqljCloseStmtsWithOpenResultSet=true, 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, activateDatabase=0, xaNetworkOptimization=true, plugin=null, traceOption=0, pdqProperties=null, currentSchema=null, CR_LOCKBLOB=null, traceLevel=-1, enableRowsetSupport=0, clientDebugInfo=null, dataSourceName=null, enableAlternateServerListFirstConnect=0, maxRetriesForClientReroute=-1, fetchSize=-1, queryDataSize=0, queryTimeoutInterruptProcessingMode=1, alternateGroupServerName=null, clientRerouteAlternateServerName=null, DBTEMP=/tmp, enableT2zosLBF=0, SUBQCACHESZ=10, ssid=null, maxConnCachedParamBufferSize=1048576, fullyMaterializeInputStreamsOnBatchExecution=0, alternateGroupPortNumber=null, currentMaintainedTableTypesForOptimization=null, traceFile=null, currentExplainSnapshot=null, DBDATE=Y4MD-, SLABEL=null, enableMultirowInsertSupport=true, currentFunctionPath=null, enableT2zosLBFSPResultSets=0, 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, enableT2zosCallSPBundling=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=****, DELIMIDENT=false, clientWorkstation=null, useJDBC41DefinitionForGetColumns=0, currentQueryOptimization=-2147483647, clientApplicationInformation=null, DUMPSHMEM=null, translateForBitData=0, monitorCollectionInterval=0, sslTrustStoreLocation=null, optimizationProfile=null, retrieveMessagesFromServerOnGetMessage=true, 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, enableExtendedDescribe=0, DBSPACETEMP=null, enableExtendedIndicators=0, PLOAD_LO_PATH=null, encryptionAlgorithm=0, keepAliveTimeOut=15, 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:2014-03-13-15:41:41.577][Thread:pool-2-thread-4][tracepoint:315]creating a socket to localhost at 127.0.0.1 [jcc] [t4][time:2014-03-13-15:41:41.579][Thread:pool-2-thread-4][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 00D2D041000100CC 10410081115E8482 ...A.....A...^.. .K}........a.;db [jcc][t4] 0010 F29183836D819797 93898381A3899695 ....m........... 2jcc_application [jcc][t4] 0020 4040D1C3C3F0F4F1 F3F0F3F0F0000000 @@.............. JCC04130300... [jcc][t4] 0030 0000000000000000 0000000000000000 ................ ................ [jcc][t4] 0040 0000000000000000 000000000060F0F0 .............`.. .............-00 [jcc][t4] 0050 F0F1A69781889240 4040404040404040 .......@@@@@@@@@ 01wpahk [jcc][t4] 0060 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@ [jcc][t4] 0070 0000000000000000 0000000000000000 ................ ................ [jcc][t4] 0080 0000000000000000 0000F00013116DE5 ..............m. ..........0..._V [jcc][t4] 0090 C260E5C4C960C4C5 E5D460F0F5F0000C .`...`....`..... B-VDI-DEVM-050.. [jcc][t4] 00A0 115AD1C3C3F0F4F1 F3F0001C14041403 .Z.............. .!JCC04130...... [jcc][t4] 00B0 000A2407000A1C08 04B8240F00081440 ..$.......$....@ ............... [jcc][t4] 00C0 000914740008000C 1147D8C4C2F261D1 ...t.....G....a. ..........QDB2/J [jcc][t4] 00D0 E5D4 .. VM [jcc][t4] [jcc][t4] SEND BUFFER: ACCSEC (ASCII) (EBCDIC) [jcc][t4] 0000 0026D00100020020 106D000611A20003 .&..... .m...... ..}......_...s.. [jcc][t4] 0010 0016211097998482 9994404040404040 ..!.......@@@@@@ ....prdbrm [jcc][t4] 0020 404040404040 @@@@@@ [jcc][t4] [jcc][t4] [time:2014-03-13-15:41:41.579][Thread:pool-2-thread-4][tracepoint:101]Request flushed. [jcc][t4] [time:2014-03-13-15:41:41.580][Thread:pool-2-thread-4][tracepoint:102]Reply to be filled. [jcc][t4] [time:2014-03-13-15:41:41.581][Thread:pool-2-thread-4][tracepoint:210]IOException : Connection reset [jcc][t4] [time:2014-03-13-15:41:41.581][Thread:pool-2-thread-4][tracepoint:950]searching the server list cache for key localhost:51150 [jcc][t4] [time:2014-03-13-15:41:41.581][Thread:pool-2-thread-4][tracepoint:202] closing non-pooled Transport: [jcc][Connection@512190b1] DB2 LUWID: null.0001 com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException at com.ibm.db2.jcc.am.id.a(id.java:320) at com.ibm.db2.jcc.t4.a.a(a.java:492) at com.ibm.db2.jcc.t4.a.a(a.java:487) at com.ibm.db2.jcc.t4.z.b(z.java:230) at com.ibm.db2.jcc.t4.z.c(z.java:289) at com.ibm.db2.jcc.t4.z.c(z.java:402) at com.ibm.db2.jcc.t4.z.v(z.java:1170) at com.ibm.db2.jcc.t4.ab.a(ab.java:47) at com.ibm.db2.jcc.t4.b.m(b.java:1333) at com.ibm.db2.jcc.t4.b.b(b.java:1205) at com.ibm.db2.jcc.t4.b.b(b.java:786) at com.ibm.db2.jcc.t4.b.c(b.java:758) at com.ibm.db2.jcc.t4.b.a(b.java:421) at com.ibm.db2.jcc.t4.b.a(b.java:396) at com.ibm.db2.jcc.t4.b.(b.java:334) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:231) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:197) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:472) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.d.B.D.?(Z:1548) at com.onseven.dbvis.d.B.F$A.call(Z:278) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [jcc] BEGIN TRACE_DIAGNOSTICS [jcc][Thread:pool-2-thread-4][SQLException@72a27e13] java.sql.SQLException [jcc][Thread:pool-2-thread-4][SQLException@72a27e13] SQL state = 08001 [jcc][Thread:pool-2-thread-4][SQLException@72a27e13] Error code = -4499 [jcc][Thread:pool-2-thread-4][SQLException@72a27e13] Message = [jcc][t4][2030][11211][4.13.127] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001 [jcc][Thread:pool-2-thread-4][SQLException@72a27e13] Stack trace follows com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.13.127] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001 com.ibm.db2.jcc.am.id.a(id.java:320) com.ibm.db2.jcc.t4.a.a(a.java:492) com.ibm.db2.jcc.t4.a.a(a.java:487) com.ibm.db2.jcc.t4.z.b(z.java:230) com.ibm.db2.jcc.t4.z.c(z.java:289) com.ibm.db2.jcc.t4.z.c(z.java:402) com.ibm.db2.jcc.t4.z.v(z.java:1170) com.ibm.db2.jcc.t4.ab.a(ab.java:47) com.ibm.db2.jcc.t4.b.m(b.java:1333) com.ibm.db2.jcc.t4.b.b(b.java:1205) com.ibm.db2.jcc.t4.b.b(b.java:786) com.ibm.db2.jcc.t4.b.c(b.java:758) com.ibm.db2.jcc.t4.b.a(b.java:421) com.ibm.db2.jcc.t4.b.a(b.java:396) com.ibm.db2.jcc.t4.b.(b.java:334) com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:231) com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:197) com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:472) com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) com.onseven.dbvis.d.B.D.?(Z:1548) com.onseven.dbvis.d.B.F$A.call(Z:278) java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source) [jcc] END TRACE_DIAGNOSTICS [jcc] [t4][time:2014-03-13-15:41:41.582][Thread:pool-2-thread-4][tracepoint:2][Reply.fill] [jcc][t4] 15:41:41 [DEBUG pool-2-thread-4 D.?] RootConnection: EXCEPTION -> com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.13.127] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001 Just to let you know, I am port forwarding, but I can connect on the command line and also the "ping" from DBVisualizer says I can reach the DB server. Thanks!