Our home-based business has made a bold decision in achieving flexible working conditions when we purchased BluegemEXPLORE® for student management...

Bluegem Explore

08-01-2011 11:37 PM
Bluegem Explore

Wipro and RBS hiring mainframe candidates for Gurgaon, chennai and Greater NOIDA - follow link for...

http://mainframewizard.com/

06-07-2011 03:25 PM
http://mainframewizard.com/

hello, i do not know if this will be the right group, but i give a try. i want to implement some methods in udf for db2 (no specific platform). now...

datenwort

08-09-2010 02:42 AM
datenwort

We are looking to fill the following permanent position with one of our reputed clients in Saudi Arabia (WESTERNERS ARE PREFFERED). Apply to:...

Rudra Mishra

07-08-2010 12:49 PM
Rudra Mishra

As previously posted, the IBM Software Newsgroup server (news.software.ibm.com) will close by the end of the year. In preparation for the shutdown,...

Alexei Gabler

12-02-2009 05:09 AM
Alexei Gabler

Hi all, I would like to retrieve all addresses related to an account. Currently my application uses a cursor to fetch all possible addresses, say...

Siddharth.Swaminathan

12-02-2009 02:18 AM
mlsamaga

The query below never works when executed from DB2 9.5 control center FOR v_row AS SELECT label FROM component DO update gateway_authentication set...

antonio

12-01-2009 03:50 PM
antonio

Timestamp to RBA conversion Suppose I want to convert timestamp to RBA value. How do I do that? This is for DB2 for z/OS on IBM Mainframe.

javier42396

11-24-2009 06:25 AM
momi.sabag@gmail.com

I would like to use a DB2 Trigger to launch a CICS transaction when a row is inserted into a table. However, if multiple rows are inserted, I don't...

MQuser06

11-21-2009 11:44 AM
Gordon Peters

This thread is regularly updated with announcements about DB2 for z/OS and links to DB2 resources. *Information center flash tutorials -...

djlyle@us.ibm.com

11-18-2009 01:06 PM
djlyle@us.ibm.com

This Newsgroup will close by the end of the year. IBM invites participants of this Newsgroup to join the IBM developerWorks forum...

Alexei Gabler

11-18-2009 11:40 AM
Alexei Gabler

i have a problem in restricted DB on mainframe when i write command "DIS DB(*) SP (*) res" it's show a particular database let's name (A) when i...

eng.mahmoudabbas

11-18-2009 07:10 AM
sdasinger@monlife.com

In a WHERE clause, why are such constructs as NOT IN, NOT BETWEEN and NOT LIKE valid, but NOT EQUAL is flagged as an SQL -104? You can negate the...

Fred Whitlark

11-16-2009 01:51 AM
momi.sabag@gmail.com

Hi, Please help in resolving the below error My reorg job is abending with the below error -DSNT500I 297 05:12:14.73 DSNUGBAC - RESOURCE...

IBM-INDIA

11-16-2009 01:26 AM
momi.sabag@gmail.com

Hi Team, I wish to migrate my db2 columns from 'double' to 'DECFLOAT' to avoid loss in data precision due to rounding errors. Please find below my...

ShamimD

11-16-2009 12:47 AM
momi.sabag@gmail.com

Hi All I need a urgent help !!! Details of my OS are as follows oS/390 version 03 Release 19.00 type Of hardware is 2097. The C/C++ compiler i am...

kaliaanup

11-16-2009 12:45 AM
momi.sabag@gmail.com

Hi All I have an application on Windows and Database on Z/OS. I could connect to the Database from the Control Center using xyz as the user. Also...

j_devlop89

11-16-2009 12:42 AM
momi.sabag@gmail.com

I was using a 3 part name to access a table from SPUFI. It works with a normal select. Like – select * from ENCC.DBTEST.TABLE1; ( ENCC is the...

Newyork-City

11-11-2009 01:08 AM
momi.sabag@gmail.com

In IMS there is an API to read RECON datasets and retrieve log information in a stuctured form. Is there something similar for DB2, or am I left to...

rossb

11-06-2009 08:30 AM
StevePratt

Hi, I'm looking after benchmark comparing DYNAMIC SQL and STATIC SQL on DB2 V9 Z/OS. We are running web application on websphere server 6.1. these...

Eric_Nolmans

10-29-2009 02:53 PM
Eric_Nolmans

In a deadlock, how does DB2 determine which transaction/user/job to terminate? The "word on the street", what I have always heard, is that DB2...

Fred Whitlark

10-29-2009 05:43 AM
alexDG

Is their anyone had successfully compiled the IBM sample SQL stored procedure using IBM smaple JCL and PROC? Is that work for anyone? If yes, please...

RimonMina

10-26-2009 01:53 AM
momi.sabag@gmail.com

hi guys! i am an absolute new in the world of Z/OS. my development machine is windows and IBM websphere is installed on it. i have been given a...

faisalbhagat

10-25-2009 02:21 PM
faisalbhagat

Hi, We use native stored procedure on DB2 V9 Z/OS. In a stored procedure, I read some columns from a table like this : CREATE PROCEDURE...

Eric_Nolmans

10-23-2009 08:10 AM
Eric_Nolmans

Hey there. I have DB2 v9.5 installed on my machine and I also have the Fix Pack 1 for it. My doubt is, when I try installing this fix pack, it...

Deepak Dhami

10-22-2009 02:21 AM
Deepak Dhami

IBM has a required minumum level for DB2 Connect before upgrading to DB2 version 9. For example V8.1- fixpack 13 V8.2 - fixpack 6 V9.1 - fixpack 1...

Torgny.lindstrom@Logica.com

10-22-2009 01:32 AM
momi.sabag@gmail.com

We upgrade db2 on z/os from v7 to v8. Our development environment is in compatibility mode, newfun(no). I have sql stored procedure. (1) When it is...

RimonMina

10-16-2009 05:17 PM
RimonMina

hi ! do you have any user manuel for seeting CURRENT SQLID in RACF ? is it profile problem ? the guy in charge with RACF is not familiar with db2...

Oratorio

10-16-2009 07:58 AM
n314890

Where can I download db2jcc.jar and db2jcc_license_cu.jar(Type 2 & Type 2)files? These JDBC drivers are required to connect to DB2. -kaustubh

Kaustubh C

10-14-2009 03:05 AM
momi.sabag@gmail.com

The DB2 for z/OS Information Development team wants to know how you find answers to your questions about DB2 for z/OS. We are particularly interested...

djlyle@us.ibm.com

10-13-2009 02:28 PM
mqqn

Hello all, I have to copy STATS of some tables from PROD to TEST environment, in order to test the query performance in TEST. Any inputs are greatly...

DBA12

10-13-2009 01:27 PM
mqqn

Hi , Is any used DB2 Insight and Platinum tool. If yes, Help me in getting some knowledge on these tools and share the material related to...

IBM-INDIA

10-13-2009 07:43 AM
IBM-INDIA

Hi, Can anyone help in using DB2 Trace. We have a performance issue, so we are planned to enable DB2 Trace. 1) What are the steps for enabling DB2...

IBM-INDIA

10-09-2009 06:25 AM
n314890

We have a couple of COBOL stored procedures which issue a DROP and then check for SQLCODE 0 and -204. Then a DECLARE GLOBAL TEMPORARY TABLE is...

Suresh.K.Karthik@aexp.com

10-07-2009 11:11 AM
NREVEZZO

Hi, Can any one help me in finding the invalid views on Z/OS

IBM-INDIA

10-07-2009 08:21 AM
ToddBurchDB2

Hi, I am trying to find out the all the APARs & PTF that are installed. Please help me I Tried using DIAGNOSE utility to find the APARs & PTF,The...

IBM-INDIA

10-07-2009 08:14 AM
ToddBurchDB2

Hi, We have DB2 8.1 in z/OS with data sharing environment, having 8 applications in two subsystem. There are hundreds of tables are there,...

datta

10-07-2009 05:17 AM
ToddBurchDB2

We currently use "Space Estimator" option in "DB2 Admin Tool" to estimate primary quantity and secondary quanity while creating tables spaces and...

DB2_DBA

10-06-2009 02:51 PM
db2zooooos

in UDB the following is possible, but in z/OS I cannot use SELECT in USING. how can I acheive that? I can replace the using with : *USING (VALUES...

Raj_j2ee

10-06-2009 12:42 AM
batuan

Hello I tried to unload from a table or tabspace using BMC or IBM both are not working with ROWID. I wanted to have that tableapce with shrlevel...

sri

10-02-2009 08:42 PM
sri

Examples! Looking for an example to help you with a coding challenge in DB2 for z/OS? Check out the...

djlyle@us.ibm.com

10-01-2009 04:54 PM
djlyle@us.ibm.com

In UDB the following is possible, but in z/OS I cannot use SELECT in USING. how can I acheive that? I can replace the using with : *USING (VALUES...

Raj_j2ee

10-01-2009 10:58 AM
Raj_j2ee

Hi, could someone kindly advise on the performance of OPTIMIZED FOR N ROWS in an SQL select statement and its cost? Will it be appropiate to use...

dabdaziz@hotmail.com

09-30-2009 03:52 PM
momi.sabag@gmail.com

We changed: maxdbat from 100 to 500, condbat from 500 to 1000 and cthread from 500 to 1000. Most of the users of this db2 are drda users. We want to...

avivab@bll.co.il

09-29-2009 11:57 PM
momi.sabag@gmail.com

For batch programs, CICS, IMS transactions, and TSO calls that access DB2 data the CPU time accumulated in DB2 is returned to the calling...

Artb

09-28-2009 10:54 PM
Artb

try this select t1.*, case when t2.EMP_NAME is not null then t2.EMP_NAME when t3.ETEMP_NAME is not null then t3.ETEMP_NAME else 'Employee Name not...

momi.sabag@gmail.com

09-25-2009 11:13 AM
momi.sabag@gmail.com

We are using the DB2 Connect type 4 JDBC drivers with a Tivoli application (TCR) to connect with DB2 and are eventually striking some resource limit...

allachan@au1.ibm.com

09-24-2009 03:12 AM
momi.sabag@gmail.com

We have a customer running Db2 Connect V5 on Db2 V8 NFM. Anyone else having something like that? Could it work when we are upgrading to Db2 V9? There...

torgny.lindstrom@logica.com

09-24-2009 02:10 AM
momi.sabag@gmail.com

hello, we have a partition table with 12 partition (for each month) , each partition is defined with compress yes and dssize 32G , the input is...

erantz_dba_db2

09-21-2009 02:09 AM
momi.sabag@gmail.com

The Administration Guide for z/os says that an Inatall SYSADM have all the privileges of a SYSADM plus...... Why should I do step 2) (grant SYSADM...

matsw

09-20-2009 02:22 PM
Jan Kowalski