SoftBase announces a free download of the TestBase SQLCODE -805 Tool which helps identify the source of Db2 SQLCODE -805 on z/OS. Please see https://www.softbase.com/testbase_sqlcode_805_tool.php to get your copy today!
Tags: Application Development, Application Performance, Application Testing, Archiving, TestBase
TestBase 6.1 further improves performance and Db2v12 support.
New features in TestBase 6.1 include:
- Pre-Compiled with Db2V11 and Db2V12
- Testbase divided into 7 different components that can be licensed separately ( * New Components)
Db2 Mask – Mandatory masking of sensitive Db2 data and files
Db2 Subset – Subset, generate data in Db2 data and files
Db2 Edit – Edit/View data in Db2 tables and views
Db2 Slice – Test together or independently within one set of tables and tools to unload and load data
* Db2 Query Build – Build complex SQL statements easily
* Db2 SQL Debug – Executes and explains SQL in Source Programs
* Db2 Catalog Guide – View Db2 catalog objects and their relationships like ISPF option 3.4
- Db2 Slice and Db2 Subset can now use Db2 Utilities to load and unload
- TestBase display commands for use anywhere in the product:
Option ==> RS (release summary display)
Option ==> LI (component & license status display)
Option ==> LIMIT (panel to reset volume limit)
- TestBase uses Enterprise COBOL for z/OS®, V5.2
As TestBase continually strives for better performance, items 1,3,4, and 5 deliver just that.
Interested in TestBase?
Click here to learn more about TestBase or contact us by clicking here or calling 800-669-7076.
Tags: Application Development, Application Performance, Application Testing, Archiving, TestBase
TestBase 5.2 further improves test data management with Enterprise COBOL optimization, improved data privacy features, and DB2v11 support.
TestBase helps DB2 shops test new database applications faster and with fewer resources, reducing both time to market and overall development costs. The newest version, 5.2, includes several features that enable faster extraction and manipulation of test data by through Enterprise COBOL optimization, in addition to performance enhancements inherent in DB2v11. Enhanced data management features enable users to extract a subset from an existing subset, in addition to being able to mask data by replacing the target data with data from a different source.
New features in TestBase 5.2 include:
- Pre-Compiled with DB2V11 and DB2V10
- V5.1 with highest level of optimization which seems to yield about a 10% performance enhancement resulting in faster file extracts, data masking and load
- TestBase Privatize and Populate option now provides the ability to extract from an existing subset of slice data
- TestBase Mandatory Masking (Data Privacy) now allows users to replace the object being masked with a different source (table, view, TestBase view, etc.)
- TestBase Slice – Lock table process allows for the removal of statements from a source library
- Some TestBase install tables add keyword VOLATILE to protect against inadvertent RUNSTATs
- TestBase file compare – Option added to eliminate tables that match from the report
Click here to view the full release summary.
Interested in TestBase?
Click here to learn more about TestBase or contact us by clicking here or calling 800-669-7076.
Tags: Application Development, Application Performance, Application Testing, Archiving, TestBase
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.
Tags: DB2 for z/OS, Test Data Management, TestBase
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
Learn more about TestBase or contact us.
Tags: DB2 for z/OS, Test Data Management, TestBase
One of our TestBase customers, a very large Federal Agency, recently broke what we think must be a world record for fastest RI DB2 test data extraction and subsetting live DB2 production data. Listen to the 6-minute podcast below to learn how this company was able to:
- Extract a 100,000 row subset of Referentially Intact (RI) DB2 data (to be used for testing) from a 300M+ row database of live customer production data in UNDER 2 Minutes
- Took advantage of several clever DB2 features to help facilitate this extremely fast transfer, including
- Multi-Row Fetch
- Multi-Row Inserts
- Global Temporary Tables
- Key Value Assignments
[audio:https://www.softbase.com/blog/wp-content/uploads/2013/08/TestBase-Populator-Success.mp3|titles=TestBase Populator Success]
(If you the audio player gives an error, reload the page by clicking here: https://www.softbase.com/blog/?p=615)
Not mentioned in the audio above, the same customer was also able to create a similar extract of 25M rows of RI DB2 test data from the same live production database in under 40 minutes – quite an impressive feat.
Click here to learn more about TestBase or feel free to contact us here.
Tags: Application Testing, data extract, test data, TestBase
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.
[stream provider=video flv=https://s3.amazonaws.com/SoftBase/parallel-development-made-easy.flv img=https://www.softbase.com/blog/wp-content/uploads/2011/10/black.png mp4=https://s3.amazonaws.com/SoftBase/parallel-development-made-easy.mp4 embed=false share=false width=640 height=486 dock=true controlbar=over bandwidth=high autostart=false preload=metadata /]
The Slice tool can be installed in less than a day. Learn more about it here.
Tags: Application Testing, DB2 Application Development, DB2 for z/OS, Parallel Development, TestBase
A recent Ponemon study sponsored by Symantec has found that employee negligence is the most common cause of data breaches in the US, while malicious attacks are the most expensive. Interestingly enough, the average cost per data breach has dropped from $7.2 million in 2010 to $5.5 million in 2011 – still a price no one wants to pay!
Data breaches are a very real and present threat to the modern organization. Between tangible damage such as direct fines, legal costs and lost customers, to intangible damage to the brand, data breaches cost organizations an average of $194 per record in 2011. The article goes on to detail best practices, and reports that hiring a Chief Information Security Officer (CISO) can help reduce the cost per record by up to $80 or 35%. You can read the rest of the article here.
“Organizations need to focus on processes, policies and technologies that address threats from the malicious insider or hacker.”
Here at SoftBase, we understand the mission-critical importance of data security. That’s why we built our DB2 application testing and test data sub-setting suite, TestBase, to include the most advanced data masking features available on the market. You need good quality test data for development, but you also need to keep your customer data safe with the best processes, policies and technologies available.
TestBase is the safest test data management solution available on the market – contact us or click here to learn more!
Tags: CISO, Data Breach, Data Security, Internal Data Theft, SoftBase, TestBase
Fogarty’s article on data theft does an excellent job of describing the root cause of Intellectual Property (IP) theft – human emotion. In environments where IT specialists are an integral part of creating and managing IP, the techniques Fogarty describes seem to be best defense. It’s not like you can prevent these employees from accessing IP. But when it comes to protecting sensitive customer data from internal theft, I would argue that organizations should use data masking as an additional line of defense.
A huge security hole exists when database applications are tested using real customer data. The test-data standard for most organizations is to copy data from their secure production database into the test environment, where the data can easily be copied to another computer or a flash drive. As Fogarty mentioned, most organizations use retroactive policies such as non-disclosure agreements, which do little to stop a determined thief.
Could you imagine the damage a disgruntled application developer could cause with all of your organization’s customer information? Credit card numbers, social security numbers, addresses, email addresses… We are talking about immediate class action lawsuits here! Organizations who leave this kind of security hole open are simply playing with fire. Internal data breaches account for over 70% of all data breaches. With data breaches in the US costing on average of $7.2M in business and legal costs, organizations need to keep their customer data under lock-and-key!
A growing trend for preventing internal data breaches is to mask sensitive test data. This simply involves obfuscating sensitive customer data, rendering it useless to a thief. Several third party applications exist for data masking, across all platforms. The most effective masking solutions copy data from production, mask the sensitive data, and then dump the masked data into test. And that’s exactly what TestBase does. Beware of solutions which mask data only after being copied to the test environment – these leave a wide window of opportunity open for a thief.
Tags: Data Breach, Data Mask, Data Privacy, Data Security, Internal Data Theft, IP Theft, Regulation Compliance, TestBase
Steve just spoke with Government Security News Editor-in-Chief Jacob Goodwin about the data masking capabilities of TestBase. Within two hours Jacob had posted the article discussing the importance of data masking in the mainframe environment and how TestBase can plug internal data security holes. Check out the article here.
Below is a representation of one of the several ways that TestBase masks data copied from production to test. The method depicted below utilizes a translation table for predefined data value substitution.

Tags: Data Breach, Data Mask, Data Privacy, Data Security, Internal Data Theft, Regulation Compliance, steve woodard, TestBase