Problems after patching MAXDB

[former_member233435]

Hello,

I was using 7.8.02.26 on SolMan 7.1, after patching MaxDB to patch 35 (which went without erros) I can't schedule CheckDB or Update Optimizer Statistics jobs, example:

=========

Action log:

17.07.2013	10:40:54	Job started
17.07.2013	10:40:56	Step 001 started (program RSDBAJOB, variant &0000000000003, user ID SOLMAN_ADMIN)
17.07.2013	10:40:59	Execute logical command DBMCLI On host isp
17.07.2013	10:40:59	Parameters:-d ISP -n isp -tpi ISP -tpp no_longer_used -tpc ISP db_execute check data
17.07.2013	10:41:08	ERR
17.07.2013	10:41:08	-24988,ERR_SQL: SQL error
17.07.2013	10:41:08	-104,DBM command impossible at this time
17.07.2013	10:41:08	Could not enter critical state 'CheckData'.
17.07.2013	10:41:08	External program terminated with exit code 1
17.07.2013	10:41:08	DBMCLI returned error status E
17.07.2013	10:41:12	Job finished

Program log:

*** DBA Action starts:

Timestamp: 20130717104107   Function: cdb   Object: DATABASE

*** VERIFY command:

check data

*** VERIFY result:

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

Could not enter critical state 'CheckData'.

*** DBA Action ends:

Timestamp: 20130717104108   State:    Failure

=========

If I try as SIDadm to run: x_cons ISP sh ac 1

I get: Can't exec program </sapdb/ISP/db/pgm/cons> : Permission denied

Any ideas on what happened and how to correct this?

Thx

[yashwanthkumar_kethineed]

Hello Sasa,

It could be possible that the CHECK DATA is already running

Check the currently active tasks in the database:

From DB50 - Go to -> Kernel Threads -> Task Manager

See if the Task type ChkData is already running.

From DBMCLI -> Connect to database as control user

run "show active"

If a ChkData task is already active on the database, you need to wait until it is finished to start another one.

Regards,Yashwanth