Getting NAT1205 error

Arun2 · October 17, 2008, 2:26pm

Hello,

This is my first topic. I am getting NAT1205 error(there is no more space in the core)

I am using the below code:

SORT BY EMP-NO EMP-NAME
USING
#ISN

EMP-NO: 9 bytes
EMP-NAME : 50 bytes
Getting error for more than 700 or 800 records if less than 700 or 800 records code is working fine. Please Help !

Steve_Robinson · October 17, 2008, 4:31pm

Check with your DBA for the SORTSZE buffer setting.

steve

Arun2 · October 20, 2008, 6:17pm

Thanks Steve!

If i have the DBA access how can i increase the SORTSZE buffer?

Steve_Robinson · October 20, 2008, 8:57pm

SORTSZE is a NATPARM.

If you have access to change NATPARMs, you are all set.

steve

Kazi1 · October 27, 2008, 10:28am

Arun,
I always encourage my friends to use external sort instead of internal sort. What will happen if yours employees increase to 5,000 or 10,000? You will be having same problem everytime it reaches threshold. Until and unless you are sure your data will not go beyond known count.

Have fun.

Kazi