Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
10 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
0answers
34 views

How to update XML data using XQuery or XQuery with embedded SQL using FLWOR expression in IBM DB2?

Our professor instructed us to make a database table with a column with datatype XML and we populated data inside the table. We were told to perform an UPDATE or DELETE on the XML data on a database ...
0
votes
1answer
108 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
66 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
71 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
199 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
477 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
132 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
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
380 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 ...