Hi all i have a db2 instance with 23 databases. i am executing : db2 get snapshot for database on <db name> on all the 23 databases at a time (...

madhu

02-19-2008 11:01 AM
madhu

Hi, Writing from U3 InfoTech Pte Ltd, we are an end-to-end IT solution provider. Our credentials cover full life cycle implementation projects,...

Abhi

08-28-2007 10:57 PM
Abhi

VAM SYSTEMS is a Business Consulting, IT Technology Solutions and Services company with operations in UAE, Qatar, USA, Singapore and India. VAM...

vam

08-13-2007 03:19 AM
vam

How can i get DB2 to work on Vista ? I keep getting a msg that the database manager is not activated , but it is. Thanks for any help

Sergio Nardone

06-26-2007 03:10 PM
blair kenneth adamache

Hi All, I would be greatful if anyone can tell me where can i find the documents on Enterprise Extended Edition (EEE).Because i'm a beginner and need...

sat

11-13-2006 06:38 PM
k.radhesh@gmail.com

do you know guys how good are ibm preps of certmagic.com ? . i wish to purchase one of those . please do let me know

delighty1@gmail.com

10-10-2006 03:33 PM
delighty1@gmail.com

I have set up db2 client many times and have not run into this error before. Can someone help out with this? # ./db2setup DBI1190I db2setup is...

mark.stone@ibx.com

09-11-2006 09:03 AM
mark.stone@ibx.com

Hi Anybody have a experience in converting a 32bit verison of DB2 UDB 8.2 EEE FP 10 on AIX 5.2 to 64Bit version. Can you please tell me what are the...

Anandaravi Ramasamy

08-30-2006 08:39 AM
Joachim Müller

Hi DB2 User, Go Further at the leading user-driven technical event for DB2 and Informix professionals. IDUG 2006 - Europe 2-6 October 2006 ...

Marcel - IDUG Europe 2005

07-03-2006 05:31 PM
Marcel - IDUG Europe 2005

Hi Everybody, I installed the DB2 UDB v 8.2 trial version on Windows xp professional environment. In First Steps I tried to create the Sample...

parsa

04-20-2006 06:34 AM
linyunyi@gmail.com

db2 connect to dbname userid blair password blairpw MyLove wrote:

blair kenneth adamache

02-13-2006 09:23 AM
blair kenneth adamache

Hi every body, I installed DB2 8.2 fp9 on SuSE 9 zSeries and trying to connect to IBM Tivoli Identity Manager 4.6 data source. The error I get...

guru_kottur

12-19-2005 06:27 AM
guru_kottur

Hello I have big problem with replication. It's seems that DB2 has a bug. The operation system is AIX 5.2.0. (I tested also on windows XP with...

Martin Pozdilek

12-09-2004 09:05 AM
Martin Pozdilek

Hi, I have a question when I want to start the db2 eee v7.1 with fixpack 11. I have already create the .rhosts file and change the mode to 600. But...

zwei

11-27-2004 05:16 PM
news

I'd like to connect to AIX DB2 from HOST DB2 with C/S for AIX. It is from HOST to AIX, not from AIX to HOST. Now SNA session connect is...

HeungKi,Kim

11-12-2004 06:55 AM
blair adamache

Hi all I am looking for the funtion in Db2 which is equivalent to INSTR() funtion in Oracle.So far i have looked at funtions "LOCATE" and "POSSTR" in...

Abhijit Gadekar

11-11-2004 08:40 AM
Abhijit Gadekar

Hi all, I am getting the following error while atttempting to execute commands through Command center. ------------ SQL1032N No start database...

Abhijit Gadekar

11-09-2004 08:45 AM
Abhijit Gadekar

Hi all , Can u please help with tranfroming the follwing clause from Oracle to DB2. create table tempTable(name varchar(10)); Select name, null as...

Abhijit Gadekar

11-05-2004 03:51 PM
Douglas Doole

Hi, My first Question: can db2 (db2ckpw) ask over pam_ldap my edirectory ldap server for user authentication? The scenario: 1. computer suse linx...

ronald wunderlich

10-06-2004 02:25 AM
ronald wunderlich

I have installed Migration Toolkit on Windows 2000. Trying to bring up SQL Translator.... The option seem to be greyed out... What should I...

beena

06-15-2004 03:37 PM
beena

I am getting the following error when trying to read records form DB2 table using Java program using a simpel query <QUOTE> CLI0611E Invalid column...

ucbus

02-26-2004 04:37 AM
ucbus

I am getting the following error. Rebooting did not help. Please help InsertPRDB:A SQL ERROR HAS OCCURED IN table_name...

ucbus

02-26-2004 04:37 AM
ucbus

After I successfully complete the installation of DB2 8.1 on AIX and then try to access the control centre by typing db2cc it says :- DB2JAVIT =...

Dipanjan

11-05-2003 03:30 AM
gseller

Is IP connectivity there for the server? If you are using the default port (50000), try a telnet command to be sure that TCPIP connectivity is...

Angelo White

10-23-2003 11:22 AM
Angelo White

Dear all, in my db2diag.log, I always found the this warning ===> Prefetch Queue Full:request not queued. You may need to increase num_ioservers for...

hanhan

10-16-2003 09:21 PM
hanhan

Is there any way or to tool to find out the daily growth of data in DB2. Or any tool that gives me overall growth over a specified...

Sudhakar

10-15-2003 05:30 PM
Sudhakar

No. Erik Hendrix wrote:

Blair Kenneth Adamache

09-26-2003 03:40 AM
Anton Versteeg

Hi, I've tried set connectionAttribute value: cursorhold=1, cachehold=1, and add QUERYTIMEOUTINTERVAL = 0 in my db2cli.ini, but it simply does work...

christine2003

09-19-2003 03:27 PM
Jajati

I have installed a DB2 8.1 server on AIX. After running the setup wizard it said that the installation had been successful. I am trying to use a DB2...

Dipanjan

09-18-2003 01:14 PM
Maor71

our system is below. os=> aix4.3.3 db2level => ver 6.1.xxxx

atrest

09-18-2003 02:59 AM
atrest

Hello friend, I am getting the same error "Synchronisation not supported". Please lemme know if u got a fix. Thanks in advance. rc_sjsu

rc_sjsu

09-17-2003 04:23 PM
rc_sjsu

I have installed a DB2 8.1 server on AIX. After running the setup wizard it said that the installation had been successful. I am trying to use a ...

Dipanjan

09-17-2003 08:51 AM
Dipanjan

Is Windows XP supported under pli v2.1. PL/I installs fine in this environment, but in the readme files Windows XP is never mentiones Regards Dik...

Dik Vermeer

09-16-2003 10:53 AM
Dik Vermeer

Probably a bit late in the day but there is a known problem with ODBC registration on Windows for DB2 when migrating from Version 7.2 to v8.1 It is...

MikeMoy

09-15-2003 08:39 AM
MikeMoy

I create a function, eg. called schema.function(par char(10)). but seems every user have the right to check the syscat.functions system catalog and...

Hansen

09-10-2003 08:59 PM
Hansen

Hi, I am having the same type of problem, but I could not understand the solution. I´m using a Windows NT workstation. Which is the service...

rvasconcellos

09-05-2003 08:49 AM
Blair Adamache

Under %DB2PATH%\samples\c you find some samples for DB2 Programming using C. Or go to the "Appl. Dev." site von...

Rodney Krick

09-04-2003 02:35 AM
Rodney Krick

I need a function which cuts the trailing zeros from microseconds of a timestamp. For instance: from 2003-08-11-12.22.35.200000, I...

b_moni

08-12-2003 04:31 AM
b_moni

I have a stored procedure that inserts a record into a table and returns the new primary key (an Identity column). This works great, but I...

tkofford

08-08-2003 03:26 PM
Douglas Doole

Hello, I have a userid "xyz1" for accessing data on AIX node from database "Database01" defined under udbinst1. Now I would like to use the same user...

ucbus

08-08-2003 08:32 AM
ucbus

Experienced Data Modeler and Data Architect role open in IL. Experienced data modeler and data architecture skills are critical with ERwin...

HiringMgr

08-06-2003 08:29 PM
HiringMgr

Some have solved it by eliminating some of the jars in the project. How did you solve it? -- Posted via http://dbforums.com

rgreathouse

08-01-2003 03:31 PM
rgreathouse

Hi, When I try to open DB Objects list in COntrol Center, I am getting this error. We are using 8.1 client and Server. Both are existing in...

arulprakasam

07-30-2003 08:38 AM
Macehill

Hi We are using Unix Server for DB2 and I am working on 2000. I am using DB2 Type 4 driver to connect to DB2 from Java ie db2jcc.jar. Java SDK 1.3...

arulprakasam

07-28-2003 07:37 AM
arulprakasam

Hi All, How can a SELECT statement SQL return a certain range of the records of the result set e.g. say the total number of records is 100 records...

Ahmed Moustafa

07-25-2003 03:31 AM
Steve

Hello We have the same problem, have you resolved this problem yet? Thanks -- Posted via http://dbforums.com

db2ie

07-18-2003 07:12 AM
db2ie

Hi, I am trying to use JDBC for connection to my database and executing a SQL statement as a PreparedStatement. I get the following error while...

Sameer Pokarna

07-08-2003 07:40 AM
John Keenleyside

Hi!! I am facing a problem in DB2 8.0 Platform HardwareIBM X series server. OS Red Hat Linux 7.2 Software IBM DB2 UDB version...

Rama Krishna

07-07-2003 11:27 AM
rgpage@ca.ibm.com

Hi, Can i do a DB2audit on Parameterized SQL. I checked db2audit for both parameterized SQL's and non-parameterized SQL's. I'm able to get the audit...

Sudhakar

06-30-2003 06:55 PM
Sudhakar

Hi, I'm running DB2 8.1 on SuSE Linux 8.2. I try to create some JAVA stored procedures. I get the procudure to compile successfully. However,...

Louis Wevers

06-30-2003 10:08 AM
Louis Wevers