Bonjour,
Quand je créer une table sans préciser le TBS, il choisi un tbs lauis j'en veux un autre.
Comment définir un tbs par défaut pour un utilisateur ou un schéma ?
Merçi de votre vaide
DB2 V7 AIX 4.3.3

Quote from the SQL reference:

"
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:
1. the authorization ID
2. a group to which the authorization ID belongs
3. PUBLIC

If more than one table space still qualifies, the final choice is made by the database manager."

P.S. How do you say RTFM in French?

Bonjour Philio.

now in my bad english.
the scheme is for the user. do you set the schema per default for a user with this command:

set schema <schema>

sorry by my english.