The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
47 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 ...
0
votes
0answers
48 views

IBM DB2 Command line Window - Administrator disappears on windows server 2008 r2?

I have installed IBM DB2 version 10 on windows server 2008 r2 machine. However i am unable to open it's command line window. For example: Whenever i try to open Command Windows - Administrator it ...
1
vote
1answer
61 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
190 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
378 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
128 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.
2
votes
1answer
2k 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
339 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 ...