TechTips / Database


TechTip: How to Prepare for the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Certification Exam PDF Print E-mail
Tips & Techniques - Database
Written by Roger Sanders   
Friday, 22 July 2016 00:00

One of the best ways to prepare for any DB2 certification exam is by answering practice questions that are similar to, and that are presented in the same format as, the questions you are likely to encounter when you take the actual exam.

roger sandersWritten by Roger E. Sanders

Editor’s note: This article is adapted from DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) by Roger E. Sanders.

 

 A few months after the “IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1” certification exam (Exam 311) was announced, I spent several weeks developing training material that I could use to help individuals prepare for the 311 certification exam. I used the same technique to develop material for that course that I have used to develop my other DB2 certification exam preparation courses and study guides: I carefully reviewed notes I had taken during the exam development process, as well as the questions I wrote for that particular test, and I made sure I covered, in detail, all the objectives that had been defined for that certification exam.

Add a comment
Last Updated on Thursday, 21 July 2016 12:59
Read more...
 
TechTip: DB2 for i Optimization Strategies, Part 4 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 15 July 2016 00:00

Continue to explore the many ways to improve application queries to reduce the amount of work DB2 for i has to do to process them.

Written by Michael Sansoterra

In the prior tips of this series (1, 2, and 3), there were some general SQL coding guidelines given to avoid giving DB2 for i unnecessary work while doing its job to complete a process or query. This tip continues with more advice from real-world coding encounters.

Add a comment
Last Updated on Thursday, 14 July 2016 19:46
Read more...
 
TechTip: i Illuminate 7.3—Get a Grip PDF Print E-mail
Tips & Techniques - Database
Written by Scott Forstie   
Friday, 17 June 2016 00:00

Use the Gripping Charm to grasp the possibilities that lie ahead. Read how Scott dodges danger and dementors with DB2 for i spells.

Written by Scott Forstie

Good, you’re back. I was beginning to think that you had encountered some ugly business. After all, there is danger at every turn. For myself, I have been keeping a very public profile since we last spoke to one another. With the rollout of IBM i 7.3, everyone wants to know “What’s New in DB2 for i.” As I do my level best to tell them about the DB2 for i enhancements, I notice that frequently people aren’t fully utilizing the capabilities already at their fingertips. As you’ll read in this episode, an established DB2 for i column-level control will rescue me from an untimely demise.

Add a comment
Last Updated on Friday, 17 June 2016 00:00
Read more...
 
TechTip: Data Warehouse Updates from IBM i Using SSIS PDF Print E-mail
Tips & Techniques - Database
Written by Thomas Snyder   
Friday, 27 May 2016 00:00

Point-and-click your way to repeatable data updates to or from any database from your DB2 database.

tom snyderWritten by Tom Snyder

One common theme I’ve experienced through several RPG developer jobs is to provide data to an external data warehouse from the all-knowing DB2 database. Other common needs may be to supply member information to a website or to some third-party software. Sometimes these would be DB2 databases, and sometimes they wouldn't. I'm going to show you how to quickly set up a SQL Server Integration Services (SSIS) package to take care of this process for you.

Add a comment
Last Updated on Friday, 27 May 2016 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: DB2 for i Optimization Strategies, Part 3 PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 27 May 2016 00:00

Learn ways to keep your database code lean and mean, resulting in better performance.

Written by Michael Sansoterra

This third tip in the series continues where Part 1 and Part 2 left off. Presented herein are some general guidelines for how to make your database code purr like a kitten.

Add a comment
Last Updated on Wednesday, 25 May 2016 11:15
Read more...
 
TechTip: Sample Questions and Answers from the DB2 Certification Guide PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 06 May 2016 00:00

Do you know what's required to be an LUW database administrator? Read on.

mohan saraswatipuraWritten by Mohankumar Saraswatipura

Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.

 

Q1. Which command sets the automatic instance restart every time the server is restarted?

Add a comment
Last Updated on Thursday, 05 May 2016 12:25
Read more...
 
TechTip: i Illuminate 7.3 – Time-Turner PDF Print E-mail
Tips & Techniques - Database
Written by Scott Forstie   
Friday, 22 April 2016 00:00

Traveling back in time is easy and can answer important questions. Take the next step with Scott on this journey through the castle.

Written by Scott Forstie

Glad you could join me for episode two of this series. When I last talked to you, I had just learned what house the Sorting Hat had chosen for me. In an unexpected turn of events, I am bound for the house of Slytherin. Unlike some before me, I don’t resist the decision, bowing to the wisdom of the enchanted hat. Perhaps I’m comforted by the knowledge that my path will be influenced by future decisions that I can control.

 

My housemates welcome me with open arms and wary looks. After some time has passed, I have settled into a routine of training and competition. I am intrigued by the possibilities that lie before me. Much like my life here in the castle, DB2 for i on IBM i 7.3 provides similar opportunities for new adventures.

Add a comment
Last Updated on Friday, 22 April 2016 00:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: SSIS Data Sources for IBM i DB2 and Microsoft SQL Databases PDF Print E-mail
Tips & Techniques - Database
Written by Thomas Snyder   
Friday, 08 April 2016 01:00

Here’s a reusable reference for connecting your SSIS to your IBM and Microsoft databases.

tom snyderWritten by Tom Snyder

I’ve been introducing the Microsoft SSIS technologies to the IBM community, who is showing interest, and I would like to continue providing more. Modular programming is always a good thing, so I’m going to try to reduce the initial data source configuration overhead in my articles by creating this reusable, modular article that is the starting point for any SSIS packages using databases.

Add a comment
Last Updated on Wednesday, 06 April 2016 10:43
Read more...
 
User Rating: / 1
PoorBest 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 17

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