Timeline for DB2 selects break after migrating from RHEL5, V9.7 to RHEL6, V10.5
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 11, 2014 at 13:10 | history | edited | Guntram Blohm | CC BY-SA 3.0 |
added 945 characters in body
|
| Feb 28, 2014 at 20:16 | vote | accept | Guntram Blohm | ||
| Feb 28, 2014 at 19:02 | answer | added | mustaccio | timeline score: 1 | |
| Feb 28, 2014 at 17:30 | comment | added | mustaccio | The database server version shows in the connect command feedback: DB2 z/OS 10.1.5. There is no patch to be applied; you need to bind appropriate packages in the database for clients to work. This is a standard procedure when upgrading clients, so your DBA should not have any problem with that. Alternatively, he (or she) will tell you what client version you must use (for which the packages would already be bound). | |
| Feb 28, 2014 at 17:02 | history | edited | Guntram Blohm | CC BY-SA 3.0 |
added 1996 characters in body
|
| Feb 28, 2014 at 15:12 | comment | added | mustaccio |
So 1) your database is not on AIX and 2) you don't get a socket error when you "try to select something". Try binding the CLI packages (you need to be connected): db2 bind db2clipk.bnd blocking all sqlerror continue grant public. The bind file is in the bnd directory under your DB2 client installation. If you don't have enough permissions to bind packages your DBA will have to do it for you.
|
|
| Feb 28, 2014 at 13:38 | history | edited | Guntram Blohm | CC BY-SA 3.0 |
added 983 characters in body
|
| Feb 28, 2014 at 13:17 | comment | added | mustaccio |
Please show the output of db2 connect to DB2I21 (you'll need to enter your user ID and password) and db2 "select * from sysibm.sysdummy1" -- copy and paste exactly the commands and the terminal output.
|
|
| Feb 28, 2014 at 11:55 | history | migrated | from superuser.com (revisions) | ||
| Feb 28, 2014 at 10:37 | history | asked | Guntram Blohm | CC BY-SA 3.0 |