Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [db2]

The tag has no usage guidance.

1
vote
2answers
20 views

How to I establish CODEUNIT32 (CHAR SET = “UTF-32” in DDL?

I am trying to model a request for a column that will be VARCHAR(120), but will actually store 480 bytes. The length of 480 is established as VARCHAR (120) = 120 x 4 = 480 bytes. This is due to ...
0
votes
0answers
20 views

empty realm part not allowed Issue with Kerberos Authentication over DB2 Server

I am trying to connect to Db2 server over a Kerberos Environment. I am using DB2SimpleDataSource in my code to get a connection to my DB2 server. As per my current understanding, if I have a kerberos ...
0
votes
1answer
444 views

DB2 developer community edition hangs at “Starting docker containers…”

DB2 developer community-edition hangs at "Starting docker containers..." Ubuntu 16.04 LTS x64 , bare-metal, Xeon E5-2660 cpu. 128GB RAM. Docker version 17.06.2-ce, build cec0b72 Using: ibm-db2-...
0
votes
2answers
127 views

Query more than 1 Database on DB2 v10

I am writing an audit script that first collects info on the Linux server, then connects to the DB2 v10 instance via db2 CLI to run queries. It works perfectly with one database on the server. I ...
0
votes
1answer
539 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
1answer
3k 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
2answers
567 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
132 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
277 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
751 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
243 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
9k 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
1k 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 ...