Wednesday, October 2, 2013

Max no of records to see in PSA maintenance screen

Recently I needed to check large data set in PSA. I wanted to list all data records that arrived to PSA from source system. Source was getting me over 3 millions of records. On PSA maintenance selection screen there is a possibility to specify no of records that is supposed to be displayed. Even I had approx. 3 millions of records I was not able to get them all into PSA’s output screen.

I tried to debug the functionality which displays the data. I found out that within the code there is limit on no of records to be displayed:
MODULE user_command_0500 INPUT.
if g_record_max >= 2147483647.
The limit is 2,147,483,647. Even if I would exceed the number on the screen by entering higher no I would be getting following error:

To be honest I’m not sure why I was not able to pull out all the records. Finally I managed it differently as I went directly to corresponding PSA transparent table via SE11. So at the end it was not an issue; but I’m curious to know why I cannot see more (all) the records.
PS: no 2,147,483,647 is prime number and is one of only four known double Mersenne primes. It has strong significance in computing because it is the maximum value for a 32-bit signed integer (int).

My other posts on PSA topic:

No comments: