db2 Commands

The BIND command creates an application plan which is used to access db2 data during the execution of a program.

The DCLGEN command allows you to create host language declarations of rows as defined in an actual table. The command produces the complete SQL DECLARE statement for the table or view. The resultant file can be used with a COBOL copy or PL/1 include statement (depending on the language selected).

The -DISPLAY DATABASE command displays status information for one or more db2 databases .

The -DISPLAY THREAD command displays information about all active and in-doubt db2 connections.

The -DISPLAY TRACE command displays active traces.

The DSN command executes DSN commands and passes the commands to db2.

The DSNC command issues db2 commands from CICS.

The FREE command deletes an application plan from db2.

The REBIND command rebinds an existing application plan.

The RUN command runs an application program.

The SPUFI command is a TSO facility that allows dynamic use of SQL statements. It is useful for testing or debugging SQL statements before including them in a program as well as being useful for ad-hoc queries.

The -START DATABASE command will restart a stopped db2 database.

The -START DB2 command initializes the db2 system and starts all of the db2 databases.

The -START TRACE command starts tracing db2 accesses.

The -STOP DATABASE command closes specified databases making them unavailable for access.

The -STOP DB2 command shuts down the db2 sub-system.

The -STOP TRACE command stops the display of active traces.

The -TERM UTIL command terminates a job and releases all of the resources that were assigned to that job.


This article written by Stephen Chapman, Felgall Pty Ltd.

go to top

FaceBook Follow
Twitter Follow