General:PatchUpgrade
Contents
Limitations of this section
This section assumes you have a dbSQWare installation that meets the standard described in sections « Concepts » and « Base Installation ».
In other words, you should only have touched the trees dedicated to customization (ie: directories of the form *_cust) because the standard tool trees will be overwritten.
If so, a patch or upgrade will be handled the same way and should take less than 10 minutes in most cases.
Express patch/upgrade release (from v3.0.04)
Steps
Here's a quick description of the steps we'll take:
- Retrieve the latest version (http://support.dbsqware.com 'dbSQWare support' website)
- Patch
- Deploy the patched version of SQWareProduction
Central point update (SQWareCentral)
Install the archive in the home of the dbsqware user :
$ cd $ tar zxvf dbSQWare_full_latest.tgz dbSQWare/ dbSQWare/SQWareProduction/ dbSQWare/SQWareProduction/ingres/ dbSQWare/SQWareProduction/ingres/tools/ ... dbSQWare/SQWareProduction/oracle/ dbSQWare/SQWareProduction/oracle/tools/ dbSQWare/SQWareProduction/oracle/tools/sqwora_RmanConfigure.ksh ... dbSQWare/SQWareCentral/ dbSQWare/SQWareCentral/lib/ dbSQWare/SQWareCentral/lib/sqwctl_MenuAction.lib ... dbSQWare/SQWareWeb/custom_ref/ dbSQWare/SQWareWeb/custom_ref/ingres/ ...
Patch global :
$ dbspatch ################################################################### # SQWareCentral module of dbSQWare # Copyright (C) 2010-2021, dbSQWare (www.dbsqware.com) # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # CGU/CGA for more details. # You should have received a copy of the CGU/CGA # along with this program. If not, see <http://www.dbsqware.com/licenses/>. # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### # SqwVersion=2020.08 # For help type 'show <-h|-help|--help>' Sourcing sqwctl_Global.lib v2020.08 SQWareCentral (dbSQWare) ... eval global vars: gvsqw_MySqlCnfFile="$gvsqw_GenPath/../../generic/etc_cust/.my_SQWareRepository.cnf" => gvsqw_MySqlCnfFile=/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf Checks before install: SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository Connect string to repository: MySQL_Command="mysql -N -s --defaults-file='/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf'" [client] host = CentralHost port = 3306 database = dbsqware_db user = dbsqware_user 5.6.22 Major version of Repository, 56, 5.6.22 Checks for install mode (full or patch): 215 SQL found to be successfull installed. You will make a patch install. Do you want to patch SQWareRepository [y-Y-o-O-n-N]? y Query OK, 1 row affected Bye CheckNb: OK lic=150 real=118 CheckDate: OK lic=2021-12-31 real=2021-08-18 expire_days=135 Summary of returns: END_TRT Code: 0 --> SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository ! patch SQWareRepository END_TRT Code: 0 --> $gvsqw_SQWareRepositoryPath/teradata/sql/patch_v2020.01/061_tsqw_VolThresholdDef_insert.sql executed successfully. Treatment Install SQWareRepository proceeded successfully Begining : 18/08/2021 16:45:38 End : 18/08/2021 16:45:56
Deploying the patched version of SQWareProduction
Then deploy the SQWareProduction you are using :
depl_ora => for Oracle depl_syb => for Sybase ASE depl_rs => for Sybase RS depl_mys => for Mysql depl_msq => for Mssql depl_db2 => for DB2 depl_pg => for PostgreSQL depl_ter => for Teradata depl_cas => for Cassandra depl_ing => for Ingres depl_ada => for Adabas
There you go, it's over!
Detailled, step-by-step patch/upgrade procedure
Steps
Here's a quick description of the steps we'll take:
- Get the latest version
- Patch the central point (SQWareCentral)
- Patch the repository (SQWareRepository)
- Patch the web (SQWareWeb)
- Deploy the patched version of SQWareProduction
Central point update (SQWareCentral)
Install the archive in the home of the dbsqware user :
$ cd $ tar zxvf dbSQWare_full_latest.tgz dbSQWare/ dbSQWare/SQWareProduction/ dbSQWare/SQWareProduction/ingres/ dbSQWare/SQWareProduction/ingres/tools/ ... dbSQWare/SQWareProduction/oracle/ dbSQWare/SQWareProduction/oracle/tools/ dbSQWare/SQWareProduction/oracle/tools/sqwora_RmanConfigure.ksh ... dbSQWare/SQWareCentral/ dbSQWare/SQWareCentral/lib/ dbSQWare/SQWareCentral/lib/sqwctl_MenuAction.lib ... dbSQWare/SQWareWeb/custom_ref/ dbSQWare/SQWareWeb/custom_ref/ingres/ ...
Reloading the environnement :
$ reload ################################################################### # SQWareCentral module of dbSQWare # Copyright (C) 2010-2021, dbSQWare (www.dbsqware.com) # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # CGU/CGA for more details. # You should have received a copy of the CGU/CGA # along with this program. If not, see <http://www.dbsqware.com/licenses/>. # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### # SqwVersion=2020.08 # For help type 'show <-h|-help|--help>' Sourcing sqwctl_Global.lib v2020.08 SQWareCentral (dbSQWare) ... eval global vars: gvsqw_MySqlCnfFile="$gvsqw_GenPath/../../generic/etc_cust/.my_SQWareRepository.cnf" => gvsqw_MySqlCnfFile=/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf Checks before install: SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository Connect string to repository: MySQL_Command="mysql -N -s --defaults-file='/home/dbsqware/dbSQWare/SQWareCentral/menu/../../generic/etc_cust/.my_SQWareRepository.cnf'" [client] host = CentralHost port = 3306 database = dbsqware_db user = dbsqware_user 5.6.22 Major version of Repository, 56, 5.6.22 Checks for install mode (full or patch): 215 SQL found to be successfull installed. You will make a patch install. Do you want to patch SQWareRepository [y-Y-o-O-n-N]? y Query OK, 1 row affected Bye CheckNb: OK lic=150 real=118 CheckDate: OK lic=2021-12-31 real=2021-08-18 expire_days=135 Summary of returns: END_TRT Code: 0 --> SQWareRepository source to install: /home/dbsqware/dbSQWare/SQWareRepository ! patch SQWareRepository END_TRT Code: 0 --> $gvsqw_SQWareRepositoryPath/teradata/sql/patch_v2020.01/061_tsqw_VolThresholdDef_insert.sql executed successfully. Treatment Install SQWareRepository proceeded successfully Begining : 18/08/2021 16:45:38 End : 18/08/2021 16:45:56
Web update (SQWareWeb)
Still from the central point with the dbsqware user, launch the patch script:
$ /home/dbsqware/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh
Deploying the patched version of SQWareProduction
Then deploy the SQWareProduction packages you are using :
depl_ora => for Oracle depl_syb => for Sybase ASE depl_rs => for Sybase RS depl_mys => for Mysql depl_msq => for Mssql depl_db2 => for DB2 depl_pg => for PostgreSQL depl_ter => for Teradata depl_cas => for Cassandra depl_ing => for Ingres depl_ada => for Adabas
