IBM i2 Base

IBM i2 Base Courses:

Formatting i2 iBase Import Data for Phone Numbers

This video shows you how you can use iBase to convert phone numbers using format logic into the following different formats:

  • If a phone number is 10 characters long, the format will be (999) 999-9999
  • If a phone number is 7 characters long, the format will be 999-9999
  • If a phone number is any other length than 7 or 10 characters, then leave as is 9999999999.
This video uses United States phone number formats as the example. However, this format logic can also be used for international phone numbers.

Time: 24 minutes

i2 iBase - Must gather information for IBM i2 Support
NEW

The IBM i2 Product Support team takes you through the i2 iBase product must gather information you may need to provide to get assistance with your support case.

Duration: 7 minutes

IBM i2 iBase - Creating and Importing a SQL View into IBM i2 iBase

The two videos provide a walk-through on:

  • how to create a SQL view to import into IBM i2 iBase, and
  • how to import the SQL view into IBM i2 iBase

i2 Open Mic - Upgrading and Migrating i2 iBase

Objectives

  • Define the environment for upgrading and migrating
  • Provide the best practices to use for upgrading and migrating
  • Know the steps to upgrade and migrate i2 iBase
  • Understand what changes you need to make before a backup of the database
  • Know how to perform the datasbase backup and restore
  • Provide steps to configure the database
  • Understand how to restart Search 360 and Alerts


Time:

46 minutes

IBM i2 iBase - Move and Restore an iBase SQL Server Database

In this video, you will learn how to move and restore an iBase SQL database from one server to another server. You will be using the IBM i2 iBase Designer to perform this move and restore.

i2 Analyst's Notebook: How to Add Entities to an ESRI Map Using i2 iBase

Objectives

  • Understand how to prepare entities so that you can place the entities in an ESRI map using iBase
  • Know how to move the entities into an ESRI map in Analyst's Notebook


Time

12 minutes

i2 Analyst's Notebook - How to Add Entities to an ESRI Map

Objective

  • Understand how to place entities on an ESRI Map
  • Know how resolve an issue if the entity does not appear on the map

Time

6 minutes

i2 iBase - How to create a manual Search 360 job with the Microsoft SQL server agent

In some cases, it is not possible to create Search 360 jobs using the IBM i2 iBase Index Service Configuration Tool due to the server being in a cluster. In those circumstances a job can be created directly in Microsoft SQL Server Agent in the SQL Server Management tool.

Duration

15 minutes