Hello If im not missing something, when looking into directories that are SMS containers i can see multiple files, one for table data, one...

alexhguerra

01-04-2008 03:03 AM
stefan.albert

Hi all, is there any query to manually monitor our DB's performance and status and to take the output to a file. how to make it possible.. can any...

kavin

01-04-2008 12:58 AM
kavin

All, I'm having a difficult time trying to implement two-phase commits across federated database members in UDB 8.3. I've tried using MQ (v 6.0) as...

TheAndroid

01-03-2008 10:26 PM
Larry

It suddenly matters, but I don't have much old docs. When, on LUW, did CTE support appear? I'm certain by v7, but was it earlier? thanks, robert

MeBuggyYouJane

01-03-2008 08:16 PM
MeBuggyYouJane

So IBM will acquire Solid Tech. Extract for the SQL Guide from...

Bernard Dhooghe

01-03-2008 07:12 PM
MeBuggyYouJane

Hi, I have db2 database at V8 + FP 12 and i saw db2fmp process running at 80% cpu I have health monitor turned off and automatic maintainence turned...

db2admin

01-03-2008 11:26 AM
db2admin

HI, I am constantly getting below error. I search on internet but didn't get any help, I would really appreciate if anyone can help me in resolving...

kumar

01-03-2008 11:21 AM
kumar

I have a DB2 mainframe linked server setup in MSSQL2K using the DB2 Connect client software. If the connection to DB2 hangs is there an easy way...

PC

01-03-2008 10:29 AM
PC

I have a DB2 mainframe linked server setup in MSSQL2K using the DB2 Connect client software. If the connection to DB2 hangs is there an easy way...

PC

01-03-2008 10:28 AM
PC

What's the difference between DB2V8 32-bits and 64-bits instance on AIX? and I am confused the relationship between DB2 32/64-bits instance and...

James

01-03-2008 09:07 AM
Serge Rielau

Hello there: We want to replicate onto the same server (Capture / Apply) tables into federated DB2 - Tables but we are not able to do it... I've...

FM

01-03-2008 08:30 AM
FM

aj wrote: I would put double-quotes around the DB2 command to avoid escaping: db2 "rollforward db $db to end of logs and stop overflow log path...

Scott

01-03-2008 05:17 AM
Knut Stolze

Anyone have any leads on decent DB2 DBA for z/OS jobs in the Dallas/ Ft. Worth area? All I am finding is AIX/Unix/Linux jobs. Thanks for the...

ML

01-02-2008 11:26 AM
ML

I need to create a CL program that will take a PF, and create a tab delimited file that has comma seperated column headings as the first record. I...

Kristi

01-02-2008 10:38 AM
Kristi

My db2 v7 was working fine with odbc after I installed new vserion DB2 v8 i still can connect to odbc using command mode, but its not working with ms...

mohammedredha@yahoo.com

01-02-2008 09:27 AM
Lennart

Hi all, without considering DMS in a device, normally, the simplest choices are SMS or DMS in files. Is there any performance improvement using a DMS...

netzorro

01-01-2008 04:06 PM
Jean-Marc Blaise

We are just starting to use DB2. I have a question about Control Center and port 523. Our DBA set up a database that listens on port 30280 (I have...

Frank Swarbrick

12-31-2007 07:13 PM
Frank Swarbrick

I am running DB2 UDB v8.1 FP 14 on AIX 5.3 I have two servers ServerA and ServerB. ServerA has instance InstA ServerB has instance InstB InstA has...

Asphalt Blazer

12-30-2007 04:37 PM
NJ

HI, I had one delete statement, it was running for some time, caused fragmentation on indexes. The delete performance is getting worse. After reorg...

jane

12-29-2007 09:25 AM
Dan van Ginhoven

How can I check if a char/string is a digit/number in an SQL UDF?

E.Bartosiewicz@gmail.com

12-29-2007 07:48 AM
--CELKO--

Hi folks, I know how to create an instance by db2icrt command, such as The -s option of the db2icrt command, which specifies the type of instance...

Laurence

12-27-2007 11:39 PM
Darin McBride

I have a successful app which is used in a variety of client/server situations. (DB2 8.x.) I need to update it to have XML capability to interface...

2803stan@gmail.com

12-27-2007 09:56 AM
Serge Rielau

Am I correct in assuming that it is NOT normal practice to repeat all the certification exams for the new DB2 version when a new DB2 version...

rhino

12-27-2007 04:06 AM
Knut Stolze

Dear, Are you looking out for a challenging engagement / Role switch? Looking out for an Onsite opportunity / Global Exposure? Looking out for a...

valuewing

12-24-2007 11:47 AM
valuewing

I've installed a fresh DB2 V9.1 server (Express-C). Now I see, that the number of applications (db2 list applications) is growing all the times when...

Burkhard Schultheis

12-21-2007 11:31 PM
Ian

Hi, Probably a simple question :-) I've got a few xml aware databases on a 9.1.2 db2 server running on RHEL 4. As db2 V9.5 doesn't run on RHEL 4...

Alex@sharaz.info

12-21-2007 06:54 AM
Alex@sharaz.info

short history: Power designer 12.5.0.2169 (newest one from Sybase site) version with full functionality I creare a new physical model. go to the menu...

ITBeamte@gmail.com

12-20-2007 07:45 AM
ITBeamte@gmail.com

I need to write some code that will validate data. I have a checksum, that I need to calculate in a rather complicated way, so a simple CHECK is not...

E.Bartosiewicz@gmail.com

12-20-2007 07:44 AM
Tonkuma

Training Courses on : Automation Basics course: Automation Fundamentals, VB Scripts Basics, QTP Basics Fees: 1500 Rupees ++++++++++++ +++++++++...

Sharath

12-20-2007 03:01 AM
Sharath

I have db2 9 installation and I think our application isn't handling locking optimally. I have Maxlocks(96) and locklist (104832) setup to be auto...

dunleav1

12-19-2007 05:24 PM
dunleav1

Jeroen, I've studied the older one extensively, but never saw that newer doc. Thanks for the tip. Sean

Scav

12-19-2007 01:54 PM
Scav

Hi, I've a problem reading a field containing a crypted string. I read the field via JDBC but when I decrypt the string I obtain a sequence...

Andrea

12-19-2007 11:06 AM
Andrea

If you are managing a partitioned UDB database, I would appreciate any answer on this: Lets say that I have a performance problem (query which runs...

ilanshiber@gmail.com

12-19-2007 10:59 AM
ilanshiber@gmail.com

Is it possible to install DB2 Connect on a Windows machine for use by a 'regular user'? We do not allow users administrative rights to their machines...

Ed Patterson

12-19-2007 09:10 AM
Ed Patterson

Hello all, we face some severe performance problems and identified at least major problem. Our application is a localized Web application....

michael.schmitz@tietoenator.com

12-18-2007 05:05 PM
--CELKO--

Hello, all. DB2 vv8.2.7, 9.1.3a, 9.5 Here is a simple table function returning sequence of i (this is a parameter) rows with one column of int...

4.spam@mail.ru

12-18-2007 02:53 PM
Serge Rielau

In Oracle, the most efficient way to delete a row (if using a cursor in SQL PL) is by rowid. Rowid is an internal unique identifier that Oracle...

JudyK

12-18-2007 09:30 AM
aj

Has anyone seen this one before? I have an application which was working through an XA Transaction Manager. This applicaiton did one database...

TheAndroid

12-18-2007 09:13 AM
TheAndroid

Hello, Is there a good way to delete all archive log files which aren't being referenced by any backups any longer? I use TSM for the archive log...

Troels Arvin

12-18-2007 07:25 AM
Troels Arvin

QAStreet.com has just launched the first online free testing training / course for fresher especially .check www.qastreet.com for more... -QAStreet

qastreet

12-17-2007 11:32 PM
qastreet

The Boss wrote: -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

chester_perry@yahoo.co.uk

12-17-2007 08:15 PM
Serge Rielau

Would be curious what folks think about it. http://sourceforge.net/projects/db2mc/ Cheers Serge -- Serge Rielau DB2 Solutions Development IBM...

Serge Rielau

12-17-2007 02:36 PM
Serge Rielau

Can someone tell me what I need to get connected to our AS400? I am trying to write an app in VS2005(Data source, Gridview) that requires data from...

Al G

12-17-2007 09:00 AM
Al G

I'm getting an unexpected error while trying to run a script in the Command Center: SQL2001N. The message says that an interrupt occurred but no one...

rhino

12-17-2007 02:27 AM
rhino

Greetings all, Had an existing single domain Win2k server that was demoted when a Win2k3SBS server was introduced. Upon rejoining the domain as...

fbutler@syncronet.net

12-16-2007 03:21 PM
Ian

We have the following query and is taking considerable longer time to run. select A.*, B.name,B.user_type,C.task_id, c.queue_id, c.workid FROM A,...

Veeru71

12-15-2007 11:18 AM
Stefano P.

I noticed that DB2 does not support bitwise operations but I found some UDFs that seem to give this functionality.. There seems to be a consensus...

vasilip

12-15-2007 07:59 AM
--CELKO--

Hi All, I have a field which had a field of DATA TYPE CLOB and in that I have inserted an XML. How can I see the contents of that XML file. Please...

pai

12-14-2007 06:41 PM
rhino

I would like to make a split mirror copy of a HADR standby database. Please note that I do not want to create a standby with a split mirror of...

Mark A

12-14-2007 10:23 AM
Mark A

Hello, I am beginner with db2 ( DB2 v9.1.0.1 running on RHEL 4); this is my first post. I have this error " SQL0968C The file system is full....

cristizaharioiu

12-14-2007 02:38 AM
Knut Stolze