| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| mqsicvp question(s) |
« View previous topic :: View next topic » |
| Author |
Message
|
| Gideon |
 Posted: Wed Aug 03, 2011 10:57 am Post subject: mqsicvp question(s) |
 |
|
Chevalier
Joined: 18 Aug 2009
Posts: 403
|
I upgraded my WMB to 7.0.0.1 and successfully ran the mqsicvp
verification of the database (results below).
I have never ran this command before and have a few Newbie questions:
1> In the following mqsicvp response, does this mean I can not access the tables in my database (I am assuming this is not the case, just need to make sure)
| Code: |
accessibleTables = No
accessibleProcedures = No |
2> I am assuming that the following message is a generic warning, and not a specific error message saying that I am using these data types and functions (I can not find any such data types in my tables):
| Code: |
BIP8273I: The following datatypes and functions are not natively supported by datasource 'IPC' using this ODBC driver: Unsupported datatypes: 'INTERVAL' Unsupported functions: 'POSITION, EXTRACT'
Examine the specific datatypes and functions not supported natively |
3> I am assuming that th efollowing message is basically saying that I am good to go. Is this correct ?
| Code: |
-bash-3.2$ mqsicvp -n IPC -u db2inst1 -p db2inst1
BIP8270I: Connected to Datasource 'IPC' as user 'db2inst1'. The datasource platform is 'DB2/LINUXX8664', version '09.07.0004'.
===========================
databaseProviderVersion = 09.07.0004
driverVersion = 09.07.0004
driverOdbcVersion = 03.51
driverManagerVersion = 3.52.0000
driverManagerOdbcVersion = 03.52.0000
databaseProviderName = DB2/LINUXX8664
datasourceServerName = db2inst1
databaseName = IPC
odbcDatasourceName = IPC
driverName = libdb2.a
supportsStoredProcedures = Yes
procedureTerm = stored procedure
accessibleTables = No
accessibleProcedures = No
identifierQuote = "
specialCharacters = None
describeParameter = Yes
schemaTerm = schema
tableTerm = table
sqlSubqueries = 31
activeEnvironments = 1
maxDriverConnections = 0
maxCatalogNameLength = 0
maxColumnNameLength = 128
maxSchemaNameLength = 128
maxStatementLength = 2097152
maxTableNameLength = 128
supportsDecimalType = Yes
supportsDateType = Yes
supportsTimeType = Yes
supportsTimeStampType = Yes
supportsIntervalType = No
supportsAbsFunction = Yes
supportsAcosFunction = Yes
supportsAsinFunction = Yes
supportsAtanFunction = Yes
supportsAtan2Function = Yes
supportsCeilingFunction = Yes
supportsCosFunction = Yes
supportsCotFunction = Yes
supportsDegreesFunction = Yes
supportsExpFunction = Yes
supportsFloorFunction = Yes
supportsLogFunction = Yes
supportsLog10Function = Yes
supportsModFunction = Yes
supportsPiFunction = Yes
supportsPowerFunction = Yes
supportsRadiansFunction = Yes
supportsRandFunction = Yes
supportsRoundFunction = Yes
supportsSignFunction = Yes
supportsSinFunction = Yes
supportsSqrtFunction = Yes
supportsTanFunction = Yes
supportsTruncateFunction = Yes
supportsConcatFunction = Yes
supportsInsertFunction = Yes
supportsLcaseFunction = Yes
supportsLeftFunction = Yes
supportsLengthFunction = Yes
supportsLTrimFunction = Yes
supportsPositionFunction = No
supportsRepeatFunction = Yes
supportsReplaceFunction = Yes
supportsRightFunction = Yes
supportsRTrimFunction = Yes
supportsSpaceFunction = Yes
supportsSubstringFunction = Yes
supportsUcaseFunction = Yes
supportsExtractFunction = No
supportsCaseExpression = Yes
supportsCastFunction = Yes
supportsCoalesceFunction = Yes
supportsNullIfFunction = Yes
supportsConvertFunction = Yes
supportsSumFunction = Yes
supportsMaxFunction = Yes
supportsMinFunction = Yes
supportsCountFunction = Yes
supportsBetweenPredicate = Yes
supportsExistsPredicate = Yes
supportsInPredicate = Yes
supportsLikePredicate = Yes
supportsNullPredicate = Yes
supportsNotNullPredicate = Yes
supportsLikeEscapeClause = Yes
supportsClobType = Yes
supportsBlobType = Yes
charDatatypeName = CHAR
varCharDatatypeName = VARCHAR
longVarCharDatatypeName = LONG VARCHAR
clobDatatypeName = CLOB
timeStampDatatypeName = TIMESTAMP
binaryDatatypeName = CHAR (1) FOR BIT DATA
varBinaryDatatypeName = VARCHAR (1) FOR BIT DATA
longVarBinaryDatatypeName = LONG VARCHAR FOR BIT DATA
blobDatatypeName = BLOB
intDatatypeName = INTEGER
doubleDatatypeName = DOUBLE
varCharMaxLength = 32672
longVarCharMaxLength = 32700
clobMaxLength = 2147483647
varBinaryMaxLength = 32672
longVarBinaryMaxLength = 32700
blobMaxLength = 2147483647
timeStampMaxLength = 32
identifierCase = Upper
escapeCharacter = \
longVarCharDatatype = -1
clobDatatype = -99
longVarBinaryDatatype = -4
blobDatatype = -98
BIP8273I: The following datatypes and functions are not natively supported by datasource 'IPC' using this ODBC driver: Unsupported datatypes: 'INTERVAL' Unsupported functions: 'POSITION, EXTRACT'
Examine the specific datatypes and functions not supported natively by this datasource using this ODBC driver.
When using these datatypes and functions within ESQL, the associated data processing is done within WebSphere Message Broker rather than being processed by the database provider.
Note that "functions" within this message can refer to functions or predicates.
BIP8071I: Successful command completion. |
|
|
| Back to top |
|
 |
| mqmatt |
| Posted: Thu Aug 04, 2011 4:06 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
This verbose information returned by mqsicvp is typically informational only and is based on a query of what the database driver claims to support.
This output can provide you with additional problem diagnosis information in the event of a problem; I wouldn't worry unless the broker is reporting a failure. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Aug 04, 2011 5:36 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Look at the BIP codes...
They are both of type 'I'. Informational. If you wern't good to go then the errors will (probably) be of type 'E'.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
