This section contains information on issues that involve interaction between the schema and its backend database.

---

1.1.9.1  ClearQuest Submit Date is not capturing the time of day

 See this Rational Technote for explanation and solution:  ClearQuest Submit Date is not capturing the time of day

Problem(Abstract)
This technote identifies an issue that can occur in IBM® Rational® ClearQuest® (CQ) where the submit date might not capture the time of day.

Symptom
When using VB Script as the schema language, the submit date times might not be accurate, and might even be on different day, after being converted to GMT.

Cause
The VBScript (VB) function Date does not include a time component and defaults to the back-end database default time. This is only a problem for VB as the Perl default value does record both the date and time using the GetCurrentDate() global script.

---

1.1.9.2  Determining if a user database is a "production" or "test"

The field containing this data is "is_visible" in the master repository table "master_dbs".
0 = test
1 = production

You could use an SQL query to get that info:
SELECT name, is_visible FROM DB2ADMIN.MASTER_DBS;

where "name" is your user database display name.

----