Difference between revisions of "General:PatchUpgrade"
m (→Limites de cette section) |
m |
||
| Line 1: | Line 1: | ||
==Limitations of this section== | ==Limitations of this section== | ||
| − | + | ||
| − | + | This section assumes you have a dbSQWare installation that meets the standard described in sections [[General:Concepts | « Concepts »]] and [[General:BaseInstallation | « Base Installation »]].<br> | |
| − | + | 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.<br> | |
| + | If so, a patch or upgrade will be handled the same way and should take less than 10 minutes in most cases.<br> | ||
<br> | <br> | ||
| − | {{Warning | | + | {{Warning | This procedure is only valid for dbSQWare versions greater than or equal to v3.0! Upgrading from v1.x or v2.x to v3.x requires a major architecture and repository change (we recommend contacting support).<br> |
| − | + | Upgrading to v202x requires a few additional commands (a few minutes), please contact support.}} | |
<br> | <br> | ||
| − | == | + | ==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 | *Patch | ||
| − | * | + | *Deploy the patched version of SQWareProduction |
<br> | <br> | ||
| − | === | + | ===Central point update (SQWareCentral)=== |
| − | + | Install the archive in the home of the dbsqware user : | |
<pre> | <pre> | ||
$ cd | $ cd | ||
| Line 101: | Line 102: | ||
<br> | <br> | ||
| − | === | + | ===Deploying the patched version of SQWareProduction=== |
| − | + | Then deploy the SQWareProduction you are using : | |
<pre> | <pre> | ||
depl_ora => pour Oracle | depl_ora => pour Oracle | ||
| Line 117: | Line 118: | ||
</pre> | </pre> | ||
<br> | <br> | ||
| − | ''' | + | '''There you go, it's over!''' |
<br> | <br> | ||
<br> | <br> | ||
Revision as of 11:53, 9 April 2025
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 => pour Oracle depl_syb => pour Sybase ASE depl_rs => pour Sybase RS depl_mys => pour Mysql depl_msq => pour Mssql depl_db2 => pour DB2 depl_pg => pour PostgreSQL depl_ter => pour Teradata depl_cas => pour Cassandra depl_ing => pour Ingres depl_ada => pour Adabas
There you go, it's over!
Procédure détaillée, pas à pas, de patch/upgrade
Etapes
Voici une description rapide des étapes que nous allons dérouler :
- Récupération de la dernière version
- Patch du point central (SQWareCentral)
- Patch du référentiel (SQWareRepository)
- Patch du Web (SQWareWeb)
- Déploiement de la version patchée de SQWareProduction
Patch du point central (SQWareCentral)
Installez l’archive dans le home dir du user dbsqware :
$ 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/ ...
Rechargez l’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
Patch du Web (SQWareWeb)
Toujours depuis le point central avec le user dbsqware, lancez le script de patch :
$ /home/dbsqware/dbSQWare/SQWareWeb/exploit/bin/PatchCustom.ksh
Déploiement de la version patchée de SQWareProduction
Déployez ensuite les SQWareProduction que vous utilisez :
depl_ora => pour Oracle depl_syb => pour Sybase ASE depl_rs => pour Sybase RS depl_mys => pour Mysql depl_msq => pour Mssql depl_db2 => pour DB2 depl_pg => pour PostgreSQL depl_ter => pour Teradata depl_cas => pour Cassandra depl_ing => pour Ingres depl_ada => pour Adabas
