cancel
Showing results for 
Search instead for 
Did you mean: 

db13 Transaction taking time

Former Member
0 Kudos

Hi,

This is regarding Transaction DB13(DBA planning calender:Maintain)

which is taking long time to initialize i mean to display the DBA

Planning calender screen. This is happening only with DB13 other

transactions are executing very fine.Iam working on sap4.6C, windows

2003 server and oracle 9.2. I would appreciate if you can guide me in

resolving this issue.

Waiting for your reply.

Regards

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

Hi,

thanks for ur replies...

But can i ask you something ....

Why this is happening only with my Development server because i have the same parameters set for my production server( Every thing is same in my PRD & DEV servers) as well am not facing any problem over ther for DB13.

Regards

Former Member
0 Kudos

Hi,

Yes i have posted the message to marketplace and this was there reply.

As first step, please make sure the database parameters are set as

per note 124361. If you confirm that these are set correctly, please

provide a html output from TX ST04 -> detailed analysis -> parameter

changes -> active values.

Secondly, create new statistics for table TBTCO using transaction DB20.

I did as they said.. but the database parameters thing i dont know that much.

You know what there is no database admin so i only need to resolve this issue.

Hope you can help me out in resolving this issue....

Regards

kishore_soma
Active Participant
0 Kudos

Hi ,

if you have said SAP haave said to do then they will revert back to do some changes in the database parameter file initora.<sid> which will be existing in the oracle folder go in to that and change the parameters and restart the DI and CI

Reagards,

Kishore

Former Member
0 Kudos

Hi,

When iam executing DB13OLD it is saying transaction does not exist.

Regards

former_member204746
Active Contributor
0 Kudos

DB13OLD is a netweaver 2004s with support packs level 12.

this is not your system version.

I would open a SAP message at http://service.sap.com/message

when you fix the problem, tell us what you did because you are not the only one complaining about this issue.

Former Member
0 Kudos

Hi,

Iam working on SAP 4.6C , windows2003 server and oracle-9.2 versions.

Regards

Former Member
0 Kudos

Hi,

Thanks for replying.

I have performed the brconnect command you have mentioned but still its the same. Transaction DB13 is still taking time to display the calender screen.

Please help me out in this regard as this issue iam facing since long time.

Regards

former_member204746
Active Contributor
0 Kudos

you did not tell us which SAP version/product you are using.

have you tried tcode DB13OLD ?

Former Member
0 Kudos

Hi there thanks for your reply..

When am executing Brconnect for SDBA* it is saying SDBA doest not exist .

Regards

former_member204746
Active Contributor
0 Kudos

ok then, try:

brconnect -c -u / -f stats -t SDBAD,SDBAH,SDBAP,SDBAC -f collect

Former Member
0 Kudos

Hi,

Thanks for your kind reply

I have run both commands but still its the same.

Regards

former_member204746
Active Contributor
0 Kudos

my last command was not updataing the proper table... sorry for that.

try this one instead:

brconnect -c -u / -f stats -t SDBA* -f collect

former_member204746
Active Contributor
0 Kudos

in DB13, run job CLEANUPLOGS

or at OS level:

brconnect -c -u / -f cleanup

then, update stats:

brconnect -c -u / -f stats -t TBTCO -f collect