Stack Overflow
Stack Overflow

Questions tagged [db2-zos]

Use this tag for questions about DB2 for z/OS, the IBM mainframe operating system. Please also tag such questions with the more generic [db2] tag. There are enough differences between DB2 for z/OS and DB2 for other platforms to warrant a separate tag.

175 questions
0
votes
1 answer

currentFunctionPath property is not working for my stored procedure from Java

I am calling stored procedure which is created in DB2 for Z/OS from Java. I want to call the stored procedure without using schema name. I'm not using schema name for all other SQLs by setting currentSchema datasource property. I came to know that…
akr
  • 123
  • 1
  • 1
  • 9
0
votes
2 answers

DB2 Temp Table - Retrieving inserted Data in DB2 Z OS

I have created a temp table and Inserted in DB2 ZOS as mentioned below CREATE GLOBAL TEMPORARY TABLE tmp2 (col1 INT) INSERT INTO tmp2 (col1) VALUES (10687); INSERT INTO tmp2 (col1) VALUES (10689); INSERT INTO tmp2 (col1) VALUES (10691); …
IamDMahesh
  • 99
  • 1
  • 10
0
votes
1 answer

why COLCARDF Field on SYSIBM.SYSCOLUMNS equal 0 after runstat on tablespace?

i working with db2 10.1 zos When Runstat on table ، COLCARDF ّfield of SYSIBM.SYSCOLUMNS One of the columns 0 But on table SYSIBM.SYSINDEXES Fields FIRSTKEYCARDF and FULLKEYCARDF is true my Runstat jcl job : RUNSTATS TABLESPACE dbname.tsname part…
hooman pezeshki
  • 1
  • 1
0
votes
1 answer

Retrieve rows with a given set of values and no others

Working with Db2 on z/OS. Consider a simple example of an ORDER table and a child ORDER_ITEM table. the PK for the child is ORD_NUM plus PART_NUM. I want to find the rows in the ORDER_ITEM table with parts that have only a certain set of PART_NUM…
ChuckLeviton
  • 141
  • 9
0
votes
0 answers

DB2 - INDEX WITH SCALAR FUNCTION

I have to define this index: CREATE UNIQUE INDEX INDEX1 ON TABLE1 (FIELD1 ,FIELD2 ,FIELD3 ,COALESCE(FIELD_DATE,DATE('9999-12-31')) USING... The statement ends in error: SQLCODE -270 FUNCTION NOT SUPPORTED. i am using Db2 z/os V11 I do not…
killer
  • 11
  • 6
0
votes
2 answers

db2 for zos - prohibit changes in columns

I would like to ask if there is a way to prohibit programs to change data in certain columns, at db2 level. The problem is that I have some programs that change data in a group of tables but now I must not change data in some columns and I would…
Ricardo Pinto
  • 333
  • 1
  • 2
  • 11
0
votes
1 answer

DSNUTILB using PRESORTED option

I'm working on changing a DSNUTILB parameter member to allow for the input data now being pre-sorted in order to improve efficiency. However experiencing syntax issues with incorporating PRESORTED option. At the moment I have: LOAD DATA PRELOAD LOAD…
dingbats99
  • 1
0
votes
1 answer

View Record Lock Details in DB2 for z/OS

An overnight job encountered a locking error on updating a record in DB2 10 for z/OS. I've been asked to inspect the DB2 logs to hopefully find more information on what was locking the table. Since I have the timestamp of the failure, how can I look…
Dave Ford
  • 341
  • 2
  • 14
0
votes
1 answer

IBM DB2 Load failure to IBM DB2 Z/Os

Connect to server user myuser using mypass; LOAD CLIENT from "Text_File.TXT" OF DEL MODIFIED BY CHARDEL0x22 coldel0x09 KEEPBLANKS USEDEFAULTS TIMESTAMPFORMAT="YYYY-MM-DD HH:MM:SS.UUUUUUUUU" MESSAGES "Log_Text_File.TXT" INSERT INTO SCHEMA.Table…
chris fowler
  • 25
  • 9
0
votes
1 answer

IBM DB2 - Do not unload DECIMAL rows exceeding a certain length

I have an IBM DB2 table where I want to UNLOAD data from so that I can load it into another DB2 table. Both tables have the same columns (and types), except one decimal field. It is DECIMAL(6) in the source table and DECIMAL(5) in the destination…
VidyaNeedsBetterTesting
  • 11
  • 1
  • 4
0
votes
1 answer

How to get an array as output using rexx

I'm testing some functions of Db2 for z/OS, and right now I'm having troubles when I try to call a Stored Procedure through REXX. Below is the code to create the Data Type that I need to return in my Stored Procedure CREATE TYPE *******.ARRAY_TESTE…
Ricardo Pinto
  • 333
  • 1
  • 2
  • 11
0
votes
1 answer

DSNURWBG - INPUT FIELD ffffff NOT ENTIRELY WITHIN INPUT RECORD

I am trying to load a file to a DB2 table and getting following error: INPUT FIELD ffffffff NOT ENTIRELY WITHIN INPUT RECORD can anyone pls suggest what is going wrong.
Manish
  • 649
  • 2
  • 7
  • 10
0
votes
2 answers

Connecting to Db2 on z/OS via JDBC using IBM JDK vs OpenJDK

I am able to connect to Db2 on z/OS with the IBM universal JDBC driver file db2jcc4.jar using IBM JDK 1.8 that is bundled with WebSphere 9. Every thing works fine and I can browse the catalog and execute queries. I used Squirrel SQL version 4.0.0.…
Rahul Khimasia
  • 473
  • 12
  • 24
0
votes
1 answer

What platform is Db2 running on

I was asked to connect to a Db2 database on my company's mainframe. I was given the host name, port number and database. I was able to successfully connect to it using Java with the IBM JDK version 1.8 and the Db2 Universal JDBC driver. Now that I…
Rahul Khimasia
  • 473
  • 12
  • 24
0
votes
3 answers

Getting logs from IBM Z/OS

I am new to Mainframe concepts and haven't used any IBM Z-series machines before. But now I need to get db2 logs from the Z/OS platform. I previously collected logs from IBM AS400 using JT400.jar.(will execute remote command and read the output…
Selva
  • 25
  • 6
1 2 3
…
11 12