index
  • Volver
Servicio de la Universitat de València
During my professional life, I've contributed to different IT projects:
* JEE Information System (Java + PL/SQL) (2000):
  • * DBA :
        • CICS / DB2 z/os clonning tool ( REXX + JCL )(2011): A database clone is a complete and separate copy of a database system that includes the business data, applications and the DBMS software. The procedures needed to automate the hole process without disrupting production systems are implemented for WebSphere / CICS / DB2 z/os : http://www.uv.es/vijo/dbfclone_cast/odbzosclone.html
          A procedure to make it automatic for ORACLE instances, non disruptive and efficient using parallel distributed programming is described in: http://www.uv.es/vijo/cloning_oracle_database.pdf
        • Oracle Cloning Tool source code (Shell Scripting): http://www.uv.es/vijo/pclone.sh
        • Heterogeneous replication between DB2 z/os and Oracle (2003) This is a critical process which feeds up ORACLE information systems and DW from data coming from operational systems DB2 z/os. The batch process is performed overnight without disruption and very efficiently. An intermediate DB2 for AIX is used to transform data between EBCDIC and ASCII coding schemes. Finally, DB2 z/os catalog is queried to generate an database independent object model (tables, columns, indexes, ....) which is then translated to target database ( http://www.uv.es/vijo/DB2_zos_REPLICA.pdf )
        • DB2 HADR tutorial: http://www.uv.es/vijo/db2hadr_cast/
    • The main purpose of this video-tutorial is to show you how to implement DB2 HADR technology. In this example we have two servers: db2hadr1@hadr1 (primary) & db2hadr2@hadr2 (standby) both runing linux with DB2 LUW installed and network properly configured.
  • * System Programmer:

    * Linux Kernel Developer / Embedded systems programmer (2001):

    * WebSphere Automation & Reporting Tools (2015)

    • A series of system reporting tools developed in bash scripting, perl and jython (java + python) used for:
      • Automatic Deployment: Allows each application responsible to automatically promote applications from preprod to production environment. This allows to implement application's change management. It is very easy to use, the deployer only needs to execute the command "sudo name_of_application" using a valid LDAP user.
      • Automatic Runtime Reporting Tool using data mining: This tool reports each day information about the JEE runtime environment. It uses scripting (JACL & JYTHON) and batch data mining to obtain information such as: + WebSphere Topology (cells, nodes, clusters, application servers) + Application state in each cluster + JDBC data sources datails (username, host, DB name) and applications using them + CICS programs and JEE applications calling them + DB2 z/os plans used by CICS transactions + Resource Monitoring Here is an example of a report: http://www.uv.es/vijo/doc/report.txt and here an presentation about the technology: http://www.uv.es/vijo/uv.pdf

    * TOMCAT & JBOSS on z/os (2014)

        • To migrate JEE application for electronic procurement from source: WebSphere on AIX/pseries to target:Tomcat on z/os on a z10 BC LPAR with one ZIIP processor
        • To migrate JEE application for cost accounting from source: JBOSS on Linux/x86-64 to target:JBOSS on z/os on a z10 BC LPAR with one ZIIP processor
        • Install Tomcat & JBOSS on z/os Unix System Services and configure start/stop procedures, STCs, SMS, WLM, RACF, ....
        • To design deployments protocols on dev,test and production environments
        • To test accessing relational data (oracle/AIX, DB2 for z/os) from JDBC L4 connections.
        • To test calling CICS Transactions based on COMMAREA from TOMCAT JEE components: https://gestiod.uv.es/testCICS/test.jsp
        • Patch Java code to handle EBCDIC character set correctly

    * Teaching Tutorials in Spanish

    * https://colecciones.uv.es

          • Col·leccions museístiques de la UV . Vitual Exhibitions . Exposicions Virtuals. Colecciones UV . Exposiciones virtuales

    Josep Vidal Canet, IT professional josepvidalcanet@gmail.com

    volver