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

how to check if the db2 is up ?

hi,

in MS SQL / windows platform we need to bring up the database server before the application server (i think so), but in as/400 i only need to bring up the instance then SAP system will be up which is much more simpler.

in windows / unix platform .. i see 3 parts, OS, Database & Application. in as/400 i only see OS ...

so in as/400 how do i check if the database and the application server are up ? any particular subsystem to check ? or any command to run ?

comment and advice will be highly appreciated.

regards,

kent

as/400 newbie

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 27, 2008 at 03:55 AM

    Hi,

    i5/OS has an inbuilt database DB2 400 ( DB4)

    when you perform IPL and restart the system , database is started automatically.

    to check whether any SAP application server is running or not

    execute following command

    login with SIDOFR user

    wrkactjob sbs(r3_<instance_nr>)

    suppose your R3 system instance number is 00 then command is

    wrkactjob sbs(r3_00)

    after executing command you can find that whether sap process are running under subsystem R3_00 or not.

    regards,

    kaushal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2008 at 10:18 AM

    Hi Kent,

    If you're really as new to this platform as you appear to be it might make sense to contact IBM's education services about the course "SAP Solutions on System i ". You can find a course description at http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&courseCode=AS520

    All the best,

    Sally Power

    Dev. Support for SAP on IBM i Systems

    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.