IBM Support

Switching from XDA to XDN for SAP Applications

Troubleshooting


Problem

This document provides information on switching from XDA to XDN with SAP applications.

Resolving The Problem

This document provides information on switching from XDA to XDN with SAP applications.

1.

The master switch between the NEW technology (XDN) and the old (XDA) is accomplished with Option 50 in the Database menu of the Central Instance:

a. Sign on as <SID>OFR.

b. Select the following:
-- Option 4. SAP Database
-- Option 50. Change Database Driver for SAP (XDA <-> XDN)

Option 50 from the SAP Database Menu is selected.

c. The SETDBDRV menu appears which will set profile parameters in DEFAULT.PFL. (Use F1 for Help).

The Set Database Driver command is set to Drive Type *XDN and User Profile QSECOFR.

(Trying to switch on a non-central instance will return: ERROR: main: Can't Install on this Host).
2.To disable a particular SAP instance, add the following to the INSTANCE profile:

dbs/db4/driver_type = XDA
3.To take advantage of new features, you can *optionally* make the following changes to INSTANCE profiles:

Windows / Linux Application Instances:

REMOVE: dbs_db4_da_cache_size
ADD: dbs/db4/dbsl_buffersize = 524288

IBM i 2-Tier (Only needed for 640):

ADD: dbs/db4/allow_cancel = 1
4.Once changed, the application servers must be restarted for the change to take effect. Windows requires a restart of the SAP<SID>_nn
service also (so the profile parameters are re-read from the file).
5.The SAP work process developer trace shows relevant information:

C driver = DBSLDirectDrive
C dbhost = as0012
C dbhostport = 9622

C da_cache_size = 100
C dbsl_buffersize = 131072

C dbjobname = XDNS4U8000
C dbjobuser = S4UOFR
C dbjobno = 326633

C allow_cancel = ON
6.To see active database server jobs on the central instance, do the following:

a. Sign on as <SID>OFR.

b. Select the following:
-- Option 1. General SAP Tasks
-- Option 7. Work with SAP Database Server Jobs

__ XDNS4ULSN - Database Listener for SID='S4U'
__ XDNS4U0100 - Database Job for SID='S4U', INST=01, WP=00
__ XDNS4UCCMS - CCMS Job

[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"General","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Historical Number

592460174

Document Information

Modified date:
18 December 2019

UID

nas8N1011659