TechTips / Database


Partner TechTip: Data Visualization: Three Keys to Enhancing Business Insight with SEQUEL PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 22 May 2015 00:00

Giving users data in a modern, usable format helps them work more efficiently, and SEQUEL makes this happen without even leaving IBM i.

mike stegemanWritten by Mike Stegeman

IBM i costs 45 percent less than running Linux servers and 54 percent less than Windows servers, according to a 2014 study by ITG. These calculations are based on the average cost of hardware, licenses, support, personnel, and facilities over a three-year period.

 

While the DB2 database on IBM i is proven to be the most cost-effective platform, some companies are still moving to or adding others. Ease of use is a major factor. Organizations need their members to work effectively, and seeing data in modern, straightforward formats improves productivity.

Add a comment
Last Updated on Thursday, 21 May 2015 11:42
Read more...
 
TechTip: Routing Away Your QZDASOINIT Troubles PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 08 May 2015 00:00

Utilize a new procedure to better manage host server job performance.

kent milligan 117x117Written by Kent Milligan

The good news in the IBM i world is that more and more applications and tools are using modern, industry-standard interfaces such as ODBC, ADO.NET, and JDBC to access DB2 for i databases. The bad news from a systems management perspective is that all of those interfaces by default run in the same subsystem (QUSRWRK) on your IBM i servers. Analysts utilizing an ODBC-based reporting tool are competing for the same resources as those users who are using a JDBC-based OLTP application. Both sets of users have workloads running in QZDASOINIT jobs in the same subsystem.

Add a comment

Last Updated on Thursday, 07 May 2015 14:21
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Secure Sensitive IBM i Data in DB2 for i Monitor Collections PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 10 April 2015 00:00

Leverage new support to protect sensitive data values.

kent milligan 117x117Written by Kent Milligan

Data breaches are unfortunately becoming a regular item in news reports these days. As a result, IT teams everywhere are scrambling to making sure they're using every available security control to protect the sensitive data they own.

Add a comment

Last Updated on Thursday, 09 April 2015 12:05
Read more...
 
Partner TechTip: Flexible Data Access and Deployment Are Just Clicks Away PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 06 February 2015 00:00

In today's IBM i shops, IT professionals must provide easily accessible information in the formats business users prefer.

mike stegemanWritten by Mike Stegeman

Flexibility is vital in today's IBM i shops, where IT is expected to secure data, write new applications, and keep business users happy. IT professionals also contend with executives needing detailed information at their fingertips. The data can be presented in many formats, but it must be easily accessible.

Add a comment
Last Updated on Friday, 06 February 2015 09:02
Read more...
 
TechTip: The Need to Modernize IBM i Databases: Why and How? PDF Print E-mail
Tips & Techniques - Database
Written by Elie Muyal   
Friday, 09 January 2015 00:00

You can modernize IBM i databases without "breaking" what already works.

elie muyalWritten by Elie Muyal

When speaking about the modernization of the IBM i, usually the first thing that comes to mind is the modernization of the user interface, since it's the visible part of the application. Although it's clear that the benefits of revamping the green-screen user interface are considerable, it's important to remember that the user interface is only a means to access and update the database. The database holds the information, which is the most important asset of any organization.

Add a comment

Last Updated on Friday, 09 January 2015 09:57
Read more...
 
TechTip: DB2 for i's Sample Database PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 14 November 2014 00:00

The built-in sample database makes self-learning and prototype activities easier.

kent milligan 117x117Written by Kent Milligan

Almost all of the DB2-related TechTips that I have written highlight new DB2 for i functions and features. While it's good to raise awareness of new DB2 capabilities, this does result in existing DB2 features being overlooked. This is especially true of the more ordinary database functions.

Add a comment
Last Updated on Friday, 14 November 2014 00:00
Read more...
 
User Rating: / 2
PoorBest 
Partner TechTip: How Do I Know When I Need a Data Warehouse? PDF Print E-mail
Tips & Techniques - Database
Written by Alan Jordan   
Friday, 31 October 2014 00:00

Combining information from different sources often creates challenges that can't be solved within the reporting tool. A data warehouse can get you back on track.

alan jordanWritten by Alan Jordan

Obtaining a query and reporting tool is a common way organizations get started with business intelligence (BI). Creating reports, dashboards, and portals directly from the data seems like a natural progression.

 

This approach works well in many implementations and meets the organization's needs for years. But some operational data can be pretty hard to work with. Some databases simply were not designed for reporting use and many lack the documentation that could make them easier to use. Cryptic column names, complex relationships, inconsistencies, legacy dates, huge data volumes, and many other issues may need to be overcome to achieve the results you need from your BI investment.

Add a comment
Last Updated on Friday, 31 October 2014 00:00
Read more...
 
Partner TechTip: Data Access on IBM i PDF Print E-mail
Tips & Techniques - Database
Written by Mike Stegeman   
Friday, 05 September 2014 00:00

Is it time to upgrade from Query/400?

mike stegemanWritten by Mike Stegeman

For over 30 years, Query/400 has been the data access tool to generate reports easily from DB2 data, allowing access to insight like never before. While it continues to be sufficient for basic reporting functionality, most organizations are beginning to be challenged with the need to access and report on larger volumes of data.

Add a comment
Last Updated on Friday, 05 September 2014 00:00
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 14

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.

   MC-STORE.COM