Skip to Content
author's profile photo Former Member
Former Member

CJ20n tx is not saved & its taking long time(eventhough tx is not complete)

Dear all,

SAP ECC 6.0 & DB6 & WIN2003 for testing server

my power user getting issue...

CJ20n transaction is not saved and and the transaction taking long time (even though transaction not complted),

when i check SM21 and Eventviewer log .... i am not getting any errors ...

note:

previously i got Dump (table space completely 100 % full and time out error ) so i had increased response time (1800) and i had increased Application memory SQL Statement Heap Size (Technical name - STMTHEAP)

and one more i had done REORGCHK for all Tables also ....

pls suggest me to resolve that issue....

after that only i got that issue....

regards

sathish

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 14, 2009 at 04:38 PM

    Hello Sathish,

    You mentioned that you received a tablespace full error. Did you increase the tablespace size? Are you using auto-resize or automatic storage for that tablespace. If there sufficient space available on the disk containing the tablespace containers? If not you may need to increase this at the OS level. Did you check the db2diag.log for associated entries during the timeframe when you got the tablespace full error?

    Regards,

    Adam Wilson

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Adam Wilson,

      we r using Auto storage for that tabel space .... i had increased the configuration of the Database Heap memory 25000 4KB in DB02 (Database Shared Memory).... could u suggest me to resolve the issue... and can u provideme the Docu to increase the Table Space (OS level)

      note:

      when i use DB02 transaction......... In History it shows

      Table Spaces

      last anayisis blank

      Total Number 0

      Total Size 0 KB

      Free Space 0KB

      Used Space 100%

      Minimum Free Space in Table Space 0KB

      Maximum Free Space in Table Space 0.0%

      Database Partitions

      Total Numbers 0

      regards

      sathish

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2009 at 10:26 AM

    Dear Adam Wilson,

    i had increased the profile parameter rdisp/max_wprun_time=2400s and any other parameter i need to change....

    regards

    sathish.N

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.