I am trying to run a sql script on a remote database using DB2 10.1 on AIX 6.1. I have granted my admin user (Adm101) on the database server SECADM. But when i run my script on the remote server with the db2 client (Client101) I get:
SQL0552N "Client101" does not have the privilege to perform operation "CREATE TABLE". SQLSTATE=42502
Adm101 is in listed in the database but Client101 is not. How can I create a table on the remote client?