EasyManuals Logo

IBM E027SLL-H - Tivoli Monitoring - PC User Manual

IBM E027SLL-H - Tivoli Monitoring - PC
310 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #248 background imageLoading...
Page #248 background image
DB2 error: SQL0302N The value of a host variable in the EXECUTE or OPEN
statement is too large for its corresponding use. SQLSTATE=22003 sqlstate =
22003
1. Set the environment variable DB2CODEPAGE=1208 as a system
environment on the Windows computer where the Warehouse Proxy is
installed.
2. Restart the Windows computer so that the Warehouse Proxy windows
service recognizes the change.
SQL0552N “ITMUSER” does not have the privilege to perform
operation “CREATE BUFFERPOOL” SQLSTATE=42502
If the Warehouse database user does not have the correct permission, the following
error can occur:
(42ED71FA.0000-E4C:khdxbase.cpp,250,"setError")
Error 20/3/-552(FFFFFDD8)/0 executing SQLExecute
(42ED71FA.0001-E4C:khdxbase.cpp,266,"setError")
Error "[IBM][CLI Driver][DB2/NT] SQL0552N "ITMUSER" does not have
the privilege to perform operation "CREATE BUFFERPOOL" SQLSTATE=42502
When you configure a DB2 Warehouse Proxy connection from the Manage Tivoli
Enterprise Monitoring Services utility using the Configure DB2 Datasource for
Warehouse window, the user ID the Warehouse Proxy uses to connect to the
warehouse database must have SYSADM permission. SYSADM permission is
required to create an 8K Tablespace and Bufferpool.
Windows
If the database is on Windows, the user must be a member of the local
Administrators group.
UNIX-based system
If the database is on Linux or UNIX user must belong to the SYSADM
group.
1. Log in as the DB2 instance owner (usually "su - db2inst1"),
2. Run the following command to determine the group that the
UNIX-based system user must belong.
db2 get dbm cfg | grep SYSADM
230 IBM Tivoli Monitoring: Troubleshooting Guide

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM E027SLL-H - Tivoli Monitoring - PC and is the answer not in the manual?

IBM E027SLL-H - Tivoli Monitoring - PC Specifications

General IconGeneral
BrandIBM
ModelE027SLL-H - Tivoli Monitoring - PC
CategorySoftware
LanguageEnglish

Related product manuals