The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
20 views

DB2 how to grant SYSADM

The SQL command GRANT SYSADM TO db2inst1; fails with the following message: Error: DB2 SQL Error: SQLCODE=-707, SQLSTATE=42939, SQLERRMC=SYSADM, DRIVER=4.19.49 SQLState: 42939 ErrorCode: -707 ...
0
votes
0answers
59 views

How to install new DB2 Express-C interface (CLI/CLP) language / NLPACK

I'm using IBM DB2 Express-C Docker image on (RHEL 7) https://hub.docker.com/r/ibmcom/db2express-c/ In my dockerfile I'm creating my locale and calling a shell script: ... localedef -i fi_FI -c -f ...
0
votes
1answer
400 views

Difference between su and su -c (environment variables?) when running db2?

When I type this: su <user> -c "/home/<user>/sqllib/bin/db2 catalog tcpip node <dbName> remote <ip> server <port>" I get this error message: SQL10007N Message "-1390" ...
0
votes
1answer
307 views

Windows DB2 9.7 FP8 - The request failed because private virtual memory could not be allocated. SQLSTATE=57011

I have a Windows DB2 9.7 FP8 server running on Windows 2003 x86 that for some reason every time I launch Center Administrator or the CLI and try to connect to a database, I get the error "[IBM][CLI ...
1
vote
1answer
103 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
2
votes
0answers
220 views

Querying DB2 view from Libreoffice Base

I've created a view in DB2 that has the information I need for labels that I was hoping to print out from LibreOffice. When I query the view from the console ("SELECT * FROM ADDRBOOK.LABELS"), I get ...
0
votes
1answer
656 views

Windows install folder in Windows 7?

I am having difficulty uninstalling DB2 from my Windows 7 machine. For some reason, the installer stops responding and doesn't even show up on the Task Manager. I found this article on how to ...
0
votes
2answers
148 views

SQL/DB browser for DB2

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.
3
votes
1answer
5k views

Returning a range of rows in DB2 (LIMIT X,Y equivalent)

Im working with DB2 and I need to be able to return a limited set of results. Ive figured out how to return the "TOP n" results with "FETCH FIRST n ROWS ONLY" But I cannot figure out how to get rows ...
0
votes
1answer
588 views

Accessing DB2 through Cygwin

How can I access DB2 through Cygwin? I’m working on a Windows platform but need to run some bash files and within these bash files I’ve to execute some DB2 commands to test different settings and ...