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.
Questions tagged [db2-zos]
175 questions
0
votes
2 answers
Db2 z/OS alternative for ROUTINE_SCHEMA or ROUTINE_SPECIFIC_NAME global variables of Db2 LUW
ROUTINE_SCHEMA or ROUTNE_SPECIFIC_NAME global variables in Db2 LUW can be used to retrieve the schema name or specific name of the currently executing routine.
Is there an alternative for one of them in Db2 z/OS (where both global variables do not…
the.unknowing
- 87
- 11
0
votes
1 answer
Database locking in Spring Batch
I'm working on a Spring Batch application that was running into a DB2 deadlock while using a default JdbcCursorItemReader. When the batch job ran into an error, we had set up a SkipListener to write an "Error" status to the relevant row, which is…
KAM1KAZEKOALA
- 115
- 1
- 2
- 6
0
votes
1 answer
Optional parameters in named query in EclipseLink
I am new to JPA named queries using EclipseLink and I want to "ignore" properties with null values in named query. I know that my question has been answered many times.
e.g. JPA Query to handle NULL parameter value
However, in my case following…
Atul Kumbhar
- 1,073
- 16
- 26
0
votes
0 answers
Timeout - Clone and Base table
Procedure of my mainframe job has a step which performs an exchange between clone and base table. This step fails every time the job runs with resource unavailable error. The resource is a package for another program which reads the base table used…
Sanyo Alexis
- 11
- 4
0
votes
1 answer
Is it possible to read Data Definition from java stored procedure under DB2?
Hy all,
this is my first question on stackoverflow, so let me know if something is wrong.
Howerver, I need to know if is it possible to read a dataset, defined with a DD name declared in a COBOL program, from a Java Stored Procedure under DB2.
The…
Fedox
- 11
- 1
0
votes
0 answers
Migrating DB2 Blob/Rowid data types to PostgreSQL
How would I create the following DB2 table in PostgreSQL?
CREATE TABLE table1 (
idDoc DECIMAL(15) NOT NULL,
rowId ROWID NOT NULL,
checksumDoc DECIMAL(15) NOT NULL,
doc BLOB NOT NULL,
…
user3193317
- 131
- 3
- 14
0
votes
1 answer
column definition for varchar(n) CHAR in DB2 z/OS using UTF-8?
I'm looking for a way to define a column for holding an UTF-8 String with a maximum length of n characters (not bytes) in DB2 for z/OS.
To my knowledge code_units are available only in DB2 LUW.
Easy
- 1
- 1
0
votes
1 answer
Does DBeaver support IDAA query acceleration?
I'm currently using SQuirrel SQL for queries on DB2 with query acceleration turned on (IBM IDAA).
I found DBeaver recently and I really like it and love it.
I tried to execute a query on DB2 with it, but I don't think it supports query acceleration.…
Rumplin
- 2,703
- 21
- 45
0
votes
0 answers
Kafka connect source connector is not working with db2
When I run kafka connect source connector on MySQL everything runs fine, I'm working with the timestamp strategy, the problem comes when I try to do it with a different database, in my case I'm trying to get the information from a db2 table, when I…
Alejandro Agapito Bautista
- 1,344
- 1
- 15
- 35
0
votes
0 answers
question marks instead of text in excel export from DB2 via SQL Developer
Does anyone do exports to excel from DB2 via SQL developer? I have a field in my table which doesn't get exported right, but comes full of question marks instead. All the other fields are fine. This field doesn't contain anything special, just…
latimeria
- 1
- 2
0
votes
1 answer
Where to place Z/OS license file when push Cloud Foundry PHP app to Bluemix?
I would like to connect from Bluemix to Z/OS system, using SecureGatway, but I don't have a Z/OS license file (most probably: db2consv_zs.lic file). I receive SQLSTATE=42968. The SG tunel looks okay.
If I get the license.. where do I have to…
Andr
- 88
- 1
- 10
0
votes
0 answers
PHP - DB2 license file location
I'm running an XAMPP server for my PHP app and I would like to connect to a zOS DB2 table. I receive license error. I can connect a non-zOS DB2 DB so DB2 functions work. The error message I receive is:
An attempt to connect to the database server…
Andr
- 88
- 1
- 10
0
votes
2 answers
Connecting to IBM zOS system/DB2 table with a PHP Cloud Foundry app
Is it possible to connect from w3ibm.bluemix/PHP Cloud Foundry app to a bluezone zOS system and it's DB2 table?
I already connecting to a DB2 table on w3ibm.bluemix (using a db2 service and having a table there). It worked, but now I would like to…
Andr
- 88
- 1
- 10
0
votes
0 answers
DB2 "Error in converting column name from JString to CString"
We are setting up the federation in order to browse data from ADABAS using DB2 federation. We have a Classic Data Architect connection set up and a remote server in DB2 federation configured using JDBC. The problem is that when we try to create a…
Matioski
- 117
- 1
- 2
- 11
0
votes
1 answer
How to reflect changes made to a cobol DB2 stored procedure?
I'm getting a -805 when trying to run the changed stored procedure. The bind process that is done is: stop stored procedure, compile and bind stored proc, start stored procedure, refresh wlm area.
I still get a -805. I've tried displaying some…
Tonan
- 147
- 1
- 1
- 9