on 12-16-2008 8:37 AM
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
Hi,
Pls see the link.
http://help.sap.com/saphelp_erp2005vp/helpdata/en/ff/ff6c2b409f11d1896b0000e8322d00/frameset.htm
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi... I am working db2 with aix, and the guide that could help you is here
Its a pdf, (or you can click the following link)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello ,
Don't worry about the Database , just complete the SAP Installation and use BR Tools to admin the DB.
regards
Vagesan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.