cancel
Showing results for 
Search instead for 
Did you mean: 

DB2

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos
former_member206441
Contributor
0 Kudos

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

Former Member
0 Kudos

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)

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

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello ,

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

regards

Vagesan