[Skip to Content]
Fresche Quadrant Software BCD Software SoftBase NetLert

Posts Tagged ‘DB2 for z/OS’

SoftBase attending Regional Db2 Users Group meetings in September, 2019

All Baseline Posts, Webinars

SoftBase will be represented at these Regional Db2 Users Group meetings:

St. Louis (STLDUG), September 10, 2019
Wisconsin (WDUG), September 11, 2019
Midwest (MWDUG), September 19, 2019

SoftBase sponsored lunch at the Central Ohio DB2 Usergroup Meeting December 4, 2018

All Baseline Posts, Webinars

SoftBase sponsored lunch at the Central Ohio DB2 Usergroup Meeting December 4, 2018.

See the presentation on the SoftBase products


DB2 z/OS Development Webinar: SQLCODE -911 – Now What?

All Baseline Posts, Webinars

WEBINAR: SQLCODE -911 – Now What?

Thursday, December 14 2017 2:00PM-3:00PM Eastern

Register here

The Deadlock timeout, or Db2 z/OS sqlcode -911, is a problem that Db2 developers, as well as operations and production personnel, frequently encounter. It happens when a job attempts to access a resource, such as a row, page, table, or index that is locked by another job.

Identifying the ‘participant’ job holding the lock is critical for the developer trying to diagnose the problem. Developers often don’t even know that they caused an issue for the ‘victim’ job receiving the -911. Unfortunately, this can be difficult and sometimes impossible to identify without help from a DBA or someone with higher permissions. Left unresolved, the issue can cause serious production performance degradation.

Join SoftBase’s z/OS Db2 expert Neal Lozins for a webinar on December 14th at 2PM Eastern to:

• Learn common causes of SQLCODE -911
• Understand why troubleshooting -911 is challenging
• Review manual techniques for identifying -911 error source
• Discover automated tools that can help you quickly resolve -911

Neal will also show you a live demo where you’ll learn how to quickly diagnose a -911 code with SoftBase’s Db2 DeadLock Advisor and Db2 Catalog Guide.


Register now


Test like you mean it! Shorten DB2 z/OS development time by increasing testing.

All Baseline Posts, Application Testing, Webinars

WEBINAR: Test like you mean it! Shorten DB2 z/OS development time by increasing testing.
DATE: | Watch the recorded webinar here

Application Development and QA Management often find themselves caught between the need for applications to meet rigorous quality standards and the ever-increasing pressure to get new code into production as fast as possible. In many cases, the development process becomes bottle-necked by testing requirements.

TestBase, SoftBase’s test data management solution for z/OS, both accelerates application development and helps your code meet high quality standards by empowering developers to test faster and more thoroughly than ever.

Join us for this free webinar for a brief webinar where you’ll learn how TestBase can help you improve your application development and QA process:
• Test faster with referentially intact subsets of data instead of full production data
• Test more completely by establishing and reusing important test cases
• Test concurrently and independently with individually managed test areas of the same database

Even if you can’t attend the live event, sign up anyway, and you’ll receive a link to the recording. We look forward to seeing you there!


Learn more about TestBase or contact us.

DB2 z/OS Development Webinar: Better Testing = More Testing

All Baseline Posts, Application Testing, Webinars

WEBINAR: DB2 z/OS Development: Better Testing = More Testing
Watch the replay here

Is your DB2 application development process bottle-necked by testing? Does the quality of your application suffer because there is insufficient testing?

Driven by cost constraints and expectations of instant gratification, DB2 shops have less time than ever to get new code into production, yet applications should still pass rigorous QA standards.

TestBase, SoftBase’s test data management solution for z/OS allows you to meet these contradictory goals. It accelerates and improves DB2 z/OS application development and implementation by empowering developers to perform tests faster and more thoroughly and by consolidating the test data management processes.

Watch this recorded webinar where DB2 expert Neal Lozins will show you how TestBase can help you:

TEST FASTER with referentially intact subsets of data instead of full production data

  • Reduce test load, setup and run time by using less data
  • Use less disk space and avoid fighting for DASD acquisition
  • Perform iterative tests and verify results quickly and easily
  • Do more testing with fast and simple setup and verification

TEST MORE EFFICIENTLY by establishing and reusing important test cases

  • Store, find and quickly retrieve test cases using TestBase’s documented test case inventory
  • Ensure test cases are retained, even if table changes occur, with automatic data conversion

TEST CONCURRENTLY & INDEPENDENTLY with individually managed test areas of the same database

  • Execute multiple tests against the same database at the same time without interference
  • Empower users to load test cases to their own test region and test at any time
  • Remove hesitance to share test data by making it repayable on demand

Watch now

Learn more about TestBase or contact us.

Webinar Replay: 6-Steps to Determining if DB2 Multi-Row Fetch is Right for Your Shop

All Baseline Posts, Baseline Videos, Webinars

We had  a great turnout yesterday for our webinar 6-Steps to Determining if DB2 Multi-Row Fetch is Right for Your Shop. Scott did an excellent job explaining how to identify the programs and cursors with the highest potential savings from MRF and how to calculate the overall potential CPU savings from implementing MRF. Our DB2 Tech panel also did a terrific job answering attendee questions during the Q&A session.

Watch the video replay of the presentation below. The actual presentation ends at about the 18:50 mark, the remainder of the video includes the detailed Q&A session with our DB2 tech panel. Enjoy!

DB2 Parallel Development and Testing – Made Easy

All Baseline Posts, Baseline Videos, Webinars

Watch the video below and learn how to:

  • consolidate your test environment into a single database in a single subsystem,
  • realize faster application time-to-completion and higher developer productivity,
  • overcome typical challenges of parallel and single-threaded testing, and
  • improve ROI on your existing test data management tools.

The Slice tool can be installed in less than a day. Learn more about it here.

Craig Mullins’ Webinar September – DB2 10 for z/OS features that most impact developers

All Baseline Posts, Baseline Videos, Webinars

Last September, SoftBase and IDUG sponsored a webinar featuring Craig Mullins discussing upgrading to DB2 version 10 and the impact on developers.  You can watch the video below!


Here’s the video replay of Craig’s presentation:


Here’s Craig discussing how to best prepare your applications for the upgrade, and how to test them afterward:


Contact us for more information about our products!

Interesting article: DB2 for z/OS Version Migration – Top 10 Issues

All Baseline Posts

Lockwood Lyon’s article on DB2 for z/OS version migration, posted on Database Journal here, gives pragmatic instructions on DB2 10 migration. With DB2 version 8 scheduled to be out of service at theend of April this year, many shops are looking to upgrade directly to DB2 version 10. Lockwood lists the following 10 items as the most important migration issues:

10 – Technical Training
9 – New Version Feature Exploitation
8 – New Version Features: Not Right Now but Eventually
7 – DB2 Version Migration Metric
6 – Access Path Backup
5 – Current System Health Check
4 – Third-party Software Products Review
3 – New Version Performance Measurement Metrics
2 – Disaster Recovery Process Update
1 – Implement Best Practices

You can read his full article, posted on Database Journal, here.

SoftBase is no stranger to DB2 version 10 migration issues. In fact, last September we asked Craig Mullins to host a webcast discussing DB2 version 10 migration considerations. You can watch the recorded webinar and download the presentation PDF on our website for free, click here!

Teaching new developers old tricks: the mainframe is here to stay

All Baseline Posts

Roger Kay’s article on Forbes.com, Kids See A Future In Mainframes, is a refreshing reminder that mainframes are here to stay. The fact that education systems are starting to see a demand for mainframe skills is not surprising The majority of mainframe programmers are reaching retirement age, and mainframe programming hasn’t been taught in most universities in over a decade.  According to a recent Compuware survey of 520 CIOs in large enterprises, 71 percent said that they are concerned that this skills gap will hurt business.

For years, IT pundits have been rebuking the notion that mainframes are on the way out. And rightly so. Distributed computing simply can’t provide the same combination of computing power, up-time, security and simplicity of the mainframe. Even if they could, the cost of migrating critical applications is usually cost prohibitive. I think it’s great that educational systems are starting to recognize this!

In fact, if a developer wants job security, they should consider learning a mainframe language such as COBOL. This ‘ancient’ language is anything but extinct -it’s estimated that COBOL transactions make up 60 to 80 percent of all worldwide business transactions. And as cloud computing continues to grow in popularity, many organizations need developers who can bridge the gap between the mainframe and distributed worlds, providing even further evidence for the need for mainframe education.

Speaking a well-rounded combination of distributed and mainframe languages could mean long-term job security. By this, I don’t mean that most organizations are looking to replace their mission critical mainframe applications with a distributed alternative – the costs are simply too high in most cases, and most organizations want to preserve their original investments. But many organizations are beginning to treat mainframes as a centralized ‘hub’, to which distributed systems can connect and compliment.

All of this is good news for companies who work in the mainframe world, such as SoftBase! We knew that the mainframe isn’t going anywhere! We applaud the education institutions that are bringing mainframe curriculum back.  What do you think?