ATM API Loadtesting with Sybase ASE using LOADRUNNER 12.60

Introduction

          SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known s Sybase DB or Sybase ASE, is a relational model database server product for businesses developed by Sybase Corporation which became part of SAP AG.

Metrics Considered for load testing of ATM APIs

• ·         Transaction per Minute (TPM) e.g : 600 TPM
• ·         Transaction per second (TPS) e.g: 10 TPS

Setting up Database connection ODBC Data Source Administrator

For 32 bit: C:\Windows\system32\ odbcad32

For 34 bit: C:\Windows\SysWOW64\ odbcad32

Add a new Data Source for Sybase ASE

                                

LR Scripting: Web-HTTP/HTML Protocol

Action ()
{
        lr_start_transaction("P_API_XXXXXX_XXXXXX _ExecuteQuery");
     
 //Establishing ODBC driver Connection

//Connection String for Sybase ASE :

//ConnectionString=Dsn={ODBC Reference Name};Uid={username};Pwd={password};

    lr_db_connect("StepName=Connect To DB",
        "ConnectionName=SybaseConnect",
        "ConnectionString=Dsn=DB;Uid=xxxxxx_xxx;Pwd=xxxxx_xxxxx;",
        "ConnectionType=ODBC",
        LAST);
     
    //Execute Query

    lr_db_executeSQLStatement("StepName=ExecuteQuery",
        "ConnectionName=SybaseConnect",
        "SQLStatement=declare @al_channel_id NUMERIC(2)declare @as_xxxxx_id VARCHAR(8)declare @as_machine_name VARCHAR…………………………………………………………

select @as_reference = '{cardNo}#{RefRandom}-XXXXXXXXXXXX-XXXX     @XX-XX BRANCH ATM X' select @adt_transmission_date = getdate() select @as_xxxxxx_amt = '000000000000000010' select @as_xxxxx_amt = '000000000000000000' select @as_xxxxxxxxxx_amt = NULL select  @xx_card = '{cardNo}'select @as_xxxxxx_ref_no = '{RefRandom}' select …………………………………............................... select @os_xxxxxxxx_code = NULL

execute P_API_XXXXXX_XXXXXX @XX_XXXXXXX_id, @ol_XXXX_XXXX out, @os_XXXX_XXXX out",   "DatasetName=Result",
        LAST);
 
    lr_think_time(1);
 
    //Disconnect ODBC driver Connection
    lr_db_disconnect("StepName=Disconnect From DB",
        "ConnectionName=SybaseConnect",
        LAST);
 
     lr_end_transaction("P_API_XXXXXX_XXXXXX _ExecuteQuery", LR_AUTO);
 
    return 0;
}

Output:

Starting iteration 1.

Maximum number of concurrent connections per server: 6         [MsgId: MMSG-26989]

Starting action Action.

Action.c(3): Notify: Transaction " P_API_XXXXXX_XXXXXX _ExecuteQuery " started.

Action.c(6): DB Connection "Connect To DB" started ... Wait ....

Action.c(16): SQL Statement  execution "ExecuteQuery" started

Action.c(16): Warning :No dataset was created.

Action.c(16): ================================================

Action.c(25): DB disconnect "Disconnect From DB" started

Action.c(25): ================================================

Action.c(30): Notify: Transaction " P_API_XXXXXX_XXXXXX _Execute Query " ended with a "Pass" status (Duration: 1.2794 Wasted Time: 0.5606).

Ending action Action.

Ending iteration 1.