How to query an instance in the database from command editor
Posted on 2013-01-22
I have created a new instance "DB2INST3" to an existing database, aliased as "SAMPLE" ,from the DB2 configuration assistant.
Now, i can connect to SAMPLE and see the 5 tables from AIX.
But when i run "select * from syscat.columns" from DB2 command editor, i see all other tables from the database, but none of the 5 tables (from the Sampe database) are visible.
Is there a special way of querying an isntance of a database?