Skip to Content

Looking for a DB17 equivalent on a Java Stack system

Ok, sort of new-to-me question here. When monitoring systems with ABAP stacks if I have to add/change an oracle paramter for monitoring I go in to DB17. On a Java only system there is no 'DB17' ... or is there? Where is the stuff hidden in NWA?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 10, 2013 at 09:20 PM

    Hello

    DB17 is not really related to monitoring, it's got more to do with daily checks.

    It is a maintenance view for table DBCHECKORA (Configuration of Database Check).

    This table allows to set option / thresholds for the controls performed by Br*Tools checks (Brconnect -u / -c -f check).

    I do not think there is such an maintenance screen in NWA.

    If you have installed your Java stack with MCOD (both stack share the same database, using different schema), the Br*Tools of the ABAP stack will do the job.

    I do not have a Java stack running on a standalone DB, but as far as BR*Tools are installed with the Java stack it is possible to run the Br*Tools check and maintain table DBCHECKORA directly with SQL command.

    Take a look at the attachment of note 403704 - BRCONNECT - Enhanced functions for Oracle DBA

    it contains scripts to rebuild the content of table DBCHECKORA

    [...]

    DELETE FROM DBCHECKORA;

    INSERT INTO DBCHECKORA (TYPE, PARAM, OBJECT, ACTIVE, SEVERITY, CHKOP, CHKVAL, UNIT, CHKREP, REPUNIT, MODFLAG, MODDATE, MODUSER, REACTION, CORRTYPE, CORRNAME, CHKDESC) VALUES ('DBA', 'ARCHIVER_STUCK', ' ', 'Y', 'W', '>', '90', 'P', ' ', ' ', ' ', ' ', ' ', ' ', 'D', 'Save and delete archive log files', 'Out of space in archive directory');

    INSERT INTO DBCHECKORA (TYPE, PARAM, OBJECT, ACTIVE, SEVERITY, CHKOP, CHKVAL, UNIT, CHKREP, REPUNIT, MODFLAG, MODDATE, MODUSER, REACTION, CORRTYPE, CORRNAME, CHKDESC) VALUES ('DBA', 'CONTROL_FILE_MIRROR', ' ', 'Y', 'E', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', 'D', 'Extend CONTROL_FILES parameter', 'Control file not mirrored');

    [...]

    Hope this helps...

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 20, 2013 at 06:43 PM

    What NW release did you go with? As this will dictate various aspects of the NWA.

    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.