SAP Reports / Programs

RSDB3002 SAP ABAP Report - Summary for System-Wide data







RSDB3002 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 RSDB3002 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 RSDB3002. "Basic submit
SUBMIT RSDB3002 AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB3002 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Summary for System-Wide data
Text Symbol: 186 = Terminate
Text Symbol: 187 = Subsystem allied memory - end of task
Text Symbol: 188 = Rollbacks
Text Symbol: 189 = Subsystem allied memory - end of memory
Text Symbol: 190 = Checkpoints
Text Symbol: 192 = Synchs (single phase commit)
Text Symbol: 193 = Units of recovery indoubt
Text Symbol: 194 = Queued at create thread
Text Symbol: 195 = Units of recovery - indoubts resolved
Text Symbol: 196 = Select
Text Symbol: 197 = Describe
Text Symbol: 198 = Insert
Text Symbol: 199 = Describe table
Text Symbol: 200 = Update
Text Symbol: 201 = Open cursor
Text Symbol: 202 = Delete
Text Symbol: 203 = Close cursor
Text Symbol: 204 = Prepare
Text Symbol: 205 = Fetch
Text Symbol: 206 = Total - Data manipulation language (DML)
Text Symbol: 207 = Data manipulation language (DML)
Text Symbol: 208 = Incremental bind
Text Symbol: 209 = Data control language (DCL)
Text Symbol: 210 = Lock table
Text Symbol: 211 = Connect type 1
Text Symbol: 212 = Grant
Text Symbol: 213 = Connect type 2
Text Symbol: 214 = Revoke
Text Symbol: 215 = Set connection
Text Symbol: 216 = Set current SQLID
Text Symbol: 217 = Release
Text Symbol: 185 = Read only request
Text Symbol: 153 = CT requests/CT not in EDM pool
Text Symbol: 154 = Pages used for CT
Text Symbol: 155 = Requests for PT section
Text Symbol: 156 = Pages used for SKCT
Text Symbol: 157 = PT section not found in EDM pool





Text Symbol: 158 = Pages used for PT
Text Symbol: 159 = PT requests/PT not in EDM pool
Text Symbol: 160 = Pages used for SKPT
Text Symbol: 161 = Requests for DBD section
Text Symbol: 162 = Pages used for DBD
Text Symbol: 164 = Implicit prepares
Text Symbol: 165 = Prepares
Text Symbol: 166 = Avoided prepares
Text Symbol: 167 = Short prepares
Text Symbol: 168 = MAXKEEPD exceeded
Text Symbol: 169 = Full prepares
Text Symbol: 170 = Statement invalidated
Text Symbol: 171 = Deferred close threshold reached
Text Symbol: 172 = Datasets not in use, not close
Text Symbol: 173 = Currently open datasets %
Text Symbol: 174 = Datasets in use
Text Symbol: 175 = Open datasets - higher water mark
Text Symbol: 176 = Datasets closed - threshold reached
Text Symbol: 177 = Open datasets
Text Symbol: 178 = Datasets converted from R/W to R/O
Text Symbol: 179 = Datasets not in use, not close higher water mark
Text Symbol: 180 = Identify
Text Symbol: 181 = Commit phase 1
Text Symbol: 182 = Create thread
Text Symbol: 183 = Commit phase 2
Text Symbol: 184 = Signon
Text Symbol: 218 = Set host variable
Text Symbol: 251 = ALTER commands
Text Symbol: 252 = START TRACE commands
Text Symbol: 256 = General information about buffer pool for subsystem
Text Symbol: 257 = Read operations per buffer pools for subsystem
Text Symbol: 258 = Write operations per buffer pool for subsystem
Text Symbol: 259 = Query parallelism per buffer pool for subsystem
Text Symbol: 260 = Sort/Merge work file operations per buffer pool for subsystem
Text Symbol: 261 = Locking activity (systemwide data) for subsystem
Text Symbol: 262 = Logging activity (systemwide data) for subsystem
Text Symbol: 263 = EDM pool (systemwide data) for subsystem
Text Symbol: 264 = Dynamic statement cache (systemwide data) for subsystem
Text Symbol: 265 = Open/Close activity (systemwide data) for subsystem





Text Symbol: 266 = Subsystem services (systemwide data) for subsystem
Text Symbol: 267 = SQL activity (systemwide data) for subsystem
Text Symbol: 268 = Miscellaneous (systemwide data) for subsystem
Text Symbol: 269 = Current
Text Symbol: 270 = Virtual
Text Symbol: 271 = Successful
Text Symbol: 272 = DFHSM migrated
Text Symbol: 273 = DFHSM recall
Text Symbol: 274 = active
Text Symbol: 275 = full
Text Symbol: 276 = storage
Text Symbol: 277 = dataset
Text Symbol: 278 = datasets
Text Symbol: 279 = timeouts
Text Symbol: 280 = buffers
Text Symbol: 281 = unavailable
Text Symbol: 282 = opens
Text Symbol: 283 = Global hit ratio %
Text Symbol: 284 = Local hit ratio %
Text Symbol: 250 = RID list limit reached
Text Symbol: 219 = Set current rules
Text Symbol: 220 = Set current degree
Text Symbol: 221 = SQL Call
Text Symbol: 222 = Total - Data control language (DCL)
Text Symbol: 223 = Data definition language (DDL)
Text Symbol: 224 = Create table
Text Symbol: 225 = Create index
Text Symbol: 226 = Create tablespace
Text Symbol: 227 = Create database
Text Symbol: 228 = Create storage group
Text Symbol: 229 = Create synonym
Text Symbol: 230 = Create view
Text Symbol: 231 = Create alias
Text Symbol: 232 = Drop table
Text Symbol: 233 = Drop index
Text Symbol: 234 = Drop tablespace
Text Symbol: 235 = Drop database
Text Symbol: 236 = Drop storage group
Text Symbol: 237 = Drop synonym



Text Symbol: 238 = Drop view
Text Symbol: 239 = Drop alias
Text Symbol: 240 = Drop package
Text Symbol: 241 = Alter table
Text Symbol: 242 = Alter index
Text Symbol: 243 = Alter tablespace
Text Symbol: 244 = Alter database
Text Symbol: 245 = Alter storage group
Text Symbol: 246 = Comment on
Text Symbol: 247 = Label on
Text Symbol: 248 = Total - Data definition language (DDL)
Text Symbol: 249 = Parallelism reduction
Text Symbol: 042 = Prefetch
Text Symbol: 043 = disabled
Text Symbol: 044 = pages read
Text Symbol: 045 = no buffers
Text Symbol: 046 = no read engine
Text Symbol: 049 = Page-ins
Text Symbol: 053 = required for
Text Symbol: 055 = read I/O
Text Symbol: 056 = buffer
Text Symbol: 057 = Pages
Text Symbol: 058 = Write engine
Text Symbol: 059 = Deferred write
Text Symbol: 060 = Vertical
Text Symbol: 061 = Data manager
Text Symbol: 062 = updates
Text Symbol: 063 = written
Text Symbol: 064 = writes
Text Symbol: 065 = not available
Text Symbol: 066 = threshold
Text Symbol: 067 = deferred write
Text Symbol: 068 = critical
Text Symbol: 069 = reached
Text Symbol: 070 = thres. reached
Text Symbol: 073 = write I/O
Text Symbol: 074 = Concurrent
Text Symbol: 075 = Parallel
Text Symbol: 076 = Reduced
Text Symbol: 077 = prefetch I/O streams
Text Symbol: 078 = I/O streams reduced
Text Symbol: 079 = query
Text Symbol: 080 = parallel
Text Symbol: 041 = Dynamic
Text Symbol: 001 = Deadlock
Text Symbol: 002 = Pages used for DSC
Text Symbol: 003 = Minimum hit ratio
Text Symbol: 004 = Maximum active pages %
Text Symbol: 005 = Buffer pool shortage
Text Symbol: 006 = Buffer pool
Text Symbol: 007 = Buffers
Text Symbol: 009 = Virtual buffer
Text Symbol: 010 = name
Text Symbol: 011 = allocated
Text Symbol: 013 = pool expansion
Text Symbol: 016 = - virtual bp -
Text Symbol: 018 = and contract.
Text Symbol: 019 = at
Text Symbol: 020 = Last reset time:
Text Symbol: 022 = Data since:
Text Symbol: 023 = Buffer
Text Symbol: 024 = Getpage
Text Symbol: 025 = Synchronous
Text Symbol: 026 = Sequential
Text Symbol: 028 = Asynchronous
Text Symbol: 029 = hit ratio (%)
Text Symbol: 030 = request
Text Symbol: 031 = request seq.
Text Symbol: 032 = reads
Text Symbol: 033 = prefetch
Text Symbol: 035 = total
Text Symbol: 036 = access only
Text Symbol: 037 = seq. access
Text Symbol: 038 = requested
Text Symbol: 040 = List
Text Symbol: 081 = quantity
Text Symbol: 118 = Claim requests
Text Symbol: 119 = Change requests
Text Symbol: 120 = Unsuccessful claim requests
Text Symbol: 121 = Other requests
Text Symbol: 122 = Drain requests
Text Symbol: 123 = Suspension - lock
Text Symbol: 124 = Unsuccessful drain requests
Text Symbol: 126 = Writes-no-wait
Text Symbol: 128 = Write output log calls
Text Symbol: 129 = Log write rate (MB)
Text Symbol: 130 = Total BSDS access requests
Text Symbol: 131 = Reads satisfied - output buffer
Text Symbol: 132 = Unavailable output log buffers
Text Symbol: 133 = Reads satisfied - active log
Text Symbol: 134 = Active log - control intervals created
Text Symbol: 135 = Reads satisfied - archive log
Text Symbol: 136 = Archive log - read allocations
Text Symbol: 137 = Reads delayed - tape volume contention
Text Symbol: 138 = Archive log - write allocations
Text Symbol: 139 = Reads delayed - unavailable resource
Text Symbol: 140 = Archive log - control interval offloaded
Text Symbol: 141 = Look ahead mounts attempted
Text Symbol: 143 = Look ahead mounts successful
Text Symbol: 145 = EDM Pool full
Text Symbol: 146 = DBD section not found in EDM pool
Text Symbol: 147 = Pages in use %
Text Symbol: 148 = DBD requests/DBD not in EDM Pool
Text Symbol: 149 = Requests for CT section
Text Symbol: 150 = Pages in EDM Pool
Text Symbol: 151 = CT section not found in EDM pool
Text Symbol: 152 = Free pages in free chain
Text Symbol: 117 = Query requests
Text Symbol: 082 = high water mark
Text Symbol: 083 = buffer shortage
Text Symbol: 084 = requests
Text Symbol: 085 = query requests
Text Symbol: 086 = reduced to 1/2
Text Symbol: 087 = reduced to 1/4
Text Symbol: 088 = Maximum
Text Symbol: 089 = Requested
Text Symbol: 091 = Merge
Text Symbol: 092 = Degraded
Text Symbol: 093 = Workfile
Text Symbol: 094 = concurrent
Text Symbol: 095 = for all
Text Symbol: 097 = not scheduled
Text Symbol: 098 = marked
Text Symbol: 099 = not
Text Symbol: 100 = passes
Text Symbol: 101 = low
Text Symbol: 102 = req. rejected
Text Symbol: 103 = work files
Text Symbol: 104 = merge passes
Text Symbol: 105 = zero quantity
Text Symbol: 106 = to destruct
Text Symbol: 107 = low buffers
Text Symbol: 109 = Timeouts
Text Symbol: 110 = Suspension - latch
Text Symbol: 112 = Suspension - other
Text Symbol: 113 = Lock requests
Text Symbol: 114 = Lock escalation - shared
Text Symbol: 115 = Unlock requests
Text Symbol: 116 = Lock escalation - exclusive


INCLUDES used within this REPORT RSDB3002

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:

No SAP FUNCTION MODULES are executed within this report code!



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 RSDB3002 or its description.