Have just laid down Express-C 9.7 on Windows XP Home Edition system. Install went fine. Now trying the Control Center, able to see SAMPLE database and all tables. However, when attempting to SELECT from table, use does not have the auth to SELECT.
com.ibm.db.DataException: A database manager error occurred. : IBMCLI Driver
SQL0551N "DB2ADMIN" does not have the required authorization or privilege to perform operation "SELECT" on object "SYSTEM.EMPLOYEE". SQLSTATE=42501
The account is an Administrator level account, no Domains, simple Windows XP Home. XP has no groups that I can create, at least I am not aware of any. I have tried setting the SYSADM_GROUP to ADMINISTRATORS, no luck.
How to get this working ???