-
Question sur schéma DB2
Bonjour à tous.
J'ai installé DB2 dans machine qui contient window xp. Lors d'installation, DB2 m'a demandé d'entrer un identifiant et un mot de pass. Aprés l'installtion, je constate que desormais, pour avoir acès à le bureau(destop) de mon ordinateur je dois cliquer sur ce identifiant qui ce trouve sur mon bureau ensuite entré un mot de pass.
ce identifiant est utilisé par défaut par tous mes table db2. Malheureusement, l'identiant que j'avais entré est 10 lettre au lieu de 8 maximum
Problem
Lorsque je vaux utilisé ces tables dans un systéme MVS qui demande maxi 8 lettre pour l'identifiant, j'ai des message d'erreur.
Question. 1
Comme changer ce identifiant pour passer de 10 à 8 lettre maxi?
Question 2
Comment supprimer ce identifiant de mon desktop ?
Je vous prie de bien voulloir prendre le temps pour repondre à mes questions.
Je m'excuse de tous problem de langue sur ce texte cas je suis un anglophone.
-
Suggestion...
I've never did it before or tested it, but the following steps should work theorically:
The documentation mentions instance user account privileges and requirements:
http://publib.boulder.ibm.com/infoce.../r0007134.html
DB2 instance user account
The user account must belong to the Administrators group on the computer where you will perform the installation.
A local or domain user account is required for the DB2 instance. Every DB2 instance has one user that is assigned when the instance is created. DB2 logs on with this user name when the instance is started. An error will occur if you use a domain user account to perform a database operation (such as, creating a database) against a DB2 instance created with either a Local user account or the LocalSystem account. If you know you will be a domain user account with your DB2 product, you should create the instance using a domain user account.
You may also use the built-in LocalSystem account to run the installation for all products, except for DB2 Enterprise Server Edition.
You can create the DB2 instance user account before installing DB2 or you can have the DB2 Setup wizard create it for you. If you want to have the DB2 Setup wizard create a new domain user account, the user account you use to perform the installation must have authority to create domain user accounts. This account will be granted the following user rights:
Act as part of the operating system
Debug programs
Create token object
Increase quotas
Lock pages in memory
Log on as a service
Replace a process level token
1 - You'd have to create a user account which belongs to Admin group with has 8 chars max.
2 - Still logged on as the previous user, run db2iupdt with /u option to update the instance with the new user. This is documented below:
http://publib.boulder.ibm.com/infoce.../r0002060.html
3 - Logoff/Logon as new user. Make sure you can issue db2start as the new user.
4 - Create a new database. It should use the implicit schema of the user you are logged in as, which is the new user. Then, you should be able to safely remove the previous id after cleaning-up the previous database.
-
Forgot to mention:
If the above (db2iupdt) doesn't work, another suggestion would be dropping the existing instance and recreating it using db2icrt command. This is documented below:
http://publib.boulder.ibm.com/infoce.../r0002057.html