%META:TOPICPARENT{name="TroubleshootingUDAGatherEvidence"}%
= Getting a Database Agent Version String (All Platforms) =

All our database agents return version strings, which identify the agent's build date and other details, including the platform for which the agent was compiled. 

To retrieve a version string --

# Open a CMD/DOS session on Windows, or a Unix terminal session.
# Navigate to the OpenLink server components installation directory (e.g., {{{C:\Program Files\OpenLink\}}}, {{{C:\Program Files\OpenLink Software\UDA\}}}, {{{/opt/openlink/}}}).
# If on a Unix-like OS, set the <nop>OpenLink environment by running the appropriate script for your shell --
| *shell* | *command* |
| <code>sh, bash, zsh</code> and related | <code><nowiki>. ./openlink.sh</nowiki></code> |
| <code>ksh</code> and related | <code><nowiki>source ./openlink.sh</nowiki></code> |
| <code>csh, tcsh</code> and related | <code><nowiki>source ./openlink.csh</nowiki></code> |
# {{{cd bin}}}
# Identify your database agent. Agent names end in {{{_sv}}} or {{{_mv}}}.  They begin with prefixes which typically suggest the database to which they connect. For example:
{{{
inf73_mv            - Informix 7.3 Database Agent
ora80_mv.exe        - Oracle 8.0.x Database Agent
pro83b_sv           - Progress 83B Database Agent
}}}
# Run the version string command. For example:
{{{
 <database agent name> -?         - Basic syntax
 ./inf73_mv -?                    - Unix-based Informix 7.3 agent string
 ora80_mv.exe -?                  - Windows-based Oracle 8.0.x agent string
}}}
# Copy the first several lines for your evidence report.
{{{
bash-2.05a$ ./sql_mv -?
SQL Server Database Agent (multi threaded)
Version 1.54 as of Mon Apr 16 2012 (Release 6.2 cvsid 00094).
Compiled for AIX 2 (powerpc-ibm-aix5.2.0.0-32)
Copyright (C) OpenLink Software.

Usage:
}}}