on 03-30-2015 8:18 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gowtham,
Before starting BO installation we can create CMS and Audit Databases in DB2.
● DB2 Alias name - DB SID
● Account username
● Account password
While Installing BO .->Reset existing database checkbox (recommended setting)
Ensure that below steps from Installation Guide.
4.2.1 Extra requirements for IBM DB2
IBM DB2 has requirements that must be met before installing the BI platform:
● Ensure that the DB2 database is created with the following settings:
Collating Sequence = "Identity"
Codeset = "UTF-8"
Territory = "<XX>"
Replace <XX> with the code that is appropriate for your location. Consult your DB2 documentation for more
information. If your DB2 database does not have the Collating Sequence = "Identity" setting, the
user and user group objects may not sort as expected in the CMC.
● Create a user temporary table space before installing the BI platform. If you do not create a user temporary
table space, the BI platform installation program will not be able to configure the DB2 database.
For more information on user temporary table spaces in IBM DB2, see DB2 Basics: Table spaces and buffer
pools in the IBM technical library: http://www.ibm.com/developerworks/data/library/techarticle/
0212wieser/0212wieser.html .
● When using IBM DB2 to host an Auditing Data Store database, ensure that the page size for the auditing table
space is set to a minimum of 8192 (8 KB).
● Ensure that the CMS system database is not partitioned. The Auditing Data Store database may be
partitioned.
Regards,
V Srinivasan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nethaji
Make sure you logged in with db2sid user, to run this command.
also check the link below
Thanks
Sadiq
Hi Gowtham,
Follow these steps:
1.) make sure your user id used to connect to the database is following the naming rules for DB2:
2.) Check the permissions on the following files in the instance ~/sqllib/security/ directory:
ls -l /usr/<sid>/sqllib/security
-r-s--x--x 1 root db2inst1 20374 db2ckpw*
-r-s--x--x 1 root db2inst1 14387 db2chpw*
3.) Stop the instance by running:
db2stop
4.) Log in as a user id that has root authority.
5.) Issue the following command to update the instance:
DB2DIR/<sid>/db2iupdt <sid>
6.) Then start the instance by running:
db2start
7.) If you still see the error please also Make sure the catalog information on the client is correct.
Hope this helps.
Regards,
Hugo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Hugo,
Thanks for your reply!!!
We are facing the error while installing the BO. And our DB2 installation has been done successfully.
While providing CMS details in the BO installation. we are getting the above error.
Could you suggest whether it may be a issue with permission ?
Please share the details for Windows OS.
regards,
Nethaji
Hi Nethaji,
This is what IBM says about your error:
24 (USERNAME AND/OR PASSWORD INVALID)
The username specified, password specified, or both, are invalid. Some specific causes are:
Check the above.
Regards,
Hugo
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.