Documentum Connection Utilities, Part II

Another Documentum-provided connection utility, also found in the %DM_HOME%\bin directory, is dmdbtest. dmdbtest tests the database connection that the Content Server uses. Running dmdbtest -h displays all of its use cases and parameters.

Usage 1: dmdbtest -docbase_name -init_file

  • -docbase_name :   name of Docbase
  • -init_file:   name of server.ini file (including path) which contains the server startup parameters

Example:

C:\Documentum\product\6.5\bin>dmdbtest -docbase_name repo1 -init_file C:\Documentum\dba\config\repo1\server.ini

Database successfully opened.
Test table successfully created.
Test view successfully created.
Test index successfully created.
Insert into table successfully done.
Index successfully dropped.
View successfully dropped.
Database case sensitivity test successfully past.
Table successfully dropped.

Usage 2: dmdbtest [-v | -V | -Vd | -Vs]

  • -v:  To display the dmdbtest version string including OS platform and RDBMS.
  • -V:  To display the dmdbtest version string including OS platform and RDBMS.
  • -Vd:  To display the RDBMS that the dmdbtest is for.
  • -Vs:  To display the dmdbtest version string including OS platform.

Example:

C:\Documentum\product\6.5\bin>dmdbtest -v

Documentum Release Version: 6.5.0.117 SP1 Win32.SQLServer

C:\Documentum\product\6.5\bin>dmdbtest -V

6.5.0.117 SP1 Win32.SQLServer

C:\Documentum\product\6.5\bin>dmdbtest -Vd

SQLServer

C:\Documentum\product\6.5\bin>dmdbtest -Vs

6.5.0.117 SP1 Win32

Usage 3: dmdbtest -D -S -U -P [-etrace] [-Mconnect] [-E] [-Mtesttemp] [-Mdberronly] [-Mgetdbversion] [-Mverifydbversion ] [-Mcheckfeature ]

  • database name:  name of the database to connect to.
  • server connect: the name of the ODBC connection to use to connect to the database.
  • UserName:  user name to login to the database with.
  • Password:  password for the UserName.

Options:

  • -etrace:  print out connection parameters
  • -Mconnect:  specifies that only connectivity is to be tested
  • -Mtesttemp: specifies that only temp tablespace existence is to be tested
  • -Mdberronly:  specifies that only database errors are to be printed
  • -Mgetdbversion: to print the database instance version.
  • -Mverifydbversion : to verify the required database instance version.
  • -Mcheckfeature : to check whether the feature is enabled on database.

Example:

C:\Documentum\product\6.5\bin>dmdbtest -DDM_repo1_docbase -SSQLServer -Usa -Psa

Database successfully opened.
Test table successfully created.
Test view successfully created.
Test index successfully created.
Insert into table successfully done.
Index successfully dropped.
View successfully dropped.
Database case sensitivity test successfully past.
Table successfully dropped.

C:\Documentum\product\6.5\bin>dmdbtest -DDM_repo1_docbase -SSQLServer -Usa -Psa -Mgetdbversion

Database successfully opened.
09.00.3080

C:\Documentum\product\6.5\bin>dmdbtest -DDM_repo1_docbase -SSQLServer -Usa -Psa -Mverifydbversion 10.2.0.3

Database successfully opened.
DB Version test fails, minimum required RDBMS version is: 10.2.0.3, your RDBMS
version is: 09.00.3080

Examples of using the -Mgetdbversion and -Mverifydbversion and a list of the supported can be found here: https://solutions.emc.com/emcsolutionview.asp?id=esg95736

The mystery (at least to me) is what can be passed as a feature name in the -Mcheckfeature option?  Anyone know?

Advertisements

About Scott
I have been implementing Documentum solutions since 1997. In 2005, I published a book about developing Documentum solutions for the Documentum Desktop Client (ISBN 0595339689). In 2010, I began this blog as a record of interesting and (hopefully) helpful bits of information related to Documentum, and as a creative outlet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: