Access Xmeta

altruist · Post by **altruist** » Thu Feb 09, 2012 11:24 pm

Hi,

I want to query a xmeta table to get user info. Can you please let me know how to access xmeta.

I was able to do the same in Unix Server through Shell Script. But not sure how to access from Windows Server.

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2012 1:51 am

What shell script? It should also work on Windows.

altruist · Post by **altruist** » Fri Feb 10, 2012 7:31 am

Code: Select all

#!/bin/ksh

db2 << EOF > /home/db2inst1/log

connect to xmeta

select distinct tabschema || ','|| tabname from syscat.tables

EOF

This is part of test code [test.sh]. Where can I place this code in Windows Server and how can I call it ?

qt_ky · Post by **qt_ky** » Fri Feb 10, 2012 10:56 am

Try creating a Windows batch file that calls the DB2 command line utility. The DB2 commands syntax (your SQL) should be able to remain as is.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2012 3:29 pm

You've got MKS Toolkit (UNIX emulator) on Windows. So you can run Korn shell scripts.

qt_ky · Post by **qt_ky** » Fri Feb 10, 2012 3:38 pm

With the toolkit route, check your 3 paths in the script you've shown.

Is /bin/ksh correct?

Is "db2" correct? It should work if "db2" is in your PATH.

Is /home/db2inst1/log correct on Windows?

ray.wurlod · Post by **ray.wurlod** » Fri Feb 10, 2012 7:08 pm

So long as /home is defined on the currently logged drive (the same drive on which Information Server is installed) and db2inst1 is defined in there, then you should be OK.

For example, if IIS is installed on E: drive, then E:\tmp is treated as /tmp.