We’re rewarding the question askers & reputations are being recalculated! Read more.

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.

3 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
311 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
1answer
43 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 ...