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: 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: 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: 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: Start

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

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

Malcolm Weaver
August 16, 2016 at 02:11 AM
0 Likes

0 replies

No comments

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

Malcolm Weaver August 16, 2016 at 02:11 AM 0 Likes

0 replies

No comments

Malcolm Weaver
August 16, 2016 at 02:11 AM
0 Likes