Skip to Content
IBM Db2 for Linux, UNIX, and Windows

How to change the DB2 client connection items related to jdbc used with JAVA stack AS

be sure to read through all 8 steps below . . .

1)  test to see if consoleconfig.sh will connect using the present /usr/sap/X5J/SYS/global/security/data/SecStore.properties

        **********************************************************************************

        ls -al /usr/sap/X5J/SYS/global/security/data/*

        **********************************************************************************

                **********************************************************************************

                csh:x5jadm@mwrh3:/> ls -al /usr/sap/X5J/SYS/global/security/data/*

                -rw-r--r--. 1 x5jadm sapsys  119 Mar 12 22:19 /usr/sap/X5J/SYS/global/security/data/icmauth.txt

                -rwxr-xr-x. 1 x5jadm sapsys  243 Oct 27  2015 /usr/sap/X5J/SYS/global/security/data/icm_filter_rules.txt

                -rwx------. 1 x5jadm sapsys   21 Aug 15 12:41 /usr/sap/X5J/SYS/global/security/data/SecStore.key

                -rwx------. 1 x5jadm sapsys  527 Aug 15 15:41 /usr/sap/X5J/SYS/global/security/data/SecStore.properties

                csh:x5jadm@mwrh3:/>

                **********************************************************************************

 

        **********************************************************************************

        /bin/su x5jadm

        setenv SHELL csh

        setenv mwshell csh

        set prompt="`echo $mwshell`:`id |cut -f2 -d'(' |cut -f1 -d')'`@`hostname | cut -f1 -d'.'`:`pwd`> "

        alias idmw "id |cut -f2 -d'(' |cut -f1 -d')'"

        alias cd 'chdir \!* && set prompt="`echo $mwshell`:`idmw`@`hostname | cut -f1 -d'.'`:`pwd`> "'

        cd /

        setenv DISPLAY 10.6.16.181:0.0

        echo $DISPLAY

        cd /usr/sap/X5J/J02/j2ee/configtool

        /usr/sap/X5J/J02/j2ee/configtool/consoleconfig.sh

        **********************************************************************************

                **********************************************************************************

                tcsh:root@mwrh3:/> /bin/su x5jadm

                mwrh3:x5jadm 51> setenv SHELL csh

                mwrh3:x5jadm 52> setenv mwshell csh

                mwrh3:x5jadm 53> set prompt="`echo $mwshell`:`id |cut -f2 -d'(' |cut -f1 -d')'`@`hostname | cut -f1 -d'.'`:`pwd`> "

                alias idmw "id |cut -f2 -d'(' |cut -f1 -d')'"

                alias cd 'chdir \!* && set prompt="`echo $mwshell`:`idmw`@`hostname | cut -f1 -d'.'`:`pwd`> "'

                csh:x5jadm@mwrh3:/> alias idmw "id |cut -f2 -d'(' |cut -f1 -d')'"

                csh:x5jadm@mwrh3:/> alias cd 'chdir \!* && set prompt="`echo $mwshell`:`idmw`@`hostname | cut -f1 -d'.'`:`pwd`> "'

                csh:x5jadm@mwrh3:/> cd /

                csh:x5jadm@mwrh3:/> setenv DISPLAY 10.6.16.181:0.0

                csh:x5jadm@mwrh3:/> echo $DISPLAY

                10.6.16.181:0.0

                csh:x5jadm@mwrh3:/> cd /usr/sap/X5J/J02/j2ee/configtool

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool> /usr/sap/X5J/J02/j2ee/configtool/consoleconfig.sh

                   INFO: Loading tool launcher...

                   INFO: [OS: Linux] [VM vendor: SAP AG] [VM version: 1.8.0_51] [VM type: SAP Java Server VM]

                   INFO: Main class to start: "com.sap.engine.configtool.console.ConsoleConfigTool"

                   INFO: Loading 19 JAR files: [./lib/sap.com~tc~bl~config~impl.jar, ./lib/sap.com~tc~je~opm.jar, ./lib/sap.com~tc~je~offlineconfiguration~impl.jar, ./lib/sap.com~tc~je~cachegui.jar, ./lib/sap.com~tc~bl~sl~utility~impl.jar, ./lib/sap.com~tc~je~configtool.jar, ./lib/sap.com~tc~bl~opensql~implStandalone.jar, ./lib/sap.com~tc~je~configuration~impl.jar, ./lib/sap.com~tc~bl~iqlib~impl.jar, ./lib/sap.com~tc~exception~impl.jar, ./lib/sap.com~tc~bl~offline_launcher~impl.jar, ./lib/jdbc.jar, ./lib/sap.com~tc~logging~java~impl.jar, ./lib/sap.com~tc~sec~secstorefs~java~core.jar, ./lib/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./lib/sap.com~tc~bl~jarsap~impl.jar, ./lib/sap.com~tc~bl~gui~impl.jar, ./lib/sap.com~tc~bl~deploy~controller~offline_phase_asm.jar, ./lib/jvmx.jar]

                   INFO: Start

                Connecting to database ... OK

                Scanning cluster data ... OK

                Initializing menus ... OK

                1) Safe Mode (OFF)

                -------------------------

                6) Template - Usage_Type_All_in_One ...

                7) Instance - ID225964 (mwrh3) ...

                -------------------------

                12) Exit

                Your choice: 12

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool>

                **********************************************************************************

2)  test to see if configtool.sh gui will connect using the present /usr/sap/X5J/SYS/global/security/data/SecStore.properties

    configtool.sh gui

       ->cluster-data

          ->template - Usage_Type_All_in_One

             ->instance - ID225964 (mwrh3) . . . is present . . . showing DB connectin success

        **********************************************************************************

        /bin/su x5jadm


        setenv SHELL csh

        setenv mwshell csh

        set prompt="`echo $mwshell`:`id |cut -f2 -d'(' |cut -f1 -d')'`@`hostname | cut -f1 -d'.'`:`pwd`> "

        alias idmw "id |cut -f2 -d'(' |cut -f1 -d')'"

        alias cd 'chdir \!* && set prompt="`echo $mwshell`:`idmw`@`hostname | cut -f1 -d'.'`:`pwd`> "'

        cd /

        setenv DISPLAY 10.6.16.181:0.0

        echo $DISPLAY

        cd /usr/sap/X5J/J02/j2ee/configtool

        /usr/sap/X5J/J02/j2ee/configtool/configtool.sh

        **********************************************************************************

                **********************************************************************************

                tcsh:root@mwrh3:/> /bin/su x5jadm

                mwrh3:x5jadm 51> setenv SHELL csh

                mwrh3:x5jadm 52> setenv mwshell csh

                mwrh3:x5jadm 53> set prompt="`echo $mwshell`:`id |cut -f2 -d'(' |cut -f1 -d')'`@`hostname | cut -f1 -d'.'`:`pwd`> "

                csh:x5jadm@mwrh3:/> alias idmw "id |cut -f2 -d'(' |cut -f1 -d')'"

                csh:x5jadm@mwrh3:/> alias cd 'chdir \!* && set prompt="`echo $mwshell`:`idmw`@`hostname | cut -f1 -d'.'`:`pwd`> "'

                csh:x5jadm@mwrh3:/> cd /

                csh:x5jadm@mwrh3:/> setenv DISPLAY 10.6.16.181:0.0

                csh:x5jadm@mwrh3:/> echo $DISPLAY

                10.6.16.181:0.0

                csh:x5jadm@mwrh3:/> cd /usr/sap/X5J/J02/j2ee/configtool

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool> /usr/sap/X5J/J02/j2ee/configtool/configtool.sh

                   INFO: Loading tool launcher...

                   INFO: [OS: Linux] [VM vendor: SAP AG] [VM version: 1.8.0_51] [VM type: SAP Java Server VM]

                   INFO: Main class to start: "com.sap.engine.configtool.visual.ConfigTool"

                   INFO: Loading 19 JAR files: [./lib/sap.com~tc~bl~config~impl.jar, ./lib/sap.com~tc~je~opm.jar, ./lib/sap.com~tc~je~offlineconfiguration~impl.jar, ./lib/sap.com~tc~je~cachegui.jar, ./lib/sap.com~tc~bl~sl~utility~impl.jar, ./lib/sap.com~tc~je~configtool.jar, ./lib/sap.com~tc~bl~opensql~implStandalone.jar, ./lib/sap.com~tc~je~configuration~impl.jar, ./lib/sap.com~tc~bl~iqlib~impl.jar, ./lib/sap.com~tc~exception~impl.jar, ./lib/sap.com~tc~bl~offline_launcher~impl.jar, ./lib/jdbc.jar, ./lib/sap.com~tc~logging~java~impl.jar, ./lib/sap.com~tc~sec~secstorefs~java~core.jar, ./lib/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./lib/sap.com~tc~bl~jarsap~impl.jar, ./lib/sap.com~tc~bl~gui~impl.jar, ./lib/sap.com~tc~bl~deploy~controller~offline_phase_asm.jar, ./lib/jvmx.jar]

                   INFO: Start

                **********************************************************************************


     clicked . . . 
                 

3)  use configtool.sh to change the PORT number (all other items in the url could also be changed)

       see d:\txt\ibm_udb\configtool_gui__change_secure_store.doc

        clicked . . . cluster-data->secure store . . .

        clicked . . . Connection Pools . . . tab . . .

        clicked url line item . . . Url jdbc:db2://mwrh3:10516/X%J:currentSchema=SAPX5JDB;deferPrepares=0;connectionCloseWith . . .

        change . . . Value: from . . . 10516 . . . to . . . 99999 . . .

        click . . . Add . . . button

        clicked . . . X . . . button (top right) to close out configtool.sh gui

        clicked . . . Yes . . . button

        clicked . . . OK  . . . button

clicked . . . . . . tab

clicked url line item . . .


change . . . Value: from . . . 10516 . . . to . . . 99999 ...
click . . . . . . button
clicked . . .

   clicked . . . . . .


4)   exited configtool gui and attempted to startup consoleconfig.sh gui again . . . Connecting to database ... Default DB connection failed

        **********************************************************************************

        cd /usr/sap/X5J/J02/j2ee/configtool

        /usr/sap/X5J/J02/j2ee/configtool/consoleconfig.sh

        **********************************************************************************

                **********************************************************************************

                csh:x5jadm@mwrh3:/> cd /usr/sap/X5J/J02/j2ee/configtool

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool> ./consoleconfig.sh

                   INFO: Loading tool launcher...

                   INFO: [OS: Linux] [VM vendor: SAP AG] [VM version: 1.8.0_51] [VM type: SAP Java Server VM]

                   INFO: Main class to start: "com.sap.engine.configtool.console.ConsoleConfigTool"

                   INFO: Loading 19 JAR files: [./lib/sap.com~tc~bl~config~impl.jar, ./lib/sap.com~tc~je~opm.jar, ./lib/sap.com~tc~je~offlineconfiguration~impl.jar, ./lib/sap.com~tc~je~cachegui.jar, ./lib/sap.com~tc~bl~sl~utility~impl.jar, ./lib/sap.com~tc~je~configtool.jar, ./lib/sap.com~tc~bl~opensql~implStandalone.jar, ./lib/sap.com~tc~je~configuration~impl.jar, ./lib/sap.com~tc~bl~iqlib~impl.jar, ./lib/sap.com~tc~exception~impl.jar, ./lib/sap.com~tc~bl~offline_launcher~impl.jar, ./lib/jdbc.jar, ./lib/sap.com~tc~logging~java~impl.jar, ./lib/sap.com~tc~sec~secstorefs~java~core.jar, ./lib/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./lib/sap.com~tc~bl~jarsap~impl.jar, ./lib/sap.com~tc~bl~gui~impl.jar, ./lib/sap.com~tc~bl~deploy~controller~offline_phase_asm.jar, ./lib/jvmx.jar]

                   INFO: Start

                Connecting to database ... Default DB connection failed

                  FATAL: Main class "com.sap.engine.configtool.console.ConsoleConfigTool" cannot be started:

                  FATAL: java.lang.NullPointerException: while trying to invoke the method com.sap.engine.configtool.data.ClusterData.getTemplates() of a null object loaded from static field com.sap.engine.configtool.console.ConsoleConfigTool.clusterData

                        at com.sap.engine.configtool.console.ConsoleConfigTool.loadTemplatesAndInstances(ConsoleConfigTool.java:153)

                        at com.sap.engine.configtool.console.ConsoleConfigTool.main(ConsoleConfigTool.java:1167)

                        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                        at java.lang.reflect.Method.invoke(Method.java:497)

                        at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:162)

         

                  FATAL: com.sap.engine.offline.OfflineToolStart will abort now with exitcode 2

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool>

                **********************************************************************************

5)  started the configtool.sh . . . gui . . .

       Error occured while scanning DB.

       Msg: Error while connecting to DB.

        clicked . . . OK  . . . button


   clicked . . .

6)  reversed the change to port . . . 99999 to 10516 . . .

       see 3) above

        . . . and now all is fine again . . .


7)  test to see if consoleconfig.sh again . . . succeeds again

        **********************************************************************************

        cd /usr/sap/X5J/J02/j2ee/configtool

        /usr/sap/X5J/J02/j2ee/configtool/consoleconfig.sh

        **********************************************************************************

                **********************************************************************************

                csh:x5jadm@mwrh3:/> cd /usr/sap/X5J/J02/j2ee/configtool

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool> /usr/sap/X5J/J02/j2ee/configtool/consoleconfig.sh

                   INFO: Loading tool launcher...

                   INFO: [OS: Linux] [VM vendor: SAP AG] [VM version: 1.8.0_51] [VM type: SAP Java Server VM]

                   INFO: Main class to start: "com.sap.engine.configtool.console.ConsoleConfigTool"

                   INFO: Loading 19 JAR files: [./lib/sap.com~tc~bl~config~impl.jar, ./lib/sap.com~tc~je~opm.jar, ./lib/sap.com~tc~je~offlineconfiguration~impl.jar, ./lib/sap.com~tc~je~cachegui.jar, ./lib/sap.com~tc~bl~sl~utility~impl.jar, ./lib/sap.com~tc~je~configtool.jar, ./lib/sap.com~tc~bl~opensql~implStandalone.jar, ./lib/sap.com~tc~je~configuration~impl.jar, ./lib/sap.com~tc~bl~iqlib~impl.jar, ./lib/sap.com~tc~exception~impl.jar, ./lib/sap.com~tc~bl~offline_launcher~impl.jar, ./lib/jdbc.jar, ./lib/sap.com~tc~logging~java~impl.jar, ./lib/sap.com~tc~sec~secstorefs~java~core.jar, ./lib/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./lib/sap.com~tc~bl~jarsap~impl.jar, ./lib/sap.com~tc~bl~gui~impl.jar, ./lib/sap.com~tc~bl~deploy~controller~offline_phase_asm.jar, ./lib/jvmx.jar]

                   INFO: Start

                Connecting to database ... OK

                Scanning cluster data ... OK

                Initializing menus ... OK

                1) Safe Mode (OFF)

                -------------------------

                6) Template - Usage_Type_All_in_One ...

                7) Instance - ID225964 (mwrh3) ...

                -------------------------

                12) Exit

                Your choice: 12

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool>

                **********************************************************************************

8)  test configtool.sh gui . . . the DB connection succeeds again

    configtool.sh gui

       ->cluster-data

          ->template - Usage_Type_All_in_One

             ->instance - ID225964 (mwrh3) . . . is present . . . showing DB connectin success

        **********************************************************************************

        cd /usr/sap/X5J/J02/j2ee/configtool

        /usr/sap/X5J/J02/j2ee/configtool/configtool.sh

        **********************************************************************************

                **********************************************************************************

                csh:x5jadm@mwrh3:/> cd /usr/sap/X5J/J02/j2ee/configtool

                csh:x5jadm@mwrh3:/usr/sap/X5J/J02/j2ee/configtool> /usr/sap/X5J/J02/j2ee/configtool/configtool.sh

                   INFO: Loading tool launcher...

                   INFO: [OS: Linux] [VM vendor: SAP AG] [VM version: 1.8.0_51] [VM type: SAP Java Server VM]

                   INFO: Main class to start: "com.sap.engine.configtool.visual.ConfigTool"

                   INFO: Loading 19 JAR files: [./lib/sap.com~tc~bl~config~impl.jar, ./lib/sap.com~tc~je~opm.jar, ./lib/sap.com~tc~je~offlineconfiguration~impl.jar, ./lib/sap.com~tc~je~cachegui.jar, ./lib/sap.com~tc~bl~sl~utility~impl.jar, ./lib/sap.com~tc~je~configtool.jar, ./lib/sap.com~tc~bl~opensql~implStandalone.jar, ./lib/sap.com~tc~je~configuration~impl.jar, ./lib/sap.com~tc~bl~iqlib~impl.jar, ./lib/sap.com~tc~exception~impl.jar, ./lib/sap.com~tc~bl~offline_launcher~impl.jar, ./lib/jdbc.jar, ./lib/sap.com~tc~logging~java~impl.jar, ./lib/sap.com~tc~sec~secstorefs~java~core.jar, ./lib/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./lib/sap.com~tc~bl~jarsap~impl.jar, ./lib/sap.com~tc~bl~gui~impl.jar, ./lib/sap.com~tc~bl~deploy~controller~offline_phase_asm.jar, ./lib/jvmx.jar]

                   INFO: Start

                **********************************************************************************


No comments