[EMAIL PROTECTED] wrote: > We're running UDB v7.2 fixpack 5 on AIX 4.3.3. > > There's a little confusion on our part about exactly what level of UDB > authority is required to run a LOAD utility with the COPY YES parameter. > > We have a userid that is set up with LOAD authority on the database, and > all the appropriate table authorities for all the tables in the database. > The documentation specifies that this is the authorization that is required > to run the load utility (as an alternative to possessing sysadm or dbadm > authority). > > However, to run the BACKUP DATABASE utility, you need to possess either > sysadm, sysctrl, or sysmaint authority for the instance. > > So, if we were to run the LOAD utility with the COPY YES parameter in order > to backup the database during the load, is LOAD authority sufficient, or > does the user also need to possess sysadm/sysctrl/sysmaint authority as > well? >
Bill, The user does NOT need SYSADM/SYSCTRL/SYSMAINT to perform a load when you specify 'COPY YES'. 'COPY YES' tells DB2 to maintain a copy of the data file loaded, but it does not back up the entire table or tablespace. This prevents the tablespace from going into Backup Pending state. During a ROLLFORWARD operation, DB2 will use the copy of the file and apply it to the table. Note that if 'COPY NO' or 'NONRECOVERABLE' is specified for in the load command (and LOGRETAIN/USEREXIT) are enabled, then the tablespace will be in Backup Pending and the user who loaded the file will *NOT* be able to resolve this without the extra priviliges. Good luck, - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
