SAP Reports / Programs

comments icon Comments

RSMSQSNP SAP ABAP Report - Get database snapshot and store it in MSQSNP (called via RSCOLL00)







RSMSQSNP is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter RSMSQSNP into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT RSMSQSNP. "Basic submit
SUBMIT RSMSQSNP AND RETURN. "Return to original report after report execution complete
SUBMIT RSMSQSNP VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Get database snapshot and store it in MSQSNP (called via RSCOLL00)


INCLUDES used within this REPORT RSMSQSNP

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:





No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

MSS_DB_AND_SCHEMA
  call function 'MSS_DB_AND_SCHEMA'
     changing
        schema_name = r3schema
        db_name = dummydb
     exceptions
       others = 0.

SMSS_GET_DBO_CONNECTION
  CALL FUNCTION 'SMSS_GET_DBO_CONNECTION'
    IMPORTING
      CON_NAME = dbocon.

GET_STATICSERVER_MSS
  call function 'GET_STATICSERVER_MSS'
       exporting
            con_name   = dbocon
            schema     = r3schema
       tables
            serverdata = staticserver
       exceptions
            others     = 0.

MSS_GET_DB_SIZE_INFO
  call function 'MSS_GET_DB_SIZE_INFO'
       importing
            db_sizeinfo          = dbdata.

MSS_GET_DB_SIZE_DETAILS
  call function 'MSS_GET_DB_SIZE_DETAILS'
    importing
      db_sizedetails             = db_data.

GET_SQLPERFMEMORY_MSS
  call function 'GET_SQLPERFMEMORY_MSS'
    tables
      memusage             = mem_usage
     exceptions
       db_error             = 1
       internal_error       = 2
       others               = 3.

GET_SQLPERFACCESS_MSS
  call function 'GET_SQLPERFACCESS_MSS'
    importing
      accessmths       = accessmths.

GET_SQLPERFCACHE_MSS
  call function 'GET_SQLPERFCACHE_MSS'
    tables
      cacheinfo            = cacheinfo
    exceptions
      db_error             = 1
      internal_error       = 2
      others               = 3.

GET_DYNAMICSERVER_MSQ
  call function 'GET_DYNAMICSERVER_MSQ'
       tables
            serverdata = dynamicserver
       exceptions
            others     = 0.

GET_DBDATA_MSS
  call function 'GET_DBDATA_MSS'
    tables
      dbdata                     = r3user.


Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.







The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name RSMSQSNP or its description.


   
 

RSMSQSNP - Get database snapshot and store it in MSQSNP (called via RSCOLL00)
RSMSQSNP - Get database snapshot and store it in MSQSNP (called via RSCOLL00)
RSMSQPAH - Record MS SQL Server sp_configure Parameter History in PAHI
RSMSQPAH - Record MS SQL Server sp_configure Parameter History in PAHI
RSMSQI17 - documentation and ABAP source code
RSMSG_MH_TEST - Test program for SMSG message handler