| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| mqsi_setupdatabase with Sybase |
« View previous topic :: View next topic » |
| Author |
Message
|
| hal |
 Posted: Fri May 19, 2006 1:22 pm Post subject: mqsi_setupdatabase with Sybase |
 |
|
Acolyte
Joined: 07 Dec 2005
Posts: 67
Location: New York City, New York
|
I am getting errors when attempting to complete the Message Broker V6.0.0.1 UNIX database mqsi_setupdatabase task. My OS is Solaris 8; my broker database is Sybase 12.5.
| Code: |
| mqsi_setupdatabase sybase12_5 $SYBASE |
| Code: |
Database, sybase12_5, not supported
Usage: mqsi_setupdatabase 'Database' 'Database home directory'
Valid 'Database' arguments: oracle9 oracle10 |
From the InfoCenter:
| Quote: |
Issue the following command:
mqsi_setupdatabase database_type <database_install_directory>
where database_type is db2, oracle9, or sybase12_5 and <database_install_directory> is the directory in which the database is (or will be) installed (for example, /usr/lpp/db2_07_01). |
In January (before 6.0.0.1 was available) I ran the same mqsi_setupdatabase command successfully in another Solaris 8 broker instance.
| Code: |
| mqsi_setupdatabase sybase12_5 $SYBASE |
| Code: |
Creating links for sybase12_5 in WBIMB directories.
----------------------------------------------------
Creating link /var/mqsi/common/lib/libintl.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libintl.so
Creating link /var/mqsi/common/lib/libcomn.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libcomn.so
Creating link /var/mqsi/common/lib/libcs.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libcs.so
Creating link /var/mqsi/common/lib/libtcl.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libtcl.so
Creating link /var/mqsi/common/lib/libct.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libct.so
Creating link /var/mqsi/common/lib/libnsl.so to /usr/lib/libnsl.so
Creating link /var/mqsi/common/lib64/libintl64.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libintl64.so
Creating link /var/mqsi/common/lib64/libcomn64.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libcomn64.so
Creating link /var/mqsi/common/lib64/libcs64.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libcs64.so
Creating link /var/mqsi/common/lib64/libtcl64.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libtcl64.so
Creating link /var/mqsi/common/lib64/libct64.so to
/MQSDBP01/sybase/SNYCMQSP01/product/OCS-12_5/lib/libct64.so
Creating link /var/mqsi/common/lib64/libnsl.so to /usr/lib/sparcv9/libnsl.so |
Here is the start and end of the 6.0.0.1
/opt/IBM/mqsi/6.0/bin/mqsi_setupdatabase/mqsi_setupdatabase script. Sybase not listed as a supported database.
| Quote: |
bin/ksh
#
# (C) COPYRIGHT International Business Machines Corp. 2001, 2003 - 2005
# All Rights Reserved
# Licensed Material - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
#
# NAME: mqsi_setupdatabase
#
# PURPOSE: Setup database links required for XA coordination by WMQ
#
DATABASE=$1
HOMEDIR=$2
#-----------------Start of functions-----------------------
supported_databases ()
{
echo "oracle9 oracle10"
}
usage ()
{
echo
echo "Usage: mqsi_setupdatabase 'Database' 'Database home directory' "
echo "Valid 'Database' arguments: `supported_databases`"
echo
exit 1
}
valid_input ()
{
if [ -z "${DATABASE}" ]; then
usage
fi ;
if [ -z "${HOMEDIR}" ]; then
echo
echo "Please specify ${DATABASE}'s home directory."
usage
fi ;
if [ -z "`supported_databases | grep ${DATABASE}`" ] > /dev/null ; then
echo
echo "Database, ${DATABASE}, not supported"
usage
fi;
}
.
.
.
#-----------------End of functions--------------------------
#-----------------Main Routine------------------------------
if [ $# -gt 2 ]; then
echo
echo "Too many arguments."
echo
usage
fi
valid_input;
create_links;
#-----------------End of Main Routine----------------------- |
The base mqsi_setupdatabase scripts were probably overwritten when both my Broker V6 instances were upgraded to 6.0.0.1. (The setupsolaris file from the installation CD is binary so I am unable to view the original script without performing a fresh install. ) |
|
| 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
|
|
|
|
