Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [db2-zos]

Use this tag for questions related to DB2 for the IBM z/OS mainframe platform. Also add the generic "db2" tag.

17 questions
5
votes
2 answers

DB2 developers can't create table in own schema but SQL and Oracle devs can. Justified?

As a developer new to DB2, I was surprised when I discovered that I could not create my own tables in the development database environment. So, I posed a question to the db2 DBA. I don’t want to be too much of a nuisance by questioning policy and…
Ivan
  • 211
  • 2
  • 8
4
votes
3 answers

Can I optimize for the zIIP processor?

Is it possible to change SQL in a z/OS mainframe COBOL application so that it becomes eligible to be directed to the IBM System z Integrated Information Processor (zIIP)?
GilShalit
  • 143
  • 5
2
votes
1 answer

DB2 zOS increasing DSSIZE vs adding partition?

I'm trying to load data into a DB2 table. The tablespace has 3 partitions with about 60M,60M,70M rows. The 3rd partition is failing to load. It gives me a warning that loading this partition's dataset will exceed the maximum size of # pages. The…
Kyle
  • 53
  • 1
  • 4
1
vote
1 answer

How can I create DB2 objects with Linux SUDOer authority?

All, I am relatively new to Red hat linux and I have SUDOer authority but unable to create DB2 database or other objects. How can I accomplish this task? Please give examples. Also, is there any known freeware or trial tool for converting mainframe…
user34920
  • 11
  • 2
1
vote
1 answer

db2 cross platform function/variable?

Is there a db2 function/procedure/variable that can be used to determine what platform a data source origins from? sysibm.sysdummy1 exists, so I assume that this is Db2, but some of the SQL does not look right according to LUW syntax. Is there an…
Lennart - Slava Ukraini
  • 23,842
  • 3
  • 34
  • 72
1
vote
1 answer

DB2: Why does translate function also replace spaces?

I would like to remove control characters (HEX \x00 until \x7F) from a DB2 data base field. For this I tried to apply the following translate-function: TRANSLATE(field, 'X', x'000102030405060708090A0B0C0D0E0F101112131415161718191A1B1C1D1E1F') It…
user3193317
  • 149
  • 1
  • 3
  • 7
1
vote
1 answer

Possible to have duplicate fully qualified schema names with separate data in DB2 for z/OS?

We have several application teams that are looking to do a re-write of large legacy applications. This is mostly COBOL going against DB2 for z/OS (v11). The COBOL code was generated using a tool, so we don't have any access to the source. Let's say…
Burke9077
  • 135
  • 7
1
vote
1 answer

Named Parameter Markers in DB2 for z/OS

I have a query where I will be using the same value twice for one of the parameters. This query will be run under IBM Data Studio to see the results. Below is a sample query: SELECT * FROM SYSADM.STATISTICAL_TABLE S WHERE S.END_RECORD_TIMESTAMP…
Burke9077
  • 135
  • 7
0
votes
0 answers

How can you check if DB/2 trigger fired due to table insert/update that is part of multi-table transaction?

I have scenarios where Table A and Table B can be updated as part of a single transaction or Table B can be updated on its own. I have a trigger on Table A for when there is an update on Table A and Table B as part of a single transaction. I have a…
Cocoanut
  • 101
0
votes
1 answer

Reorg SYSIBM tables to reduce extents (XT) - change priqty & secQTY

I have a new DB2 V12 database on z/OS 2.4 z13, with hundreds of programs to rebind, such as: sysibm.syspackage, sys.columns, sys.tables, etc. These will grow, hence the need to reorganize the tablespace for performance. Maintenance window is one…
TechnoCaveman
  • 1
  • 1
0
votes
1 answer

How to identify row change timestamp columns in Db2 Table

I need to copy some Db2 tables programmatically (java 11 using the standard Db2 jdbc driver). The tables in question lie on a Db2 for z/OS database (v12) and on a Db2 LUW database (v11.1). The target tables exist and have all the required…
Achim Schmitz
  • 141
  • 1
  • 1
  • 5
0
votes
0 answers

DB2 - Is there a way to get the list of tables a particular transaction has affected?

We have a scenario where we would like to see if we could get hold of a list of tables affected by a given transaction. We use attunity to listen on the transaction log, but what I get from attunity is the transaction ID associated to a given event…
Nilay Sundarkar
  • 101
  • 1
0
votes
2 answers

DB2 multiple rows with the same value

This is my first time posting in stackexchange, and I hope I did my due diligence for this question. I'm working on a problem that I just can't seem to wrap my head around. Consider this scenario of a chain of electronics stores, where day-to-day…
Walcuray
  • 3
  • 1
0
votes
1 answer

DB2 Workfile scan

We just migrate from LUW to zos and we're finding that in z/os the accesspath explains show new node named WFSCAN (Workfile scan) and this rises when there is a join, group by or any kind of sort. The question is, Is any performance issue with…
Hana Bzh
  • 101
  • 2
0
votes
1 answer

DDL for PostgreSQL for DB2 tables (migration)

How would I create the DDL for PostgreSQL for the following DB2 tables? It should be a one-to-one migration, so I would like to change only as little as possible at the schema (I have difficulties with the BLOB/CLOB datatypes and the default…
user3193317
  • 149
  • 1
  • 3
  • 7
1
2