DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

DB2LOOK issuing SQL1092N


Hi:
I have a user reporting an error while trying to use DB2LOOK who's getting error SQL1092N, although this user belongs to the designated LDAP group holding DBADM rights.
Here's the command she's trying to execute
db2look -d <dbname> -t TUPT_PUESTO_TRABAJO -a -l -x -c -o DDLTUPT.sql
I wonder if DB2LOOK is working OK with our LDAP security setup....
BTW: We're running DB2 LUW V8.2....I know, I know....we're very far behind... :-)
Any hints...?
Regards
Enrique Valdez
SQL1092N authorization-ID does not have the authority to perform the requested command or operation.
Does the user who runs db2look have all the necessary privileges to access the DB2 catalog tables? Maybe that user is not allowed to read SYSCAT.TABLES, SYSCAT.COLUMNS or some other catalog things because privileges were revoked or not granted?
Note: I'm just guessing myself. Did you have a look at the db2diag output?

Related Links

com.ibm.db2.jcc.a.SqlException
Restoring a database
Convert Date to Varchar
how to copy dbm cfg parameters?
How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
Timestamp column and null indicators
Looking for DB2 UDB 7.1 Trial Version
Weird Problem while retrieving data via php
Migrate DB2 8.1 Tables to DB2 9.5 with partitioning
Federated Stored Procedure - parameters
Federation Server to Oracle 10g - Sequences
ADM1832E error got ????
whats SQL Error: -1131, SQLState: 38503 ???
help: A speech interface for information retrieval using .db2 file
Select
DB2 Federation

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App