June 2016 Blog Posts (2)

Really, We're All Experts Here

Hello Everyone,

I hope you take the time to read this posting and then realize you too are an expert and I'm looking forward to learning from you.

http://bit.ly/28TI7fN

Added by Troy Coleman on June 25, 2016 at 1:49 — No Comments

Common DB2 for z/OS RUNSTATS collection mistakes

The DB2 optimizer exploits the catalog information to choose an access path for a given SQL statement, and RUNSTATS is what populates the catalog. It is important therefore to collect a good base of statistics to give the optimizer a fighting chance of choosing well-performing access paths for your SQL.

Here we will discuss some common mistakes that are made when running RUNSTATS.…

Continue

Added by Terry Purcell on June 13, 2016 at 15:58 — 8 Comments

Monthly Archives

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

z/OS DB2 V11 to V12 and CICS?

Started by Tom Burkholder in What's hot ? on Friday. 0 Replies

Hello DB2 users...I apologize in advance if this is not the place to post this question; however, I thought I would sign up and give it a try.  My background is with systems support and middleware (z/OS, MQ, WebSphere, distributed DB2 jdbc configs)…Continue

Db2 LUW 11.1 - GET_LINE procedure - NO_DATA_FOUND exception SQLSTATE

Started by Gagan Kakkar in Application Development and DB2. Last reply by Douglas J. Partch, Jr. Jan 6. 1 Reply

Hi there,I am testing this stored procedure using Db2 11.1 on Windows 10 64-bit.Informational tokens are "DB2 v11.1.4050.859", "s1911120100","DYN1911120100WIN64", and Fix Pack "5".For NO_DATA_FOUND exception I am getting SQLSTATE = 'ORANF' but in…Continue

Tags: modules, Built-in, LUW, Db2

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service