﻿Quick Reference Guide

This guide contains quick reference information for ZendDBi. The file is formatted so you can easily copy/paste commands from it to your server. Unless stated otherwise commands should be entered in a 5250 session.

Verify that required PTFs are installed (IBMi version 7R1)
  DSPPTF LICPGM(5770999) SELECT(MF99011) 
  DSPPTF LICPGM(5770999) SELECT(MF59547)
  DSPPTF LICPGM(5770999) SELECT(MF51795)

Prepare for installation:
Create the installation SAVF file
  CRTSAVF FILE(QGPL/ZDBISAVF10) TEXT('ZendDBi 10 product save file')
    
Upload the installation package to your system (FTP)(not 5250 session)
Transfer the package using FTP in binary mode to the SAVF ZDBISAVF10 in QGPL:
Replace IP/User with your own IP
  ftp 172.29.152.248
  u0017281
  binary
  PUT zdbisavf10.savf QGPL/ZDBISAVF10

Interactive installation:
  RSTLICPGM LICPGM(1ZENDDB) DEV(*SAVF) SAVF(QGPL/ZDBISAVF10)

Silent (batch) installation:
  SBMJOB CMD(RSTLICPGM LICPGM(1ZENDDB) DEV(*SAVF) SAVF(QGPL/ZDBISAVF10))

Display the ZendDBi Management menu (5250 terminal (ILE)):
  STRZDBI or GO ZMARIADB/ZCMYSQL 

Starting the mysql client from your ZENDDBI server (from ssh/QSH/QP2TERM session):
Explictly set terminal type if running from QSH
  export TERM=xterm

Start the mysql client (to manage ZendDBi):
By default 'root' has no password from localhost:
  /usr/local/mariadb/bin/mysql

Connecting using a remote mysql client (or local using non-default port)
If you wish to manage mariadb using a remote mysql client or if you configured ZendDBi to use a non-default port/socket then you can use one of the following options:

  /usr/local/mariadb/bin/mysql --socket /usr/local/mariadbdata/mariadb.sock 
  /usr/local/mariadb/bin/mysql --host <server_ip> --port <server_port>

Note: ZENDDBI listens on port 3306 and socket /tmp/mysql.sock by default and is open to outside computers. Access from outside is only allowed for users with passwords (GRANT will fail to create users with no password).

If you installed ZendDBi 10 (Mariadb) side by side with a previous mysql then it will listen on a different port (default: 3307) and socket (default: /usr/local/mariadbdata/mariadb.sock)  ( according to the installation summary screen). After installation it can also be retrieved from the MY.CNF file (option 20 in the menu).


Uninstalling ZendDBi
  DLTLICPGM (1ZENDDB)

