Thursday, 7 October 2021

How to Activate/Deactivate SAP Table Logging

 

You can use parameter rec/client to activate or deactivate the table logging (changes) in the SAP system. You can set the parameter via transaction code RZ10.

Find the below Options for activate and deactivate.

rec/client = off

Deactivate the table logging.

rec/client = all

Activate the table logging for the entire clients/system.

rec/client = clientNo.xxx   like 000/100/200 etc

 Activate the table logging for only specific client.

To see the logs, execute transaction code SCU3. Click on Evaluate Logs.





If you are looking for a step to disable logging on a specific table, follow below steps,

In transaction code SE13, click on change mode. Uncheck the log data changes. Activate to apply the changes.


Disable Logging for several tables:

Until release SAP_BASIS 731 use the procedure described in SAP Knowledge Base Article 2164574

As of release SAP_BASIS 740 use the procedure described in SAP Knowledge Base Article 2341818

Note:
Recommended to set the parameter rec/client with option client specific. If you set the parameter with all options, performance issue will be arise.

SAP Note 1916Logging of table changes in R/3
SAP Note 2437986 – SCU3 | How to enable logging in the system
SAP Note 3000730 – Impact on enabling table logging with profile parameter rec/client
SAP Note 1834803 – Disable logging of changes on customizing tables




Wednesday, 6 October 2021

SAP Technical Job Repository in SAP S/4HANA

 



SAP Technical Job Repository  in SAP S/4HANA


SAP Standard Jobs Schedule function (transaction SM36) is obsolete in SAP S/4HANA for SAP Technical jobs. Instead of it, we have a new easy way: Technical Job Repository. Technical Job Repository carries out the scheduling of periodic technical sap jobs in the client also this mechanism is carried out automatically by the system. You do not need any interaction and scheduling, unlike the earlier Standard Jobs function in SM36.

New Job Repository function calls the transaction SJOBREPO. SJOBREPO displays an overview of all job definitions delivered and scheduled by SAP in the technical job repository. You can use SJOBREPO to change a job definition within certain limits or to completely deactivate it.



There is a hourly working trigger for technical background job generation. SAP Kernel parameter is responsible for this (rdisp/job_repo_activate_time). These generations logs are stored in table BTCCTL for the last execution time.


More Details refere Snote : 2190119 also find the attachment PDF in this snote.

Sunday, 5 September 2021

How to generate relocate.template file from IBM DB2

 

 
Generate relocate.template from IBM DB2
 
This section describes prerequisites and preparation steps that you have to perform for IBM Db2 for Linux, UNIX, and Windows before starting the system rename procedure.

Prerequisites:

  •     The database instance must be either stopped or - if it is running - there must not be any database connections.
  •     During the procedure it will be started and stopped automatically if required. After the preparation it will be stopped.
  •     Pleases ensure patch level of db6util is patch level 10 or higher. For more information.
  •     The patch level of the brdb6brt tool is patch level 32 or higher.
    If tool brdb6brt does not exist within the /sapmnt/<SAPSID>/exe directory, download and install it.

    IBM Db2 for Linux, UNIX, and Windows V10.1 and Higher only:

    Make sure that your <sapsid>adm user has execute permission for function sysproc.admin_get_storage_paths by running the following command on your source system as user db2<dbsid>:

    db2 "grant execute on specific function sysproc.admin_get_storage_paths to user <sapsid>adm"

    The version of SAP Host Agent must be 7.21 PL 26 or higher.

    If your operating system is Solaris SPARC or Solaris X86_64, the database version must be 9.7 FP7 or higher.

Procedure:

    Make sure that the SAP system is stopped. Use the below command to Create the relocate.template file. This file is required in the tool dialog phase.
 
        On the source system, log on as user db2<dbsid> and create the directory sapdbctrl-config under /tmp. This does not apply if the directory already exists.
        Note

        If directory /tmp does not exist, you must create it before you perform the steps listed below.

        Proceed as follows:

  •         Execute cd /tmp.
  •         Execute mkdir ./sapdbctrl-config
  •         Log off from the system.
  •         Log on again as user root on the source system.
  •         Execute cd /usr/sap/hostctrl/exe.
  •         Execute ./saphostctrl -function PrepareDatabaseCopy -dbname <DBSID> -dbtype db6 -dbconfdir /tmp/sapdbctrl-config/ -dbinstance db2<dbsid> -copymethod Offline -dostatechange.
        The system creates the relocate.template file in the /tmp/sapdbctrl-config directory.

        Check if the file relocate.template contains one or more entries for CONT_PATH or STORAGE_PATH. If not you must not start the system rename procedure.

        This is an example of the files created in the sapdbctrl-config directory:

        root@Techrelam01[Linux]/tmp/sapdbctrl-config > ls -la
        -rw-r----- 1 db2thr dbthradm 2584 Sep 05 19:23 db2thr.cfg
        -rw-r--r-- 1 root   root            46     Sep 05 19:23 db2thr.net
        -rw-r--r-- 1 root   root            8810 Sep 05 19:23 relocate.template

Provide all database-related directories on the target system. This includes the following directories:

    /db2/<DBSID>/

    The file system of the home directory of db2sid (default:/db2/db2<dbsid>).

To provide the required directories, use one of the following methods:
 
Note:
 
The commands below are given as an example if your home directory is db2<dbsid>. You have to adjust them for all required directories.

    If the source and the target system are located on one and the same host, proceed as follows:

    If you want to adjust or rename your SAP system on the same host, keep all directories at their locations.

    The tool will find and move them to the correct directory and set the required ownerships and permissions.

    Note

    If /db2/db2<dbsid> or /db2/<DBSID> is a mount point or there are mount points under these directories proceed as follows:

        Stop the SAP system including its instance agents.

        Unmount the mount points.

        Before you start the system rename, mount the file systems under the target <DBSID> or db2<dbsid>.

    If the source and the target system are located on different hosts, proceed in one of the following ways:

        Mount all file systems manually on the target system
        Recommendation

        This is the recommended option.
        Note

        If /db2/db2<dbsid> or /db2/<DBSID> is a mount point or there are mount points under these directories, then mount the file systems under the target <DBSID> or db2<dbsid>.

        Copy the directories using the copy command of the operating system.
        Note

        When you provide required database related directories on the target host, use the source <DBSID> within the directory names. The tool will find and move them to the correct location and set the required ownership and permissions.

        To keep the current ownership of the directory and softlinks, use an archiving tool as follows:

        source host:~ # tar -cpf /tmp/db2<dbsid_source>.tar /db2/db2<dbsid_source>

        source host:~ # tar -cpf /tmp/<DBSID_source>.tar /db2/<DBSID_source>

        source host:~ # scp /tmp/db2<dbsid_source>.tar <user>@<dbsid_source>:/tmp

        source host:~ # scp /tmp/<DBSID_source>.tar <user>@<target host>:/tmp

        target host:~ # tar -xvf /tmp/db2<dbsid_source>.tar /db2/db2<dbsid_source>

        target host:~ # tar -xvf /tmp/<DBSID_source>.tar /db2/<DBSID_source>

Make sure the contents of the db6_update_db.SAR archive attached to SAP Note 1365982 Information published on SAP site are available in the sapdbctrl-config directory.
Note

Make sure the permissions of file db6_update_db.sh and db6_update_db.jar are rwxr-xr-x. To check the file permissions, enter the following command:

ls -l db6_update_db.sh db6_update_db.jar.

To change the file permission enter the following command:

chmod 755 db6_update_db.sh db6_update_db.jar.

Make sure that you stop all system and database processes before you start the system rename procedure. To check that they are stopped, enter the following command: ps -ef | grep db2  
 
 
 
 
 
 Reference from : Help dot SAP

Thursday, 1 July 2021

How to update the password file using dscdb6up under Windows IBM DB2

 

How to update the password file using dscdb6up under Windows IBM DB2.

If you need to update the password file (dscdb6.conf), if you have changed password of <sid>adm user.

    Scenario 1

    You have changed the OS password of <sid>adm user beforehand.

    Scenario 2

    You have changed the OS password of <sid>adm user together with the password file update.

Solution for scenario 1

    dscdb6up -create <connect_user password> <current <sid>adm password>

    Solution for scenario 2

   dscdb6up <sid>adm <new password>

   Remarks:
   You may get the following error when executing the above command.
   **************************************************************************
   Current OS password does not match password in password file.
   Please enter current OS password for '<domain>\<sid>adm':
   **************************************************************************
   In such case, you need to enter the old (current) password first.

Note: dscdb6up file location SAP Kernel directory.


Friday, 11 June 2021

How to find the list of SAP Notes contained in a SAP Support package.

 

 

How to find the list of SAP Notes contained in a Support package in SAP System.

We are patching the SAP system and need to know the what notes are present in a particular SAP support package.

 Follow the below steps to find the snotes in SAP Support Package. 

We can find the list of SAP Notes which are present in a particular support package using the below steps :

1. Goto the SAP Support Portal (Click Here). 

2. Search for the Support Package. Here I am checking for the SAP HR Support package      SAPKE600G8. You can use the below steps to search for the package.
              https://launchpad.support.sap.com/#/softwarecenter
                --> Search for the Software Download
                --> Now search for the technical name of the package.
                         In my case it is SAPKE600G8.

 

3. Now you should be able to see the package. Click on the Related Info of the package.

             For Eg. In my case, R/3 HR Support Package G8 for ECC 6.0 EHP6 

4. Now you should be able to see the application specific list of Notes.

 

5. Now you can see the list of all the Notes in the Support Package.You can download this list by using the option 'Download list' at the bottom of the page. 

6.Download or open the .CSV file to get list of all snote list.

Now we will get the what are all the snotes in SAP Support package.