Client import issues

[former_member405221]

Dear gurus,

i am getting bellow error when i am importing on quality system

-------------------------------------------------------------------------------------------------------------------

2EETW125 SQL error "1204" during "" access: "[ASE Error SQL1204]ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS."

1 ETP154 MAIN IMPORT

-------------------------------------------------------------------------------------------------------------------

00:0003:00000:00102:2015/11/01 18:19:13.82 server  login: Process with spid 102 could not connect to the ASE which has temporarily run out of locks.

--------------------------------------------------------------------------------------------------------------------

* it is possible client export , import on same client number. my  production client-500 and quality client-500

I increase locks from 2000000 to 3350000 agai imported but i am getting same above  error

so please advice me.

[former_member405221]

Thanks

[victoria_normand]

Let us know how the import is going after those 2 parameters changes

Regards,
Victoria.

[victoria_normand]

Hello Sidhu,

The recommendation when doing the bulk load that implies the import is to configure the "number of locks" to at least 5 millons. Do not hesitate to increase it for the import, you may decrease it after the import.
Also important is to have a latest DBSL version.

Regards,
Victoria.

[former_member405221]

Thanks Victoria,

But when i am trying to  increase locks i am getting bellow  error

**********************************************************

1> sp_configure "number of locks",3500000

2> go

Msg 5861, Level 16, State 2:

Server 'ZFQ', Procedure 'sp_configure', Line 1306:

The current 'max memory' value '1792000', is not sufficient to change the

parameter 'number of locks' to '3500000'. 'max memory' should be greater than

'total logical memory' '1807050' required for the configuration.

(return status = 1)

1>

**********************************************************

so please give advice, development testing stooped so immediately i have complete this system

[DilipVoora]

Hello Sindhu,

Check the configuration parameters 'max memory' and 'total logical memory' at your end. Recommended is 'Max memory should always be greater than the total logical memory'.

Regards,

Dilip Voora

[victoria_normand]

Hi Sindhu,
As mentioned Dilip you'll need to increase the "max memory" configuration parameter which as per the message returned has a low value.
You can use also the "sp_configure" to increase it.
Let's say that the minimum configuration on your target system would be the current configuration on source system. Starting from that and for import purposes you may resize some parameters like number of locks, procedure cache size, etc... You can take as reference the sample on page 22 "Optimizing the ASE Configuration for Data Import" of the "Best Practices" guide attached to SAP Note 1680803 - SYB: SAP Adaptive Server Enterprise - Best Practice for SAP Business Suite and SAP BW

Regards,

Victoria.