This article is relevant if you are looking for adding Local repository  with SAP Data Services Job server on Linux Box..

This article is written using SAP Services XI 4.1 SP02.

This article covers the step by step instructions(with screens wherever its possible) to add SAP Data Services Local Repository with SAP Data Services Job Server using Server Manager Utility on Linux.

This is more useful for those who are doing this first time on LINUX and they are familiar with windows OS.

Following are the commands that needs to be performed at LINUX command prompt.

$ cd $LINK_DIR/bin

$ . ./al_env.sh

$ ./svrcfg

Select Option 2 and then Select “a” for “Adding a REPO to Job server”  then select the “Serial number of the Jobserver” which you like to process Jobs of the Local Repository, then finally select the Local repository specific details like User name, password, Database name, Host name etc. and confirm you details.

Pls see the following step by step instructions to add Data services Local repository with Data Services Job Server on Linux.

Login Via Putty,

Putty_Login_screen01.JPG

Input :- Provide hostname and Hit Enter. Provide your credential so that you can access Linux.

Putty_Login_screen.JPG

Once you are logged in. navigate as instructed in following steps.

Go to Installation directory of Data Services on Linux box. Generally referred as %LINK_DIR% in all SAP documents

IF you logged in with named user, then check where you are, user PWD command on Linux prompt once you successfully login to server.

$ cd $LINK_DIR/bin/

%LINK_DIR% = /usr/sap/<SID>/businessobjects/dataservices

$ cd /usr/sap/FDM/businessobjects/dataservices/bin

$. ./al_env.sh

$ ./svrcfg

Unable to load DLL or shared library <libds_crypto.so>. Please make sure the library is installed and located correctly.

If you see the above error then you do not have permission to perform the Operation. There are two options as going forward.

Either you request for the permissions on your user id or you can get the user which has the permissions already.

So switch user will help you to do that. However, getting sudo access on your user id is the recommended way.

Generally SAPDS<SID> is the OS user have the permissions.

use su – username to swtich the user and provide the password.

So I switched the User and performed the same tasks. please see the screen.

-bash-4.1$ cd /usr/sap/FDM/businessobjects/dataservices/bin
-bash-4.1$ . ./al_env.sh
-bash-4.1$ ./svrcfg

** Data Services Server Manager Utility **

       1 : Control Job Service
       2 : Configure Job Server
       3 : Configure Runtime Resources
       4 : Configure Access Server
       5 : Configure SNMP Agent
       6 : Configure SMTP
       7 : Configure SSL
       8 : Configure Native Component Supportability
       x : Exit

Enter Option:

We have chosen Option 2, because we would like to register some of our repositories with Job Server.

If you have more than one Job Server then select accordingly. In this case it has only One Job server

Enter Option: 2
_____________________________________________________________________

                 Current Job Server Information
_____________________________________________________________________

S#  Job Server Name  TCP     Enable   Repository Information
                     Port     SNMP
—  —————  —–  ——–  —————————-

1   JS_FDM_001       3500      N      ds_sh_lr@hlx.unix.com_RP_FDM_ds_sh_lr
                                      ds_sh_l2@hlx.unix.com_RP_FDM_ds_sh_l2
                                      ds_s2_lr@hlx.unix.com_RP_FDM_ds_s2_lr
                                      ds_s2_l1@hlx.unix.com_RP_FDM_ds_s2_l1
                                      ds_s2_l2@hlx.unix.com_RP_FDM_ds_s2_l2
                                      ds_s2_l3@hlx.unix.com_RP_FDM_ds_s2_l3
                                      ds_s2_l4@hlx.unix.com_RP_FDM_ds_s2_l4

_____________________________________________________________________

c : Create a new JOB SERVER entry       a : Add a REPO to job server
e : Edit a JOB SERVER entry             y : Resync a REPO
d : Delete a JOB SERVER entry           r : Remove a REPO from job server
u : Update REPO Password                s : Set default REPO
q : Quit

Enter Option:

I have chosen Option “a”, as we like to register our Repository with Job Server.

You need to provide the relevant information about the Local Repository you like to register it with Data services Job Server.

Enter Option: a
Enter serial number of Job Server: 1
1)    Oracle
2)    MySQL
3)    DB2
4)    Sybase ASE
5)    SAP HANA
Enter the database type (1,2,3,4 or 5) for the associated repository: 3

Do you want to use data source (ODBC) ‘Y|N’? [Y]: N

Enter the repository database server name: hlx.com

Enter the repository database port number: 50000

Enter the repository database name: RP_FDM

  1: DB2 UDB 9.x
Select the repository database version ‘1’ [1]: 1

Enter the repository username: ds_s2_l5
Enter the repository password (not echoed):
Confirm the repository password (not echoed):

Passwords do not match!!! Please enter them again.
Enter the repository password (not echoed):
Confirm the repository password (not echoed):

S#  Job Server Name  TCP     Enable   Repository Information
                     Port     SNMP
—  —————  —–  ——–  —————————-

1   JS_FDM_001       3500      N      ds_s2_l5@hlx.com_RP_FDM_ds_s2_l5

Is this information correct [Y/N]?

Once you are happy with the information you provided you can confirm it.

Is this information correct [Y/N]? Y

Updating the repository <ds_s2_l5@hlxd0bf004.unix.marksandspencerdev.com_RP_FDM_ds_s2_l5>.  Please wait…

Continue to Add/Modify/Delete Job Servers[Y/N]:

If you have more repositories to configure or add it with Job server then you may select “Y”. As I like to to add more repo to Job Server.

If you are done you can happily select “N”. And Job Done 🙂 Go to Last Step.

Here in screen Below you can check and confirm that the repository you were upto is now actually registered with the selected Job server.

Continue to Add/Modify/Delete Job Servers[Y/N]: Y
_____________________________________________________________________

                 Current Job Server Information
_____________________________________________________________________

S#  Job Server Name  TCP     Enable   Repository Information
                     Port     SNMP
—  —————  —–  ——–  —————————-

1   JS_FDM_001       3500      N      ds_sh_lr@hlx.unix.com_RP_FDM_ds_sh_lr
                                      ds_sh_l2@hlx.unix.com_RP_FDM_ds_sh_l2
                                      ds_s2_lr@hlx.unix.com_RP_FDM_ds_s2_lr
                                      ds_s2_l1@hlx.unix.com_RP_FDM_ds_s2_l1
                                      ds_s2_l2@hlx.unix.com_RP_FDM_ds_s2_l2
                                      ds_s2_l3@hlx.unix.com_RP_FDM_ds_s2_l3
                                      ds_s2_l4@hlx.unix.com_RP_FDM_ds_s2_l4
                                      ds_s2_l5@hlx.unix.com_RP_FDM_ds_s2_l5

_____________________________________________________________________

c : Create a new JOB SERVER entry       a : Add a REPO to job server
e : Edit a JOB SERVER entry             y : Resync a REPO
d : Delete a JOB SERVER entry           r : Remove a REPO from job server
u : Update REPO Password                s : Set default REPO
q : Quit

Enter Option:

Now can repeat the steps if you like to add more Local repositories with Job Server.

Last step:-

Once you are done with the all the steps that you have performed above it will ask you the same details, if you say yes “N” then it will bring up the main menu where you can select Exit option. If all you want from Job Server is done.

Continue to Add/Modify/Delete Job Servers[Y/N]: N

** Data Services Server Manager Utility **

       1 : Control Job Service
       2 : Configure Job Server
       3 : Configure Runtime Resources
       4 : Configure Access Server
       5 : Configure SNMP Agent
       6 : Configure SMTP
       7 : Configure SSL
       8 : Configure Native Component Supportability
       x : Exit

Enter Option: x

************************************************************************END of the Article*********************************************************************************

1. If you are interested to perform some other server Management (Data Services Application, Job Server) then you may see this article

How to Start/Stop Data services Server on LINUX

Data Services on Linux – Version check of Data Services Components

SAP Data Services on LINUX

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply