Bloggers

Ember Crooks
Ember Crooks
544 posts
Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake. Ember lives in Denver and work from home
View Posts →
Michael Krafick
Michael Krafick
32 posts
Michael Krafick is an aspiring Zamboni driver and well known twig-eater. During the day he is a Sr. Database Engineer for a Fortune 500 company. He is a frequent contributor to datageek.blog, an IBM champion, member of the DB2 Technical Advisory Board, and IDUG speaker Hall of Fame inductee. With over 18 years experience in DB2 for LUW, Mike works hard to educate and mentor others.

View Posts →
Ian Bjorhovde
Ian Bjorhovde
8 posts
Ian Bjorhovde is the Lead Db2 DBA and Delivery Manager for XTIVIA, and is based in Phoenix, Arizona. He has spent over 20 years as a consultant developing and supporting large and small Db2 databases for clients in many different industries. Ian is an IBM Gold Consultant and IBM Champion. He volunteers for the International DB2 Users Group and holds numerous DB2 certifications, and has presented at many RUG, IDUG and IBM conferences around the world.
View Posts →
José Barón
José Barón
6 posts
José Raúl Barón Rodríguez has been an IT professional for over 25 years, starting with DB2 for IBM's mainframe VM systems (later known as z/VM). He was then involved in the migration from DB2/VM to DB2 LUW on z/Linux (Linux as a virtual machine under z/VM), as well as its integration and automation tasks. José was also involved in Oracle to DB2 migration project in 2011-2012. An occasional contributor to SPDUG (Spain's DB2 User's Group), he has been supporting the different DB2 releases ever since (8.2 up to current).
View Posts →
Luke Numrych
Luke Numrych
5 posts
Luke Numrych has been employed in various IT fields ranging from mainframe operations to software development since 1995. He has been involved in supporting DB2 LUW on Windows since the beginning of 2011, transitioning fully to a production support DBA for DB2 databases in an OLTP environment in March of 2012. Currently Luke is a Senior DB Engineer for a company in the Financial Services sector.
Luke is a member and, since 2015, Secretary of the Wisconsin DB2 Users’ Group.
View Posts →
Abhik Roy
Abhik Roy
3 posts
Abhik Roy is currently associated with Experian. He has over 10 years of consulting experience in the database technology space with strong focus of big data technologies and parallel processing architectures. His current assignments involve DB2 on distributed, Netezza and Mongo and he is passionate about anything related to databases. He also has a passion for photography and loves experimenting with his camera.
View Posts →
Jonathan Gnagy
Jonathan Gnagy
2 posts
Jonathan Gnagy is an infrastructure architect and engineer with a diverse IT career. His focus is on cloud technologies and building modern web services. Jonathan has a love for all things open-source, for the Ruby programming language, and is a math and science nerd through and through. You'll typically find him blogging at https://therubyist.org but he might make guest appearances here from time to time.
View Posts →
Pavan Kristipati
Pavan Kristipati
2 posts
Pavan Kristipati’s work experience includes database consulting engagements at Fortune Finance / Health care / Insurance clients. He currently works full time as a Sr. Database Engineer and is an IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, UNIX and Windows. In his current role, he manages and supports a large multi-terabyte Enterprise Data Warehouse (EDW) on DB2 LUW DPF (Database Partitioning Feature) and Highly Available (24/7) OLTP (DB2 / HADR) databases. He was selected into “Top 10 User Speakers” at the 2014 IDUG Technical Conference in Phoenix, AZ.
View Posts →
Suresh Sane
Suresh Sane
1 posts
Suresh Sane works as Director Enterprise Data Services for Southeastern Grocers (parent company of Winn-Dixie, Bi-Lo, Harveys and Fresco y Mas supermarkets) in Jacksonville FL. He is an IDUG Hall of Fame speaker with 5 Best User Speaker awards. He has lectured worldwide and co-authored 4 IBM Redbooks (Dynamic SQL, Stored Procedures, Data Integrity and Db2 Packages). He was the Conference Chair for IDUG NA 2008 and also served on the IDUG Board of Directors.
View Posts →
Jim Reutener
Jim Reutener
1 posts
Jim Reutener has been an IT professional for 25 years. Starting out as a mainframe COBOL Programmer, then a SQL/DS DBA, moving to DB2 z/OS Database Administrator and now for the last 8 years as a DB2 LUW Database Administrator. He has IT experience with public utilities, state taxation, banking and most recently in the fast-paced retail space. He has been supporting DB2 LUW running behind WebSphere Commerce for the last 4 years.
View Posts →

2 Comments

  1. Dear Colleagues, I’m in big trouble for the unexpected SQL1042C in my shop DB2 LUW V11.1 running on CentOS 6.
    My analysis is shortly described by these sentences:
    S1
    [db2inst1@db2 ~]$ db2 “create stogroup SG_4 on ‘/data/new_path1’,’/data5/new_path2′”
    DB20000I The SQL command completed successfully.
    S2
    db2inst1@db2 ~]$ db2pd -d DBPRE -storagegroups
    Database Member 0 — Database DBPRE — Active — Up 0 days 01:26:45 — Date 2018-06-28-18.39.25.396340
    Storage Group Configuration:
    Address SGID Default DataTag Name
    0x00007FA597840D60 0 Yes 0 IBMSTOGROUP
    0x00007FA5A6052000 2 No 0 SG_4
    Storage Group Statistics:
    Address SGID State Numpaths NumDropPen
    0x00007FA597840D60 0 0x00000000 2 0
    0x00007FA5A6052000 2 0x00000000 2 0
    Storage Group Paths:
    Address SGID PathID PathState PathName
    0x00007FA597874000 0 0 InUse /home/db2inst1
    0x00007FA597872000 0 1 InUse /data/sg2
    0x00007FA5A6053000 2 2048 NotInUse /data/new_path1
    0x00007FA5A561A000 2 2049 NotInUse /data5/new_path2
    Some days working without any negative behavior, therefore we decided to replicate in production (without backup, else too simple) and withot following “https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.sec.doc/doc/c0050516.html” (else too easy).
    Therefore we assume that the reason of SQL1042C be clear (but not 100% sure). Any way, the problem is to recover data, of course. Could you please try to help us before being hanged ?
    Thanks and regards, carlo

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.