From DB2 on aix, we access zOS sources via DB2 Info. Integrator. I was told that on zOS the group is converting EBCDIC CCSID from 500 to 37 US...

01-16-2007 10:48 AM

Hi, I am getting this error : ERROR SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00C90084", type of...

01-03-2007 11:08 AM

Hi, I have a table which contains millions of records and I will have to find out, say, 100th, 200th,...etc records from this table ordered by a...

12-26-2006 03:45 AM
tonkuma

I need to trigger an update on a Microsoft SQL Server 2005 database table when a corresponding table in DB2 for z/OS has a row inserted, updated, or...

JimS

12-19-2006 06:03 PM
JimS

Can I generate data from AS/400 to flat files using data propagator for DB2 on iseries? I want all changes to be replicated/accumulated to flat file...

lakshman.muthayya@ustri.com

12-18-2006 02:22 PM
lakshman.muthayya@ustri.com

Hi All I would like to rewrite the following query, to improve the performance. Can anyone help? SELECT...

12-18-2006 07:55 AM

Hi all, I'm new to main frame. Please help... When I tried to access a subsystem, I got this: DSNE133E DSNECP12 RELEASE LEVELS NOT COMPATIBLE....

12-15-2006 08:38 PM
John S. Giltner, Jr.

Hi, On a new install of db2 v8 (ccsid 37) , we enter the following query in a java app on a browser : select '\]' , hex('\]') as test from...

12-15-2006 03:49 PM
none

Hi, we are porting a large application from Oracle to DB2. The Oracle version uses the DBMS_LOCK-package in a few places to reserve resources that...

12-14-2006 04:38 PM
Dougie Lawson

Is there any function to read a strig character by character

12-14-2006 11:00 AM
isatcjk

Greetings, Does anybody have any literature that compares the performance of IDMS and DB/2? Specifically, I am looking for CPU usage or...

jtzecher

12-14-2006 10:40 AM
jtzecher

Hi! I want to install a zIIP on my z/OS Mainframe. Is it possible to call stored procedures on the mainframe, based to the ziip? thanks, Klaus

12-14-2006 09:48 AM
mike_bracey@uk.ibm.com

We have a EMP table with a primary key of 2 columns, company and employee number. There is an index on the primary key. By knowing the company and...

12-13-2006 03:50 PM
none

Hi, I have a trouble with a MVS log. In a zOS system with a HITACHI storage control unit there was a double disk fealure (In the same raid 5 parity...

albertuan

12-13-2006 03:34 PM
none

I want to know what the best practices are for maintaining DSNDB07 (work database) on DB2 v7.1 for Z/OS? A colleague swears that we need to delete...

dba.hcm@gmail.com

12-13-2006 03:28 PM
none

I keep finding examples of how to return SQLSTATE to a trigger calling a stored procedure, but it fails to show me how to setup the trigger....

12-11-2006 12:42 PM

Hi does anyone know if an UDF can call a stored procedure ? I've looked in the manuals and it doesnt say anything , neither for nor against .It says...

12-11-2006 12:03 PM
isatcjk

Hi! I am presently involved in moving data (after necessary conversion) from VSAM to DB2. Once this is done, the requirement is to provide a...

GreatAlterEgo

12-11-2006 07:35 AM
GreatAlterEgo

Hi, Anyone know any white papers or articles on the query rewrite capabilities of DB2 v7 and v8 ? i have checked the manuals but there is very little...

12-05-2006 08:26 AM

Hi! I want to get the MSUs (Millions of Service Units) on my Oracle 10g Database with all Application Programs. IBM uses this metric for licensing...

12-05-2006 03:34 AM

Hi What is the minimal setup , necesarry to send a DRDA request from a z/OS to another machine ?

Miklos Szigetvari

12-04-2006 12:24 PM

Unfortunately, this group is not very active at present You can search for the DB2-L listserve group and subscribe and post via email for...

Robert Jones

11-29-2006 01:50 PM
Robert Jones

I need to call a stored procedure written in Cobol from Java. Can anyone please help me in this?

11-29-2006 04:07 AM

How can I query the catalog tables in z/OS to get information on the scripts for a given user defined function/stored procedure?

11-28-2006 07:19 PM

Hi - I would be very grateful for advice or experience regarding the following. For some time at my IS shop there has been an absence of a...

alex.mcshane@btinternet.com

11-28-2006 01:18 PM
alex.mcshane@btinternet.com

Hi, Does anyone know where i can get reading material on the new type of Tablespace defined in V9 ? I have found only a presentation which doesnt...

11-24-2006 01:35 PM
Markus Neifer

Hi, Which tool is best to tune Java programs ? I am more used to tuning static SQl. I can turn on IFCID 22 for the mini-plans .I have access to DB2PE...

11-24-2006 01:28 PM

Hi, I have worked as a DB2 DBA on Unix platform. I need to now work on OS/390. There are lots of difference between these two. Has anybody worked...

11-24-2006 12:47 PM
Markus Neifer

Hello, Is it possible to obtain rows from a table which have a certain combination of values in 2 columns? I know I could...

11-22-2006 03:03 PM

We currently are running DB2 V7 for Z/OS. Our Operating system is Z/OS v1.7 We issue a ARCHIVE LOG command using the SSI from a MVS Console /*xxx...

11-21-2006 12:25 PM
Dougie Lawson

Hi all, we do have the same problem as stated by ldifabio. We are using DB2 v8.2 UDB on zLinux and access the database from VSE via DRDA and a DB2...

11-13-2006 04:13 AM

Hi, when Iam trying to install DB2 personal edition 7.2.Its saying "please wait while DB2 is installed this can upto 25 mints" after this Its saying...

alexender

11-05-2006 10:14 AM
alexender

Hi. Looking at the manuals for DB2 v7, I'm finding some contradictions in the limits of passing data to a stored proc. Can anyone help with the...

11-03-2006 09:19 AM

Does anyone have an example of a COBOL module executing a GET DIAGNOSTIC to retrieve information about the last SQL call? I'm not having much luck...

10-30-2006 09:50 PM

Hallo, wir haben aktuell ein Problem mit den Ergebnissen für EXPLAIN aus dynamischn SQLs und aus REBINDs. Sie unterscheiden sichvor allem in den...

10-26-2006 04:53 PM
SVK

Hello everyone! I have a question about space optimization, I think. I have an old table with many columns. I need to store new information and I was...

10-24-2006 03:01 PM
isatcjk

Search Engine Cloaker is used by hundreds of top-ranked Webmasters to increase their search engine listings. How it works: Cloaker tricks the...

Mark Jones

10-21-2006 07:55 AM
Mark Jones

Hi All: I use db2 v8.2 on AIX platform. I have three databases using the same instance. Whenever I stop and start my database for taking a full...

Racerx

10-20-2006 10:13 AM
Racerx

What is the purpose of this group??? Most of the questions posted here stay unanswered for ages. Some rare posted responses to some questions are...

SVK

10-18-2006 02:13 PM
Robert Jones

hi i am writing in db2 in rexx.... its working fine for select and update but its giving sysntax error when i am doing update can any bodyu help on...

10-18-2006 12:26 PM

Hi, we are hunting down a problem in our application that runs on zLinux against a DB2 UDB for zOS. This is a CLI-Application that runs on...

10-16-2006 09:21 AM

Hi All: I am new to db2 databases. I use db2 V8.2 on AIX 5 platform. My database has 6 primary Log files and no secondary log files. When I try to...

Racerx

10-13-2006 11:31 AM
Racerx

I am deploying my webApplication on WAS 6.1. I am using precompled JSPs. So I tarnslate my JSPs to java by "wsjspc", then compiled by javac to...

10-13-2006 05:38 AM

here is my question i have the following sql select column-1, count(*) from table1 group by column-1; This gives me the following result(3 rows) ....

10-12-2006 09:11 AM
SVK

Hi, i am analyzing explain for some triggers and i have noticed a weird ( to me ) access path . I have a Delete on a big table (not partitioned)...

10-10-2006 03:14 PM

Hi, I am trying to access a remote db on z/os through Visual explain and i am getting the following error msg : fail to load JDBC driver SQL8002N...

10-10-2006 02:47 PM

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

acheiver

10-10-2006 05:09 AM
acheiver

Trying to connect to a z/OS database from a Windows machine running DB2 Connect Unlimited Edition 8.1 FP12. Currently logged in on the windows...

10-05-2006 09:28 AM
Ulrich Boche

I am trying to query the catalog tables in db2 for Z/OS version 7 and I was going through the documentation for sysibm.systabconst table. the...

10-03-2006 07:57 PM
tonkuma

Jon/Dave: I'm trying to research an issue relating the ANSI SQL standard around an owner name in the following sample select statement: SELECT...

10-03-2006 02:57 AM
jarl@mimer.com