z/OS is an operating system for mainframes, by IBM.

learn more… | top users | synonyms

0
votes
0answers
55 views

MATERIALIZED QUERY TABLE on DB2 Z/os V10

I have return MQT on DB2 LUW and it is working fine and if the same is Executed on DB2 on Z/OS V10 . IT fail's with below error . Can some one help in on the problem. ERROR : "THE FULLSELECT ...
1
vote
1answer
24 views

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

Export to csv using db2 v10 for z/os

in db2-luw, I can create a csv using the export command. However, running the same command in z/os results in: SQL1325N The remote database environment does not support the command or one of ...
2
votes
2answers
4k views

Do I need to RUNSTATS after a REORG in DB2?

The REORG documentation says: BUILD Builds indexes. Updates index statistics. But I have always heard REORG/RUNSTATS as if they should be paired. Can anyone verify that "Updates index ...
4
votes
2answers
390 views

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)?