Super User
Super User

Questions tagged [db2]

24 questions
3
votes
1 answer

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 from X to Y. mySQL equivalent is LIMIT X, Y Any…
madmaze
  • 4,444
2
votes
0 answers

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 a bunch of information, but if I try to view it…
Tanktalus
  • 166
1
vote
1 answer

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

When I type this: su -c "/home//sqllib/bin/db2 catalog tcpip node remote server " I get this error message: SQL10007N Message "-1390" could not be retrieved. Reason code: "3". But when I do this: su…
ArtOfWarfare
  • 731
1
vote
1 answer

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 displaying and sorting or filtering all queries…
Mab
  • 11
  • 1
1
vote
0 answers

MS Access Error: Invalid field definition 'CON474' in definition of index or relationship

Looking for some help with a MS Access problem. I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without issue. A few however give me the below error…
Ben Smith
  • 11
  • 1
1
vote
1 answer

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 indexes. However, I can’t seem to get it to work.
Mestika
  • 991
  • 3
  • 11
  • 16
1
vote
2 answers

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 string unit specification code unit 32. That means for…
John Shute
  • 11
0
votes
2 answers

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 Driver] SQL1219N The request failed because private…
user500741
  • 101
0
votes
1 answer

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 uninstall in such…
Shailesh Tainwala
  • 135
  • 3
0
votes
2 answers

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.
jgauffin
  • 1,013
0
votes
1 answer

Ansible: Switching to su user and when running tivoli db2 command, gives command not found

when manually ran db2 command on the server works. But when executing using ansible which switches to the user but fails to run the db2 command. I am stuck on this issue for the whole day. Any suggestions would be greatly helpful. task item: -…
Anjan Kumar
  • 1
0
votes
1 answer

DB2 syntax error

I am using the below SQL statement to calculate the size of application group data table. SELECT A.TABLE_NAME FROM ARSSEG A, ARSAG B WHERE A.AGID=B.AGID AND B.NAME='' For EACH TABLE_NAME in query 1/, run "SELECT DOC_NAME,…
sai prudhvi
  • 41
  • 2
  • 4
  • 9
0
votes
1 answer

DB2 : How to resolve "SQL0206N "INVOICEDATE" is not valid in the context where it is used.SQLSTATE=42703" error

In linux i connected to DB2 and trying to grab oldest invoice. while using this below query it shows an error SQL0206N "INVOICEDATE" is not valid in the context where it is used.SQLSTATE=42703 db2 "select min(INVOICEDATE) from RHA2"; How can I…
sai prudhvi
  • 41
  • 2
  • 4
  • 9
0
votes
1 answer

DB2 9.7 task center do not work in SUSE 11 sp4 - DBA1176N

I've install DB2 9.7 enterprise edition on suse 11 sp4, the problem is that when i want to see "task center" it show's bellow error: DBA1176N The Control Center failed to automatically catalog the Tools Catalog Database "" for system…
saeed safavi
  • 1
0
votes
0 answers

db2 create failing with SQL1762N

db2 V10.5 RedHat Linux RHEL7. Installed without error. db2 create db AMW907 on /home/mis/amw907 fails with SQL1762N Unable to connect to database because there is not enough space to allocate active log files. SQLSTATE=08004 My disk space is…
Art
  • 1
1
2