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

Error in CREATE TYPE statement in DB2 for z/OS

i tried create an associative array with integer indexes CREATE TYPE assocArray AS VARCHAR(1000) ARRAY[INTEGER]; And DB2 returns me this: ILLEGAL SYMBOL 'ARRAY'. SOME SYMBOLS THAT MIGHT BE LEGAL ARE: CHECK UNIQUE NOT PRIMARY AS UPDATE IMPLICITY…
Bopinko
  • 15
  • 1
  • 8
0
votes
0 answers

Removal of Identical Duplicates in the DB2 ZOS 11

I have a question. We have a huge table where unfortunately duplicates have been loaded. We had dropped the Indexes and Constraints for loading History data and Team have inadvertently reloaded already loaded data on failure without doing proper…
Kalaiselvan Shanmugam
  • 1
0
votes
0 answers

Secure Gateway to DB2 zOS - Bluemix - SQL1598N

I have an issue with an error SQL1598N, between Bluemix and a Secure Gateway to access DB2 z/Os with PHP. The gateway client is Windows and is running on my system. I have a license type "Client Device" for a product "db2conpe". Thanks for your help
Daniel LORENZO
  • 1
0
votes
1 answer

Oracle slow to join local table to DB2 Mainframe

This one is puzzling me. Pulling from the DB2 by itself is fast, and pulling from the table is fast, but I don't know why they don't play nicely together. I don't have access to the indices of the DB2 table or the server there. This query takes…
Clint
  • 51
  • 4
0
votes
2 answers

SHA256 in mainframe. Is function exist in REXX?

I investigated a problem to encrypt string unsing rexx (mainframe ZOS). I found some useful links: http://rexxeec.sourceforge.net/doc/RexxEEC.pdf But when I tried to use it in TSO, I got an error: **16 +++ hash = eecsha( str )** My…
Andrei Kaliachka
  • 35
  • 1
  • 12
0
votes
3 answers

Export CSV from Mainframe DB2 in batch mode

how can I export in a CSV file the result of a SELECT query from Mainframe DB2 in Batch mode? I have tried the FILE MANAGER online mode and it works but I need to use the batch mode for a better performance. I can also use ISQL but I don't know…
Nello
  • 11
  • 1
  • 4
0
votes
1 answer

DB2 ZOS Mainframe- Archive Logs Disable

I'm working in DB2 ZOS Version 10, I have been working under data masking project. For this project I have been executing over 100k DDL statements (delete, update,insert) . So I need to do disable the transaction logs before the whole SCRAMBLE…
Vivek Harry
  • 419
  • 3
  • 11
  • 25
0
votes
1 answer

Need help to understand locking behaviour observed during DELETE in DB2 on z/OS

Examining the behaviour of two transactions launched from two DbVisualizer instances pointing at an instance of DB2 database on z/OS, I have noticed the following behaviour during deletion of records from tables. Suppose I have a table MYTABLE with…
John Donn
  • 1,718
  • 2
  • 19
  • 45
0
votes
0 answers

Can one delete statement which deletes multiple rows cause deadlock?

We work with DB2 effective version 8 (more or less, so no CUR_COMMIT) on z/OS. In our (Java based, though this should not be relevant) application a method exists which runs in a transaction and deletes multiple records from a table called, say,…
John Donn
  • 1,718
  • 2
  • 19
  • 45
0
votes
0 answers

Generating XML and writing to file system from DB2

I need suggestion/best approach to address the below problem: On insertion of a new record into a DB2 table, a file needs to be generated and stored remotely on real time Env. DB2/zOS
sahaS
  • 41
  • 1
  • 5
0
votes
2 answers

Table scan matching one of a number of fields - OR vs multiple statements

I'm facing having to write a number of queries which will involve table scans on some fairly large tables (couple of million records). (I know this is a terrible idea and I'm pushing for an alternative approach that won't involve this, but right…
Mick O'Hea
  • 1,619
  • 2
  • 14
  • 20
0
votes
1 answer

How to invoke json_val function in db2 json?

I'm trying to index a particular value from stored DB2 nosql, for that I'm using json_val but I need to invoke UDF SYSTOOLS.BSON2JSON to the json_val and need to point the table from where I required data. SELECT…
Dhinesh Pazanisamy
  • 45
  • 1
  • 6
0
votes
0 answers

DB2-JSON facing -440 sql error while using JSON_VAL for indexing

i'm ok with insertion and selecting, but when i'm trying to retrieve particular document from table while using JSON_VAL index, i'm facing error with sql code -440.
Dhinesh Pazanisamy
  • 45
  • 1
  • 6
0
votes
2 answers

UDF on DB2 11.0

I was asked to build a user defined function on our Mainframe environment that checks for a search string in a longer string. The only catch is that if we search for example for 'AA' in 'ABCAADAA' the only valid result is the last AA because the…
Crosswind
  • 940
  • 1
  • 10
  • 26
0
votes
3 answers

Java in CICS - Type 2 JDBC Connection giving error SQLCODE = -922, SQLSTATE = 42505, error tokens = PLAN ACCESS;00F30034

In Java code while trying to get the connection using Type 2 Driver. String jdbcUrl = "jdbc:default:connection"; Connection connection = DriverManager.getConnection(jdbcURL); I am getting the below…
kushwah_a
  • 135
  • 2
  • 9
1 2 3
…
11 12