agent_stack_sz (system copy)

[Former Member]

Hi,

We are in process of system copy (db dependent) of production (ABAP only system). As per PAM db2 v9.7 is compatible with CRM 5.0 SR2. We are using software for system copy using which we had installed CRM 5.0 sr2 4 yrs back.

Now at the time of installation under system copy process, we have stuck at a point (phase: update database configuration manager) where db parameter value (agent_stack_sz) in keydb.xml as per db2 8 is 64 (default) but according to db29.7 it should be minimum 256. We are manually trying to change the value in keydb.xml (and other xml and sql files) to 256 but when retrying the error system is not considering the change and revering it back to 64, resulting in error.

Kindly help how to proceed. Is there any way to change the value?

Regards,

gaurav

[Former Member · Accepted solution]

Hello Gaurav,

Change the DB configuration first using

db2 UPDATE DBM CFG USING <parameter> <value>

for parameter agent_stack_sz.

You can refer to note : 1329179

Hope it helps,

Regards,

Amit Barnawal

[Former Member · Accepted solution]

Hi Amit,

Thanks. But already tried this (manually from os level) but installation is not accepting this and throwing error.

Rgds,

gaurav

[Former Member · Accepted solution]

Hello Gaurav,

Then you can do system copy using db independent,and after getting it done, I guess you can get db upgrade with the help of DB Administrator.

In the mean time lets see if some expert will suggest some better solution.

Regards,

Amit Barnawal

[Former Member · Accepted solution]

Hi Amit,

I am more than half way through and i feel something minor is missing. After changing value in keydb.xml as per SAP note 950506 (text as written as under), i am retrying the installation. Error is the same. Value which i had changed before retry is the same but the value in file (update_dbm_cfg.sql) in still 64 not the updated one which is 1024. Thats why error is encountered.

I doubt, i need to change CDATA[ERROR] to CDATA[OK] somewhere or not.

Rgds,

gaurav

-

---

During the installation phase, SAPinst might abort during the 'UpdateCfg' step that updates the database manager configuration:

Error:

MDB-01999 Error occured, first error is: <SQL5130N The value specified for the configuration parameter "agent_stack_sz" is not in the valid range of "256" to "32768".>

-

---

Reason:

The parameter settings are customized for DB2 V9. 1 and the minimum value of 'AGENT_STACK_SZ' has changed with DB2 V9.5.

-

---

Solution:

Edit the keydb.xml file and change the value of 'AGENT_STACK_SZ' to 1024.

The original part looks as follows:

<fld name="Parameter">

<strval><![CDATA[AGENT_STACK_SZ]]>

</strval>

</fld>

<fld name="Value">

<strval><![CDATA[64]]>

</strval>

</fld>

Change this to the following:

<fld name="Parameter">

<strval><![CDATA[AGENT_STACK_SZ]]>

</strval>

</fld>

<fld name="Value">

<strval><![CDATA[1024]]>

</strval>

</fld>

[Former Member · Accepted solution]

Hello Gaurav,

Have you restarted your DB after changing the dbm configuration manually??

and try to restart the process again from beginning after doing that.

Lets see..

Regards,

Amit Barnawal

[Former Member · Accepted solution]

Yes Amit, this worked. This time i changed the values in keydb and sql file. Aborted and then restarted the installation with old (changed) files. Now i am on restore database step.

Thanks.

Rgds,

- gaurav