Kbase P101403: System wide QSYS2/SYSTABLES view is being accessed when pulling the schema in ODBC DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2005 |
|
Status: Unverified
FACT(s) (Environment):
IBM AS/400 (RISC)
ODBC DataServer
OpenEdge 10.x
SYMPTOM(s):
System wide QSYS2/SYSTABLES view is being accessed when pulling the schema in ODBC DataServer
Data Direct DB2 Wire Protocol driver.
The Collection Name is specified in the 'General' tab of the ODBC Data Source configuration.
It is possible to observe that the ddm/drda server job (QRWTSRVR) servicing the connection opens a view SYSTABLES located in QSYS2 library, which is a system wide SQL Catalog view.
CAUSE:
This is expected behavior. The whole DB2/400 is treated as the single database and the system wide SQL Catalog is being scanned when sending SQLTables calls without additional parameters.
FIX:
None at this time