[AD] [Db2 for z/OS V12] DSNU3350I

Phil Grainger

[AD] [Db2 for z/OS V12] DSNU3350I
It’s Friday, so I couldn’t less this pass by without mentioning that a reorg that doesn’t require an external sort wouldn’t have had this problem in the first place ☺

Happy Friday everyone

________________________________

Phil Grainger

Lead Product Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: 11 August 2017 11:38
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - [Db2 for z/OS V12] DSNU3350I

Hi folks,

I do have a problem understanding the DSNU3350Imessage.

The particular part of the message message I’m referring to runs as follows:

DSNU3350I SORT TASK SW07: 8835326 RECORDS SORTED, ESTIMATED 3885555

If I look at the quick reference my understanding is that almost 9 million rows were sorted whereas the load expected to sort about half the amount.
This expectation is apparently based on RTS.

But … RTS for this particular table shows 8835K rows, so someone is not giving me the right picture.

The reason for asking is that one load job abended because of a miscalculation of the necessary sortworks, the trouble is I don’t have the output handy anymore, but I still remember it was due to some sort-space problem. The abend may or may not have been related to that miscalculation, but while investigating the matter I stumbled about the discrepancy of figures in that message.

What am I reading wrong? Is it my misinterpreting the message? Any help is appreciated.

Have a great weekend

Best regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (8k)
  • image002.png (5.9k)