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

DB2

Hi,

we are installing sap with ibm db2 anf hp-ux.

iam very new to db2.pls could you pls help me with the basic commands and structure of db2.

how to start and stop sap with db2 in windows and unix.

structure of db2 also i want.

Rajesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 07:20 AM

    Hello ,

    Don't worry about the Database , just complete the SAP Installation and use BR Tools to admin the DB.

    regards

    Vagesan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 11:29 AM

    Hi Rajesh kumar ,

    I don't think BRtools will work with SAPDB2 . because its a tool for SAPoracle.

    more over in regards of DB2 if you refer the installation guide you will get the commands for starting and stopping the db2.

    Regards

    Bala

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 08:08 PM

    Hi... I am working db2 with aix, and the guide that could help you is here

    DB2 for Linux, UNIX, and Windows Administration

    Its a pdf, (or you can click the following link)

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f03d5fb8-b619-2b10-c383-c6d56872829e

    Database Administration Guide - SAP on IBM DB2 for Unix, Linux and Windows

    To stop sap and restart sap, you could find the different ways in the installation guide.

    in aix, we use

    ./startsap

    ./stopsap

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2008 at 10:50 AM

    hi i think these Commands will help you

    START

    Start the DB2 Administration Server.

    STOP /FORCE

    Stop the DB2 Administration Server. The force option is used to force

    the DB2 Administration Server to stop, regardless of whether or not it

    is in the process of servicing any requests.

    CREATE /USER: user-account /PASSWORD: user-password

    Create the DB2 Administration Server. If a user name and password

    are specified, the DB2 Administration Server will be associated with

    this user account. If the specified values are not valid, the utility

    returns an authentication error. The specified user account must be a

    valid SQL identifier, and must exist in the security database. It is

    recommended that a user account be specified to ensure that all DB2

    Administration Server functions can be acce

    Note: To create a DAS on UNIX systems, use the dascrt command.

    DROP Deletes the DB2 Administration Server.

    Note: To drop a DAS on UNIX you must use the dasdrop command.

    SETID user-account/user-password

    Establishes or modifies the user account associated with the DB2

    Administration Server.

    SETSCHEDID sched-user/sched-password

    Establishes the logon account used by the scheduler to connect to the

    tools catalog database. Only required if the scheduler is enabled and

    the tools catalog database is remote to the DB2 Administration Server.

    For more information about the scheduler, see the Administration

    Guide.

    -? Display help information. When this option is specified, all other

    options are ignored, and only the help information is displayed.

    -q Run the db2admin command in quiet mode. No messages will be

    displayed when the command is run. This option can be combined

    with any of the other command options.

    EXTRACT

    Copies DB2 objects from the TSM server to the current directory on

    the local machine.

    DELETE

    Either deactivates backup objects or deletes log archives on the TSM

    server.

    VERIFY

    Performs consistency checking on the backup copy that is on the

    server.

    Note: This parameter causes the entire backup image to be transferred

    over the network.

    TABLESPACE

    Includes only table space backup images.

    FULL Includes only full database backup images.

    NONINCREMENTAL

    Include only non-incremental backup images.

    INCREMENTAL

    Include only incremental backup images.

    DELTA

    Include only incremental delta backup images.

    LOADCOPY

    Includes only load copy images.

    LOGS Includes only log archive images

    BETWEEN sn1 AND sn2

    Specifies that the logs between log sequence number 1 and log

    sequence number 2 are to be used.

    SHOW INACTIVE

    Includes backup objects that have been deactivated.

    TAKEN AT timestamp

    Specifies a backup image by its time stamp.

    KEEP n

    Deactivates all objects of the specified type except for the most recent

    n by time stamp.

    OLDER THAN timestamp or n days

    Specifies that objects with a time stamp earlier than timestamp or n

    days will be deactivated.

    db2adutl - Work with TSM Archived Images

    10 Command Reference

    DATABASE database_name

    Considers only those objects associated with the specified database

    name.

    DBPARTITIONNUM db-partition-number

    Considers only those objects created by the specified database

    partition number.

    PASSWORD password

    Specifies the TSM client password for this node, if required. If a

    database is specified and the password is not provided, the value

    specified for the tsm_password database configuration parameter is

    passed to TSM; otherwise, no password is used.

    NODENAME node_name

    Considers only those images associated with a specific TSM node

    name.

    WITHOUT PROMPTING

    The user is not prompted for verification before objects are deleted.

    OWNER owner

    Considers only those objects created by the specified owner.

    VERBOSE

    Displays additional file information

    Thanks & Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2008 at 02:12 PM
    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.