SAP MAXDB Backup using command line tool

 

SAP MAXDB Backup using the command-line tool

Use the command-line tool DBMCLI to take a DATA or LOG backup of the SAP MAXDB database. Follow the below command to take backups through the command-line tool.

Steps:

1. Open DBMCLI from the command prompt in the following location: /sapdb/programs/bin.

./dbmcli -d <SID> -u superdba,<password>

2. Check the DB state. 

./dbmcli on <SID>> db_state

OK

State

ONLINE

---

3. If you want to take offline backups stop the database (for Offline backups)

db_offline   

 

 (or)

db_admin

4. We need to create a backup template to take backups of data and logs.

For data (path location of Linux),

medium_put <data backup template name> "/<location>/<filename>" FILE  DATA

For Log (path location of Linux)

medium_put <log backup template name> "/<location>/<filename>" FILE  LOG

5. Connect the database before taking backups.

db_connect

6. Take a complete data backups.

backup_start <data backup template name>

7. Take log backup

backup_start <log backup template name>

8. Check the backup status after completion.

backup_state

(or)

medium_label <backup template name>

9. Start a database

db_online

10. Find the below reference link for more details.

Education purposes only : Click here

For your reference.

How to reset Software Update Manager SUM tool

 

Usually we are using the below typical steps to reset the SUM process.

Follow the steps specified below to reset the SUM Process.

1. Go to the directory SUM\abap\bin.

2. Enter the command “\SAPup reset prepare”

3. Delete the SUM directory.

4. End all SAPup processes on the OS level before, if any exist.

5. Please try to run report RSUPGRES. This will solve UVERS inconsistency.

6. Start everything again from the beginning.

The report, mentioned in step 5, should be used carefully and only in emergency cases.

• Execute only with user DDIC in client 000.

• Start in background, the program takes about 20 and 30 minutes.

• The process should not be aborted manually!!!

• This report works for SUM SP10 and higher.

Configuring SAProuter as a service on Linux

 

SAP Router installation on Linux: click here. once the SAP Router installation.

Follow the below Steps to configure SAP Router "as a service" in a Linux environment (SUSE,REDHAT,,,,etc).

First of all, create the below two service files at the mention location.

1. Execute the below command to Create ".service" and ".sh" files (on linux)

saprouter:/etc/systemd/system # touch saprouter.service

saprouter:/etc/init.d # touch startsaprouter.sh

2.  Add the below entries to the "saprouter.service" file based on your environment. 

saprouter:/etc/systemd/system # vim saprouter.service

[Unit]

Description = SAP Router start Service

After = network.target

[Service]

ExecStart = /etc/init.d/startsaprouter.sh

[Install]

WantedBy = default.target

3.   Add the below entries to the "startsaprouter.sh" file based on your environment.

saprouter:/etc/init.d # cat startsaprouter.sh

#!/bin/sh

export SECUDIR="/usr/sap/saprouter"

export SNC_LIB="/usr/sap/saprouter/libsapcrypto.so"

export LD_LIBRARY_PATH="/usr/sap/saprouter"

export LIBPATH="/usr/sap/saprouter"

cd /usr/sap/saprouter

./saprouter -r -K "p:CN=saprouter,OU=0000123456,OU=SAProuter,O=SAP,C=DE"

4.    Save and execute the below command to provide permission for the .service and .sh files.

saprouter: chmod 775 /etc/init.d/startsaprouter.sh

saprouter: chmod 775 /etc/systemd/system/saprouter.service

5.  Execute the below command to Start the SAP Router as a Service.

saprouter:/etc/systemd/system # systemctl start saprouter.service

6.    Check the SAP Router status.

saprouter:/etc/systemd/system # systemctl status saprouter.service

Saprouter.service - Saprouter start

     

Loaded: loaded (/etc/systemd/system/saprouter.service; disabled; vendor preset: disabled)

     Active: active (running) since Sat 2023-07-15 10:58:06 IST; 5s ago

   Main PID: 7961 (startsaprouter.)

      Tasks: 2

     CGroup: /system.slice/saprouter.service

             ├─ 7961 /bin/sh /etc/init.d/startsaprouter.sh

             └─ 7962 ./saprouter -r -K p:CN=saprouter,OU=0000123456,OU=SAProuter,O=SAP,C=DE

7. Use the below command to enable the automatic startup of the SAP Router service.

saprouter:/etc/systemd/system # systemctl enable saprouter.service

Created symlink /etc/systemd/system/default.target.wants/saprouter.service → /etc/systemd/system/saprouter.service.

8.    Check the status of the SAP Router service with the Startup option.

saprouter:/etc/systemd/system # systemctl status saprouter.service

 

saprouter.service - Saprouter start

     Loaded: loaded (/etc/systemd/system/saprouter.service; enabled; vendor preset: disabled)

     Active: active (running) since Sat 2023-07-15 10:58:06 IST; 41s ago

   Main PID: 7961 (startsaprouter.)

      Tasks: 2

     CGroup: /system.slice/saprouter.service

             ├─ 7961 /bin/sh /etc/init.d/startsaprouter.sh

             └─ 7962 ./saprouter -r -K p:CN=saprouter,OU=0000123456,OU=SAProuter,O=SAP,C=DE

Note: Kindly give the correct "Distinguished Name" for smooth execution.

Thanks.

Happy reading.

 

ADBC_TEST_CONNECTION failed due to "Couldn't load library" error

 

ADBC_TEST_CONNECTION failed due to "Couldn't load library" error While testing HANA DB connection from Solman to managed system.

B Thu Mar  17 16:48:52:454 2022

B  Loading DB library '/usr/sap/<SID>/SYS/exe/run/dbhdbslib.so' ...

M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/<SID>/SYS/exe/run/dbhdbslib.so") FAILED

  "libSQLDBCHDB.so: cannot open shared object file: No such file or directory"  [dlux.c       550]

M  {root-id=0050569B3EBD1EDCA6DFAC01A71270F8}_{conn-id=6220EF4CCF0B5E29E10000000ACCE034}_1

B  *** ERROR => Couldn't load library '/usr/sap/<SID>/SYS/exe/run/dbhdbslib.so'

 [dbcon.c      7086]

B  ***LOG BYG=> could not load library for database connection ABP [dbds         972]

B  ***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds       2063]

B  *** ERROR => Unexpected RC when calling dsql_connect

 [dbacds.c     2064]

B

B Thu Mar  17 16:48:55:896 2022

B  dbsync[db_syexe]: wait=0, call_no=79848, current_ts=20220303082355, last_counter=2022-03-03-14.19.16.321299

Solution:

Add an equation mark between the OS variable and its value, and restart the application server to take it effect.

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/sap/<SID>/hdbclient

export PATH=${PATH}:/usr/sap/<SID>/hdbclient

How to customize the Fiori Launchpad URL

 

How to customize the Fiori Launchpad URL?

Follow the steps to Customize the Fiori Launchpad URL.

Customizing the Launchpad URL

You can make the launchpad available under a custom URL by creating an external alias.

Procedure:

• On the front-end server, start transaction "SICF".
• Select hierarchy type SERVICE, then choose .
• Choose  External Aliases.
• Select a host, then choose External Alias  Create.

In the External Alias field, enter the alias under which you want the launchpad to be available.

Enter an alias of your choice, for example:

/fiori

On the Target Element tab, select the following target handler:

/sap/bc/ui2/flp

Results:

After doing the configuration as shown in the example above, you can launch the launchpad using a nice and short URL like this:

<protocol>://<host>:<port>/fiori/

Thanks to visit my blog

Automatic Job Scheduling is switched off in S/4HANA

 

Automatic Job Scheduling is switched off

In SAP transaction SJOBREPO -> 'Technical Job Definition Attributes' shows the message "Automatic Job Scheduling is switched off" look like below.

if SAP Job Repository state has:

• Job Automation is possible, Job Repository runs according to S/4HANA On-Premise Flavor
• Job Repository Job Automation is not active in this system
• Job Repository Job Automation is currently deactivated via BTCOPTIONS

Follow the below steps to switch on the Automatic job scheduling.

1. Transaction => SE38, run the report R_JR_UTIL_1

2. Select 'Change Job Repository State' and activate.

3.  Now Automatic job scheduling is switch on.

Reference : SAP Snote 2790150 for educational purpose.

What is Bootstrap in SAP JAVA Stack?

 

What is Bootstrap in SAP JAVA STACK?

Bootstrap is the process of synchronizing the binaries of the SAP Java stack with the SAP system database. 

This synchronization ensures that the SAP Java stack is up to date and running the same version as the database. After the synchronization is complete, the system is ready to start. 

Bootstrap is the first step in the startup process of the SAP Java stack and is an important part of regular system maintenance.

How much free space is needed for the exported data of SAP System Copy?

 

How much free space is needed for the exported data of SAP System Copy?

If you are going to perform System Copy export for an SAP ABAP system. You want to know, how much free space is needed for the exported data in the file system. I mean Approximate Export dump file size.

The first test migration requires 10%-15% of the uncompressed source database size as export file system free space.

 

Depending on the source database used for the export, a data compression ratio of between 1:4, and 1:10 or more can be achieved. The compression is performed at block level, so the file cannot be decompressed as a whole.

 

Please note that, the "compression ratios may vary depending on the different DB type and version". It is always highly suggested to perform test runs on systems which has similar data with the Production system. In the test runs, you can learn about the exported data size in a more accurate manner. 

Reference : KBA for educational purpose