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

DB2-12 (Z/OS) - Create Alias for Stored Procedure

it's possible to define an alias for a stored procedure (sql-native)? In the documentation, reference is made only to: SEQUENCE and TABLES 1) CREATE PROCEDURE OWXXCOLL.STORED1() 2) CREATE ALIAS DB2C.STORED1 FOR OWXXCOLL.STORED1; 3) CALL…
killer
  • 11
  • 6
0
votes
1 answer

how to get last accessed date of a table in db2 z o/s?

The plan is to identify unused tables in db2 z o/s , is there any way we can get last accessed date of each table in db2 z o/s. [ in db2 LUW we have last_used column in syscat.tables but in db2 z o/s we dont any last used column in sysibm.systables…
maseed ilyas
  • 1
  • 1
0
votes
1 answer

sqlcode -117 - ibm mainframe

The first image is of the table. I keep getting an error saying what im trying to insert into the table is not the same as what is in the table. I The second image is where I have inserted into the table. [1]:…
Khyran Bush Student
  • 37
  • 1
  • 5
0
votes
2 answers

Difference between the use of FOR FETCH ONLY in query & ResultSet.CONCUR_READ_ONLY in JDBC statement

My application is running 200 select statements per second (like SELECT A, B, C FROM DUMMYSC.DUMMYTB, etc.). 10-15% of the queries fail with the error below: DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000304;DSNDB06…
NoCodeDefFound
  • 13
  • 6
0
votes
0 answers

IBM DB2z Database Liquibase - INFORMATION_SCHEMA.CONSTRAINTS table not found Exception

I tried to implement Liquibase for my IBM DB2 zos database and when i run liquibase:generateChangeLog command, I'm getting the following error. Error setting up or running Liquibase: liquibase.command.CommandExcecutionExceptoin:…
Dileepan
  • 123
  • 1
  • 4
  • 8
0
votes
1 answer

SQuirrel Call Stored Procedure

I am trying to call a DB2 stored procedure from Squirrel. I can call the stored procedure successfully from the DB2 command line processor. CALL PIPPOOWN.PIPPO ('04','prov','0001','provprov') I append ;retrieveMessagesFromServerOnGetMessage=true;…
killer
  • 11
  • 6
0
votes
2 answers

Differences between default fields definition

Db2 Z/OS Version 11.01 and 12. I am verifying that the structure of some tables is equal on more customers/environments. I noticed that the default value is the only aspect that differs between many tables For Example - Table "Order" Columns…
killer
  • 11
  • 6
0
votes
0 answers

Installing a new DB2 subsystem at function level 100 (z/OS)

Apologies, if this is a newb question; I'm hoping there are some DB2 gurus that may be able to shed some light on this for me. We are creating a new DB2 subsystem (on z/OS), modeling from an existing one. The existing one was migrated to DB2 12 and…
yodish
  • 733
  • 2
  • 10
  • 28
0
votes
1 answer

Is there a way to execute free Package statements using REXX?

I am able to write a REXX code that generates FREE PACKAGE statements. After generation I use that file in a JCL to execute the FREE PACKAGE statements. Is there a way to execute the FREE PACKAGE statements directly via rexx? I tried executing it…
Sudarsan Rajagopalan
  • 83
  • 8
0
votes
1 answer

CREATE TABLE LIKE in DB2 10 for z/OS throwing an error

Using DB2 for z/OS v.10, I'm getting an error when I specify a tablespace when using CREATE TABLE ... LIKE. I can successfully use CREATE TABLE ... LIKE if I don't specify a new tablespace, but it throws an error when I specify a tablespace. The…
Dave Ford
  • 341
  • 2
  • 14
0
votes
2 answers

DB2 SQL : How to get 2 rows data into 1

I am getting employee data from source which gives me 2 rows for same employee. 1st row has a salary and 2nd has commission. to identify if it is salary or commission I have got one Flag column. Now I want to store it in single row in my target…
Pratik Mehta
  • 13
  • 1
  • 5
0
votes
1 answer

DB2 z/OS - Get the last 2 digits of year

SELECT SUBSTR(CAST(YEAR(SOMEDATE) AS VARCHAR(4)),2,2) AS "YY" FROM SOMESCHEMA.FOO; Gets me the following error: [Code: -104, SQL State: 42601] ILLEGAL SYMBOL ",2". SOME SYMBOLS THAT MIGHT BE LEGAL ARE:. SQLCODE=-104, SQLSTATE=42601,…
Pwnstar
  • 2,333
  • 2
  • 29
  • 52
0
votes
0 answers

How to fix JdbcOperations Batch Update consuming a lot of time?

I am trying to update million rows of DB2 through JDBC operations batch update but I am not able to. After certain time I am getting exception DB2 SQL Error: SQLCODE=-904, SQLSTATE=57011, SQLERRMC=00C90096;(Resource unavailable) This happens when…
Ayush
  • 206
  • 7
  • 22
0
votes
0 answers

What is the definition of a Driving Cursor in SQL?

I started in a project involving Cobol and DB2 on an IBM z/OS host system. The software module documentation makes frequent references to a term called "driving cursor". Could someone explain this term, if possible in the DB2/Cobol context? I know…
user11654732
  • 11
  • 4
0
votes
0 answers

Send multiple files in connect direct ndm parallely

I want to send huge files from Unix to zos node parallely can you help how to open multiple sessions and submit the ndm script any example code will be helpful to me Is parallel transfer possible from Unix(node A) to mainframes (node B)
Hari
  • 1
1 2 3
…
11 12