I apologise upfront already for wasting time for my noob questions.
I am installing some applications that require DB2 and there are two things that I not sure about.
1. Updating configuration parameters and variables, like:
Is this like Windows system variables? What about the APPLHEAPSZ paramenter? (Again, I apologise, new to DB2 and not a DBA by profession)
2. How to assign the following DB2 permissions to a specific user:
CONNECT ON DATABASE
USE OF TABLESPACES
SELECT on SYSIBM.SYSVERSIONS
SELECT on SYSCAT.DATATYPES (Object Store creation only)
GRANT on SYSCAT.INDEXES (upgrades only)
GRANT on SYSIBM.SYSDUMMY1
USAGE on workload SYSDEFAULTUSERWORKLOAD
IMPLICIT_SCHEMA on DATABASE
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be