Skip to Content

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