I am new to the i5 world and am trying to learn how an existing database is structured for a systems integration project. I would like to know the "last used" date for each of our user data tables.
I found on-line that there is a "last used" field in SYSCAT.TABLES.
I have tried using the iSeries Navigator to run a SQL statement. Specifically:
SELECT * FROM SYSCAT.TABLES
However, I get the following error meassage:
Connected to relational database S10542ed on S10a9204 as Bmcdermott - 443634/Quser/Qzdasoinit
> select * from SYSCAT.TABLES
SQL State: 42704
Vendor Code: -204
Message: SQL0204 TABLES in SYSCAT type *FILE not found. Cause . . . . . : TABLES in SYSCAT type *FILE was not found. If the member name is *ALL, the table is not partitioned. If this is an ALTER TABLE statement and the type is *N, a constraint or partition was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, trigger or sequence object was not found. If a function was not found, TABLES is the service program that contains the function. The function will not be found unless the external name and usage name match exactly. Examine the job log for a message that gives more details on which function name is being searched for and the name that did not match. Recovery . . . : Change the name and try the request again. If the object is a node group, ensure that the DB2 Multisystem product is installed on your system and create a nodegroup with the CRTNODGRP CL command. If an external function was not found, be sure that the case of the EXTERNAL NAME on the CREATE FUNCTION statement exactly matches the case of the name exported by the service program.
Processing ended because the highlighted statement did not complete successfully
I am however able to do other queries like "select * from sysibm.tables" and "select * from qsys2.tables" but these catalogs do not have the "last used" field I need.
Any advice? Is it a permissions issue?
PWConner 100000AD5C44 Posts
SystemAdmin 110000D4XK3129 Posts
Re: Unable to query SYSCAT.TABLES2013-02-26T19:07:17ZThis is the accepted answer. This is the accepted answer.
- PWConner 100000AD5C
stiruvee 2700019NCE33 Posts
Re: Unable to query SYSCAT.TABLES2013-02-27T01:36:40ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK