comp.databases.ibm-db2 Group Information

comp.databases.ibm-db2

163 articles.

0 followers. Post Follow

Top Users in comp.databases.ibm-db2

janinepelletier (112) 112 Articles, 0 Replies, 112 Points

arunrocks (9) 9 Articles, 0 Replies, 9 Points

rnbjrnbj (11) 5 Articles, 6 Replies, 11 Points

Alex147 (2) 2 Articles, 0 Replies, 2 Points

esmith2112 (2) 2 Articles, 0 Replies, 2 Points

gawain (19) 9 Articles, 10 Replies, 19 Points

odd.andersen (2) 2 Articles, 0 Replies, 2 Points

w.l.fischer (2) 0 Articles, 0 Replies, 2 Points

lbryan21 (7) 5 Articles, 2 Replies, 7 Points

sivaswamimail (6) 4 Articles, 2 Replies, 6 Points

Top Articles in comp.databases.ibm-db2

Installing the visual studio add in for DB2

1292 (2/10/2010 3:12:41 PM)
I am using the db2 9.7 client software to install visual studio add- in. The error message: The operation could not be completed. The requested operation requires elevation. Environment: OS: Window... Report Spam

kfwolf (11)

Convert Bigint to DateTime

2011 (2/10/2011 8:32:54 AM)
I have a column in my database named signup_date with a datatype of bigint. I want to know how to convert this bigint into datetime correctly as a result of a sql query. My sql query is this SELECT FROM... Report Spam

robieconti (1)

function with input parameter not found (SQL0440N)

1066 (1/21/2010 10:31:51 AM)
Hi, I am trying to create a function in db2 that takes in a parameter, and returns 1 value. I can make it work as long as there is no input parameter defined (see second part, func2). But for some reason, on... Report Spam

andyhenospam (6)

how to sum a derived column

952 (3/12/2010 5:00:05 PM)
Hi, The following statement was intended to get total count from each section first and then get the total counts of all sections. The union part works and returns. But 'select sum(used)' does not. The ... Report Spam

du_bing

using composite keys in an IN clause

1051 (2/15/2010 8:18:32 AM)
Hello, using DB2 version 9.7 I assumed the following would work. In this example, tableA has a composite key on x,y. select * from tableA where (x, y) IN ( ( 'x1', y1) ) but, DB2 throws this: SQL010... Report Spam

cjflorian (1)

IBM Data server Driver for ODBC

981 (1/27/2010 2:24:07 PM)
I downloaded the "IBM Data Server Driver for ODBC and CLI (CLI Driver)" from here, but I can't install it: in the zip file there is no "setup.exe" or "install.exe" or .msi or something like this. Can you... Report Spam

Franco

Adding DB2 Connect license file to DB2 Express-C 9.7

900 (2/9/2010 7:11:31 PM)
Can i add the DB2 Connect Personal Edition V9.7 license file (from a commercially licensed copy) to a directory in my DB2 Express-C V9.7 installation to obtain connection to z/OS without actually installing... Report Spam

Mark

Limiting file system caching on RH Linux version 5

1012 (2/22/2010 8:23:40 PM)
For DB2 Version 9.5, does setting swappiness= 0 (/proc/sys/vm/swappiness) on RHEL 5 sufficiently limit Linux file system caching, or is there some other way to limit on the percent of memory that can be use... Report Spam

Mark

Message queue sizing on Linux

1184 (2/24/2010 8:39:14 PM)
Hello, Situation: New x86-64 Red Hat Enterprise Linux 5.4 (64 bit) server with plenty of RAM (192GB) and DB2 ESE v. 9.7 FP1. The server has one DB2 instance, hosting one 10TB database. I had tried adj... Report Spam

Troels

ADM0500E The DB2 Service does not have the necessary authority to complete the command

794 (3/23/2010 9:33:50 AM)
Hi all. I'm running DB2 Express C 9.71 on an XP sp2 box, and I get the following error in the event log: Event ID 4. "ADM0500E The DB2 Service does not have the necessary authority to complete the com... Report Spam

Franco