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
**********************************************************************************