Blog

Posted on

FormaServe – How to use ODBC on the IBM i

In this short How To …. On IBM i Video set, we will be looking at how to use ODBC (Open Database Connectivity). We will show how to make your applications more scalable, allowing development on other platforms. See where to obtain the software and how to install it and configure it. The video also includes how to write a quick Node.js program to test our ODBC installation and configuration. — Contents — 00:00 – Intro 00:41 – What we trying to acheive? 01:34 – Installing ODBC 02:27 – Download Drivers from https://www.ibm.com/support/pages/ibm-i-access-client-solutions 02:46 – Windows ODBC Administration 03:23 – Install ACS PASE package 03:57 – Configure ODBC on the IBM i 05:36 – Testing ODBC on the IBM i 06:37 – Writing a Node.js program to use & test ODBC on the IBM i 09:20 – Test our node.js program 10:10 – Check out learning.formaserve.co.uk & Powerwire.eu 10:31 – Still training! 11:26 – Wrap Up!
Posted on

Getting information about the partition’s disk drives using SQL

Back in IBM i release 7.2 the SYSDISKSTAT SQL View was added. It was introduced to give similar information to what can be see using the Work with Disk Status command, WRKDSKSTS, and allow us to do more with that information. Over the next couple of releases there have been new columns added to it making it ever more useful. I have to admit I have been remiss not writing about it until now.

In the latest Technology Refreshes, IBM i 7.4 <abbr=”Technology Refresh”>TR4 and 7.3 TR10, 37 new columns were added. There is also now a SYSDISKSTAT SQL Table Function, more about that later. In the examples I am going to give I am not going to use all 37 of the new columns, therefore, if you want to learn about them all click to the links to the IBM documentation at the bottom of this post.

With this statement I am going to get a snapshot of the which disks are the top five when it comes to the percent of the disk is used:

Read more »

Verified by MonsterInsights