Constructing Command Line to View and Delete Merge Sessions

You can view active merge session details and delete the specified merge session along with the written back version of objects.

This section discusses how to:

View merge sessions.
Delete merge sessions.

You can list or view merge sessions of a configured PUM source database or a specific database environment.

View Merge Sessions of Configured PUM Source

The GETMRGSESSN action lets you to list or view the merge sessions of all the configured PUM source databases.

Command line format:

-MODE UM -ACTION GETMRGSESSN

Example command line:

Changeassistant.bat -MODE UM -ACTION GETMRGSESSN

Parameter

Description

-MODE

Change Assistant mode (Required)

-ACTION

Change Assistant action (Required)

GETMRGSESSN = Get Merge Session

View Merge Sessions of Specified Database Environment

When you provide database name along with the GETMRGSESSN action in the command line, Change Assistant lists all the merge sessions of the specified database.

Command line format:

MODE UM -ACTION GETMRGSESSN –ENV <DATABASE_NAME>

Example command line:

Changeassistant.bat -MODE UM -ACTION GETMRGSESSN -ENV H92143SR

Parameter

Description

-MODE

Change Assistant mode (Required)

-ACTION

Change Assistant action (Required)

GETMRGSESSN = Get Merge Session

-ENV

Specify the database.

You can delete merge sessions from configured PUM source and any specific database.

Delete Merge Session from Configured PUM Source

The DELMRGSESSN action lets you to delete merge sessions of the configured PUM source database.

Command line format:

-MODE UM -ACTION DELMRGSESSN -SESSION <SESSION_NAME>

Example command line:

Changeassistant.bat -MODE UM -ACTION DELMRGSESSN -SESSION MRGOBJSQL

Change Assistant queries with the session name and deletes the merge session.

Parameter

Description

-MODE

Change Assistant mode (Required)

-ACTION

Change Assistant action (Required)

DELMRGSESSN = Delete Merge Session

-SESSION

Merge session name.

Delete Merge Session from Specified Environment

You can delete merge session from a specific database. When you provide session name and database name, Change Assistant queries for the session in the specified database environment and deletes the session.

Command line format:

-MODE UM -ACTION DELMRGSESSN -ENV <DATABASE_NAME> -SESSION <SESSION_NAME>

Example command line:

Changeassistant.bat -MODE UM -ACTION DELMRGSESSN -ENV H92143SR -SESSION MRGOBJSQL

Parameter	Description
-MODE	Change Assistant mode (Required) UM
-ACTION	Change Assistant action (Required) DELMRGSESSN = Delete Merge Session
-ENV	Specify the database.
-SESSION	Merge session name.

Note that DELMRGSESSN and GETMRGSESSN throws error code 1, if:

no PUM source is configured.
the specified merge session does not exists.
the specified database is a lower version than PeopleTools 8.60.