SAP Mix

Re: Reg. ABAP dictionary mismatch with the database (Informix)..

Posted By: Rajasekaran, Rajesh
Date: Wednesday, 15 January 2003, at 11:03 a.m.

Hi,

Thanks very much for your response. I will create the indexes using SE11.
I just need to clarify some more on this regard.

The reason i use dbaccess is to utilize PDQ resources during the index
generation to reduce maintenance hrs. When i use dbaccess, I set sometimes
PDQPRIORITY to 80 since "create index" is the only SQL going to run during
that time and hence i can finish the index creation faster on bigger tables
by allocating maximum resources.

1) How do i make the SE11 utilize PDQ resources ?
2) Also, i had memory related issues in the past if i use SAPDBA with PDQ
in the onconfig and switching to different screens within SAPDBA.
I set the PDQ @ the session level. i get the memory related errors as
soon as i execute SAPDBA. I could nt remember the SQL err code. I'm not
sure whether i set the PDQPRIORITY value really high while using
SAPDBA. Is there any recommended PDQPRIORITY value when using
SAPDBA with PDQ.
If someone encountered such situation, it will be great if you guys
pass on your comments/feedback on this regard,

My other ONCONFIG parameters for the PDQ setup is as follows.

MAX_PDQPRIORITY 100
DS_MAX_QUERIES 20
DS_TOTAL_MEMORY 400000 (75% of SHMVIRTSIZE)
DS_MAX_SCANS 1048576

Regards
Rajesh Rajasekaran
Informix Database Administrator
Forest Pharmaceuticals Inc.
314-493-7073 (Work)
314-322-3428 (Cell)
314-514-2457 (Home)

SAP Mix is maintained by Administrator with WebBBS 5.12.