Home / server / Questions / 692139
In Process
Justin Dearing
Asked: 2015-05-15 11:28:33 +0800 CST

db2 -S is hanging on IBMi

  • 772

I can ssh into my IBMi and start qsh. If I type db2 with no parameters I get the standard help message:

db2
  USAGE: CMD [-v] [-S] [-s] [-t | -T<char> | -d] [-r RDBNAME [-u USERNAME -p PASSWORD] ] <"SQLSTMT" | -i | -f FILENAME DEFAULT_LIB>

However, if I run a query like db2 -S "SELECT name FROM INFORMATON_SCHEMA.tables" Nothing returns. It was working fine for the past couple of weeks. I can SELECT and UPDATE from php code just fine. However, I can't use the db2 commandline tool from qsh. What Should I do to troubleshoot?

db2

0 Answers