DB2 Index Creation for SAP BDLS

During our SAP Refresh Activity, we have seen it’s taking too much time on VBAP table while performing the BDLS activity.

DB2 Version –
SAP NW Version – 7.01

There are 2 ways to create, either you can create via SE11 then use SE14 to create in DB or else run below command to create directly in DB.

I have created the same directly in DB and once BDLS activity get completed, dropped the index.

db2 “create index VBAP_Z02 on .VBAP ( MANDT , LOGSYS_EXT )”

update runstats of table(Mandatory after creation of Index)

db2 “runstats on table .VBAP with distribution all coloumns and detailed indexes all”

Post completion of above 2, you can trigger the BDLS.

Drop of Index (Post BDLS)

db2 “drop index VBAP_Z02”

Let me know if this helps you.

Leave a Reply

Your email address will not be published. Required fields are marked *

five × 1 =

Time limit is exhausted. Please reload CAPTCHA.

How I passed Google Cloud Digital Leader Exam

Recently I test my knowledge by giving GCP Digital Leader Exam on 21st May 2022. This is the basic exam which test you knowledge in Google Cloud space. This exam helps you to understand the services and offering by GCP and understanding of basic concepts. This exam doesn’t test your working technical skills. it’s mainly focus on right approach while suggesting, migrating, creating your workloads in Google Cloud

There are 60 questions in the exam and google doesn’t reveal your % passing marks in the end. You can only see PASS or FAIL in the end.

As i said earlier this is not an technical hands on exam hence as per my understanding questions are regularly updating as per the market trends and new offering. I have gone through multiple documentations, hands on learning and navigate google cloud new offerings to understand and use cases of them.

Below are the helpful links which help us to clear the exam —

#Best you tube video to understand —

Google Cloud Digital Leader Certification Course — Pass the Exam!


This video is provided by freecodecamp and you can also create an account in exampro.co where you can find digital leader exam questions, however these exam questions are not up to dated but this can help you to understand the concepts.

P.S. — Don’t believe blindly that these questions are real exam questions.

# Google Official Documentation —


Solve Business Challenges with Google Cloud | Google Cloud Training
Cloud Digital Leader Introduction to Digital Transformation with Google Cloud Innovating with Data and Google Cloud…

This documentation is itself sufficient to clear the exam and also help you understand the cloud evolution, transformation, innovation, security and infrastructure of Google Cloud Platform.

#Console of Google Cloud Platform —

Create your free account in GCP and navigate all the services, offering. Compare these services with different options. Read all the Pros and Cons and you are good to go with CLOUD DIGITAL LEADER EXAM.

Leave a Reply

Your email address will not be published. Required fields are marked *

20 − eighteen =

Time limit is exhausted. Please reload CAPTCHA.

Configure 2 SFTP Destinations in SAP BO

Recently there is an requirement to to send schedule reports from SAP BO 4.1 SP7 to two different SFTP locations.

For configuring SFTP, you requires fingerprint. There are multiple ways to generate, you can get more details from here –


This can be achieved by configuring SFTP destination in Servers – Adaptive Job Server – Destinations.

You can configure 1 SFTP destination at a time in Adaptive Job Server – Destination & for second SFTP destination you need to create a clone of Job Server & configure with second SFTP destination.

Now if you schedule the Job for Webi Reports, fill the SFTP destination field. it will pick the server automatically as given option – Use the first available server.

The problem on this scenario is, I am getting success in sending the report to first SFTP destination but for second SFTP destination, it’s continuously failing with sftp error as SFTP destination is different as compare to configure in Job Server.

My challenge to give Second Job Server for sending the reports to my second SFTP destination. While scheduling you cannot select the Job Server however there is an option to select Job Server Group.

To achieve this, I have created a Job Server Group in CMC — Servers with the name Job Server & assign the second Adaptive Job Server to this Group.

I have suggested now to schedule the report again & choose option – Give preference to servers in selected group.

This time it will pick the job server assigned to this group & it will send the data to second SFTP destination successfully.

A major drawback of this configuration is, if a job server assigned to this group get stopped then it will stop sending data to SFTP destination & job also start getting failed.

Leave a Reply

Your email address will not be published. Required fields are marked *

11 − 4 =

Time limit is exhausted. Please reload CAPTCHA.

SAP Web Dispatcher Configuration

We have recently installed a new PO 7.5 landscape & want to add this system to web dispatcher.

While adding in Web Dispatcher, we have checked System is showing in Web Disp with Error “Resource Temporary Unavailable”.

We have checked through multiple SAP notes & it’s an error related to Groups.

As we are on JAVA system 2 groups (/J2EE/icr_groups & /J2EE/icr_urlprefix) need to maintain in ConfigTool with cluster restart to resolve this issue.

SAP Note – 1282692 help on this.

Once we added the group in Web Disp & restarted the cluster, it’s showing available in Web Dispatcher & traffic started flowing.

Leave a Reply

Your email address will not be published. Required fields are marked *

13 − two =

Time limit is exhausted. Please reload CAPTCHA.


Recently we are getting issue in our SSO connectivity between SAP Business Objects 4.2 SP5 to SAP BW system. We have crosscheck the SSO certificate & it’s valid till 2025 but still it’s throwing the below error for all end users –

JCO_ERROR_LOGON_FAILUREL:Initialization of destination custom_xxxxxxxxxxxxxx failed: System received an expired SSO ticket on xx.xx.xxx.xxx. sysnr 00

There is no change in the SAP level & OS level as well & no OS patching has been done & suddenly it’s started for Analysis for Excel, Webi reports etc…

While going through the multiple things, we have identified that there is 3 minute time difference between SAP Business Objects Server & SAP BW Server. SAP BO server is 3 minute late with SAP BW server, due to this SSO ticket is expiring as BW is not accepting the same.

We update the NTP configuration in SAP Business Objects Server to sync the time with SAP BW server & verified the same at OS level. No need to restart the SAP BO or BW server.

Recheck the SSO functionality again & Voila, now it’s working fine for all BO related stuff.

Leave a Reply

Your email address will not be published. Required fields are marked *

one + sixteen =

Time limit is exhausted. Please reload CAPTCHA.

SAP USMM – User Licensing Report

USMM is a SAP licensing Tool to determine the number of users and the chargeable objects of the modules for SAP system.

Submitting Licensing report to SAP

Step 1: Generate License report

Navigate to USMM tx in SAP system & click on ‘System Measurement’

The system measure would trigger some background jobs which can be monitor from SM37, looks for jobs RSUVM* & wait for these jobs to be completed.

Go to ‘System measurement in the Menu and click on ‘Export to Law file’.

Save the file to a local folder (i.e. – USMM_License)

Step 2: Generate License report on all SAP systems

Perform this step in all the SAP systems
Save the License file for each system in the local folder

Step 3: Submit Report to SAP

Log on to any SAP production system.

In this system run transaction SLAW

This is the License Administration Workbench

Import all the systems data using the first icon on step 1 (Import Data of a System)
Once all the systems LAW files are imported from all SAP systems(already generated report)
Click on Combine Users –> Click on Consolidate All Data
DO NOT click on ‘Send results’ button yet.

Go to results tab to make sure to verify & review the reports along with the stake. Once numbers are satisfactory, you are good to submit report to SAP.After the number are satisfactory.

Click on Send (This will send the report to SAP)

Leave a Reply

Your email address will not be published. Required fields are marked *

twenty − 8 =

Time limit is exhausted. Please reload CAPTCHA.

LMBI – License Measurement tool for Business Objects

As per my earlier post, i have shared how BO licensing works.

Once you have install the BO license (CS & named user), now it’s time to audit the license as per license Contract with SAP. LMBI tool requires to perform this action.

This tool will run 2 things – Measurement & Consolidation.

Measurement – This need to run first time based on your version (32bit/64bit) by giving BO administrator credentials, once it’s collected the data successfully. it’s create the measurement.xml file in the respective location. This file requires to import in Consolidation tool.

Consolidation – This tool import the previous run measurement.xml file & ask you several questions. i.e. BO is standalone or integrated server, CPU details, licensing contract with SAP & will show the output whether you are consistent with your license or not.

Below Notes helpful to perform the action –

2817296 – Need correct License Measurement Tool (LMBI) for BI Platform
2383265 – How to launch License Measurement Tool (LMBI) when CORBA SSL protocol is configured

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + two =

Time limit is exhausted. Please reload CAPTCHA.

How SAP Business Objects Licensing works

There are different type of licensing available for SAP Business Objects as per the version installed. SAP released multiple notes to understand the same. This is quite different from SAP ABAP & JAVA system.

This comes with “Named User License”, “Concurrent Sessions Based Licensing”, CPU based etc…

Most details covers in below notes –

1285639 – What license types are available for Business Objects Enterprise?

1794184 – What are the different license types (NUL, CAL, CS, CSBL, CPU) for SAP BusinessObjects products

2251998 – How to generate license keys for SAP BusinessObjects Business Intelligence Platform (all versions)

1251889 – License key request for SAP Analytics Solutions (previously SAP BusinessObjects)


Example –

NUL Licensing – Means how many named user login into the system simultaneously. These are guaranteed users which will get the access of BO system.

CSBL Licensing – Means suppose 1 user login into the BO system & then he login into crystal reports or create any other session without disconnecting the previous one, then he is creating multiple concurrent sessions & if these sessions are exhausted by some users then another user can’t login into the system & it will throw an error.

CPU based licensing – Means unlimited named users & concurrent sessions,based on your BO hardware, ideally how many CPU cores & metrics installed in Virtual/Physical server.


Monitor the Current Usage of SAP Business Objects –

Before changing/updating license in BO, please verify the Global System Metrics on your Business Objects Server.

Login into BO Application ——–> Settings ————> View Global System Metrics

The above will show the Purchased license details with Peak License Used.

Leave a Reply

Your email address will not be published. Required fields are marked *

two × 4 =

Time limit is exhausted. Please reload CAPTCHA.

How to run DB2 commands for SAP

useful DB2 commands which needs to run to administer the DB2 Database for SAP workloads.

#To start DB2

#To connect to particular database
db2 connect to dbname

#To check DB configuration/parameters
db2 get db cfg for dbname

#To update DB configuration/parameters
db2 update db cfg for dbname using LOGARCHMETH1 DISK:/db2/TST/archivelog

This is an example, you can update any parameter as per your requirement. LOGARCHMETH1 is parameter which need to update to keep the archive logs, This parameter is visible by check DB configuration command & after updating any parameter, DB restart requires & sometimes offline DB backup requires before starting up the DB.

#Backup DB2 Database
db2 backup database dbname to /location

#Restore DB2 Database
db2 restore db dbname from /location on /db2/TST/sapdata1

The above command will restore the DB on /db2/TST/sapdata1 folder. Make sure to check the DB parameters once restore completed as it always point to old configuration. After restore many times DB can’t start & throw roll forwarding error, in this case you need to complete the roll forwarding with below command –

#To end the roll forward status
db2 rollforward db TST to end of logs & complete

#To deactivate DB before shutting down
db2 deactivate db dbname

#To shut down DB normally

#To shut down db forcefully as application connections were still exists
db2stop force

#To check all schema in DB2 DB
db2 select schemaname from syscat.schemata

#To list all the tables for all DB’s
db2 list tables for all

#To list all the tables in respective DB
db2 list tables for schema dbname

#To manually generate the archive logs
db2 archive log for database dbname

#Unlock DDIC or any other user in DB2
db2 “update SAPSID.USR02 set UFLAG=0 where BNAME=’DDIC’ and MANDT=’000′

#Check HA/DR status in DB2
db2pd -d dbname -hadr | grep -i hadr

DB2 HA/DR Cluster Stop / Start

SAP application should be shut down before stopping the DB2 cluster.

Azure SUSE Linux host running on SBD cluster – Cluster should be set on maintenance mode
(This is a mandatory step otherwise Virtual Name will switch to other host if DB get down in Primary mode. By setting up maintenance mode, it stick on the same node until maintenance mode OFF)

Shut down sequence – Primary DB & then Secondary DB
Startup sequence – Secondary DB & then Primary DB

Login to Primary DB host & verify the crm_status

#Stop the HADR
db2 stop hadr on db dbname
db2 deactivate db dbname

Login to Secondary DB host and run below commands

#Stop the HADR
db2 stop hadr on db dbname
db2 deactivate db dbname

#Start the HADR on Standby/Secondary host first
db2start hadr on db dbname as standby

#Start the HADR on Primary host
db2start hadr on db dbname as primary

#Verify the HADR status on both hosts
db2pd -d dbname -hadr | grep -i hadr

I will update the list with more commands very soon….

Leave a Reply

Your email address will not be published. Required fields are marked *

3 × two =

Time limit is exhausted. Please reload CAPTCHA.