Changing J2EE driver to native

[Former Member]

Hi Group,

Has anybody changed the JDBC driver to the native one?

NW04s SR1 install does no more explicitly ask for which driver to install, so I ended up witch a slow toolbox java JDBC driver, and customer is complaining about speed. It's time to change to the native driver. (all is on one i5 box).

Has somebody made a more comprehensive manual than oss note 826449 : iSeries: Changing the JDBC driver:?

After changing the secure store, the (offline) config tool is no more able to connect to the database

OSS note 657117 : iSeries: JDBC configuration of config tool says something about:

DataSource jdbc/pool/<SID>_REMOTE has not been configured yet, you must configure them now.

How, where and with which parameters do I create or add or copy this new datasource?

I tried copying all the lines jdbc/pool/QAS to a new line /jdbc/pool/QAS_REMOTE. Using the toolbox driver url.

But config tool still says it can not find a datasource of QAS_REMOTE in the secure store

Help appreciated,

Paul Hoogendoorn

[Former Member · Accepted solution]

Hi Paul,

at first I'm wondering why the 04s SR1 installer shouldn't ask for the JDBC driver any more? I'm pretty sure that it is still possible to select native driver although toolbox might be the default. Maybe you forgot to select the JDBC driver dialog for revision or so.

However, you now have a system running with toolbox and need to reconfigure it for native. The best documentation for that really is 826449. But when something is missing or unclear just let us know, we can revise this.

As for the configuration of the config tool I suggest you do the following:

Since it looks as datasource jdbc/pool/<SID>_REMOTE was not created yet (which is the way it should work if you are running toolbox) you have to create it manually (as SAP note 826449 tells).

To do this, please do the following:

1. Backup your file /usr/sap/<SID>/SYS/global/security/data/SecStore.properties

2. Open that file in a text editor

3. Copy the line starting with jdbc/pool/<SID> to another line and then change the jdbc/pool/<SID> to jdbc/pool/<SID>_REMOTE in that new line

4. Save the file

5. Start configtool, you should now see entries for jdbc/pool/<SID>_REMOTE and jdbc/pool/<SID> in the secure store.

6. Edit those settings via config tool to have jdbc/pool/<SID>_REMOTE contain toolbox parameters and jdbc/pool/<SID> contain the settings for the native driver.

I hope that helps and will also look if this info can be added to SAP note 826449.

Best regards,

Christoph

[Former Member · Accepted solution]

Hi Christoph,

Thanks for clarifying how to define the DataSource <SID>_REMOTE.

It worked!

Please also update this method in oss note 657117 : iSeries: JDBC configuration of config tool

There it also says something about:

For the Deploy Tool, change the following lines in /usr/sap/<SID>/j2ee/deploying/rdb.properties.

But no more explanation is given.

What (if any) should there be changed?

Kind regards,

Paul

[Former Member · Accepted solution]

Hi Christoph,

>at first I'm wondering why the 04s SR1 installer shouldn't ask for the JDBC driver any more? I'm pretty sure that it is still possible to select native driver although toolbox might be the default. Maybe you forgot to select the JDBC driver dialog for revision or so.

The NW04s SR1 install does not ask for which driver you want. The ECC 6.0 and EPP installs i've done all ended up using the toolbox driver.

You can however revise these settings yourself at the end, and change to the native driver before installation really starts.

I just did so to see how the native driver is natively set up.

Now the native <jdbc_url> from that installation looks like:

jdbc:db2iSeries:*LOCAL<b>/SAPEPDDB</b>;<properties>

Note 826449 : iSeries: Changing the JDBC driver has a different <jdbc_url>, without the /SAP<SID>DB addition to *LOCAL.

Which one should I use?

Kind regards,

Paul

[Former Member]

Thanks all,

Toolbox driver has now been switched to the faster native one.

Paul

[Former Member]

Hi Paul,

I checked with the DB team and the best way to go would be just using *LOCAL. The schema name should be determined by the user (SAP<SID>DB). So this is a small bug in the installer. However, using *LOCAL/SAP<SID>DB wouldn't cause any issue or difference in behaviour currently.

Best regards,

Christoph

[Former Member]

Hi Paul,

good to know that it helped!

We are currently working on refining both notes. I'm in the process of talking to my database colleagues. Maybe editing the securestore properties file is not the way we really want to recommend but it just works

Regarding installation, see Barbara's answer...

Best regards,

Christoph

[Former Member]

Hello Paul,

starting with Release NW04s SR1, SAP introduced the Default Mode to the installation. When you start the installation, you only see a subset of dialogs.

At the end of the dialog phase, you get an enhanced, longer Summary dialog and can then revise all dialogs (those shown and those not shown). Select the dialog that you want to revise, push the "Revise" button, and you'll see the standard JDBC driver dialog that lets you select the Native Driver for your system.

You'll see the Summary dialog again, this time with your changed selection. Go for it and press "Start".

Best regards, Barbara Roth