Thema:

Kommentar:
: Hallo Markus, : Benutzerabhängig kann man bestimmen, welche Tablespaces zur Verfügung stehen, indem man die USE-Privilegien (man kann z.B. einem Benutzer das Recht "USE" für USERSPACE1 entziehen) entsprechend setzt. : Für Tabellen (benutzerunabhängig) ist das m.E. nicht möglich. : Gruss : Alex : P.S.:Zur Auswahl des Tablespaces ein Auszug aus der DB2-Onlinehilfe (Version 7): : "IF table space IBMDEFAULTGROUP over which the user has USE privilege : exists with sufficient page size : THEN choose it : ELSE IF a table space over which the user has USE privilege : exists with sufficient page size : (see below when multiple table spaces qualify) : THEN choose it : ELSE issue an error (SQLSTATE 42727). : If more than one table space is identified by the ELSE IF condition, then choose the table space with the smallest sufficient page size over which the authorization ID of the statement has USE privilege. When more than one table space qualifies, preference is given according to who was granted the USE privilege: : the authorization ID : a group to which the authorization ID belongs : PUBLIC : If more than one table space still qualifies, the final choice is made by the database manager. : Determination of the table space may change when: : table spaces are dropped or created : USE privileges are granted or revoked. : "

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: