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.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
321 views

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 ...
0
votes
0answers
14 views

IBM DB2 z/OS - 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. The database is running on z/OS. Both tables have the same columns (and types), except one ...
0
votes
1answer
50 views

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. ...
0
votes
1answer
18 views

Using OLAP-specs to compute selective running totals

Let's say I have a table with columns id, subid, state, value, where (id, subid) is a unique tuple, state may be 0 or some value <> 0, and value is just some number. I want to build a query that ...