Problem scheduling Checkdb through DB13

[Former Member]

Hi,

I am trying to schedule the check db job using DB13.But when i schedule the job it is getting cancelled.But when i execute the same using SAPDBA is it getting executed successfully.I am posting the error log for the checkdb job scheduled using DB13.Our SAP version is 4.0 B. Please provide your suggestions.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000109, user name QUSBAPO)

Execute log. command SAPDBA on host orsap001

__Parameters: -u / -check

SAPDBA: Wrong option.

Usage:

sapdba [ -u <userid>[/<password>]

-P <userid>/<coded_password> /* (only for batch start) */

]

[ -p <profile> ]

[ -h[elp] ]

[ -r <dir> /* restart in batch */

-export <tsp_list> <table>

[-dest <path>

<tape_device> [-tape_size <size_in_M>] ]

-alter_user <uid>/<pwd>

-init_sap_connect

-sapsid <SID1>[,<SID2>,...]

-version

-verbose

-V -VERSION [all]

]

sapdba without -u option would connect by

(1) <name>/<password> in <orapwd_file>, if spec. in init<SID>.dba or

(2) system/manager, if default password is set or

(3) prompting for name and password.

External program terminated with exit code 2

SAPDBA returned error status E

Job finished

Thanks and Regards

Balaji.P

[fidel_vales]

Hi,

The error is because you use a "too" new version of SAPDBA.

Most of the SAPDBA functions have been moved to BR*

Your version is 4.0B (very old one, out of Mainstream Maintenance and perhaps even "normal" maintenance), so you have to "migrate" the SAP functionality from SAPDBA to BR*

I think the note 403704 contains the instructions to do so.

[vince_laurent]

What OS? Database?

The DB13 doesn't use the same environment as the user for the SYSDBA.

Depending on the version AND type of database there might be a command or 2 you might have overlooked.

More information would help,

Vince