Patch-ID# 118093-01 Keywords: pivot table pdf Synopsis: N1 Grid Engine 6.0 maintenance patch Date: Aug/19/2004 Install Requirements: Additional instructions may be listed below Solaris Release: 7 8 9 SunOS Release: 5.7 5.8 5.9 Unbundled Product: N1 Grid Engine Unbundled Release: 6.0 Xref: See patch matrix below Topic: Relevant Architectures: all BugId's fixed with this patch: 5059680 5069875 5073716 5078872 5085393 Changes incorporated in this version: 5059680 5069875 5073716 5078872 5085393 Patches accumulated and obsoleted by this patch: Patches which conflict with this patch: Patches required with this patch: Obsoleted by: Files included with this patch: /dbwriter/database/oracle/dbdefinition.xml /dbwriter/database/postgres /dbwriter/database/postgres/dbdefinition.xml /dbwriter/database/postgres/drop.sql /dbwriter/inst_dbwriter /dbwriter/inst_util.sh /dbwriter/lib/dbwriter.jar /dbwriter/lib/jaxb-impl.jar /dbwriter/lib/postgresql-7.4.2.jar /dbwriter/updatedb.sh /dbwriter/util/sgedbwriter_template /reporting/WEB-INF/lib/i18n.jar /reporting/WEB-INF/lib/jaxb-impl.jar /reporting/WEB-INF/lib/reporting.jar /reporting/app.xml /reporting/arcorun /reporting/html/en/version.txt /reporting/html/en/versionDate.txt /reporting/images /reporting/images/logo_sge.gif /reporting/inst_reporting /reporting/inst_util.sh Problem Description: 5059680 inst_dbwriter: database check (PostgreSQL) fails with empty passwd 5069875 can't specify late binding parameters with advanced query 5073716 Several predefined queries are not working ("Sorry - No Data") 5078872 Queries on view_job_times doesn't return any data, queries on view_accounting re 5085393 cannot export pivot tables in PDF Patch Installation Instructions: -------------------------------- tar.gz Patch Installation: -------------------------- See the patch installation instructions below before installing this patch! Patches in 'tar.gz' format cannot be installed with 'patchadd' on Solaris systems. The patch is installed by unpacking the 'tar.gz' file(s) in this directory in . is usually your directory. The installation of this patch later is not visible with the "showrev -p" command on Solaris. This patch cannot be backed out. You may want to make a backup copy of the files before installing this patch since the files will be overwritten. Please read "Install Instructions" later in this file and carry out all steps before you unpack the 'tar.gz' file(s) included in this patch. This patch in 'tar.gz' format should not be installed if the original package has been installed with 'pkgadd' on Solaris. If the orginal installation used packages ('pkgadd') utility, install the available patches for N1 Grid Engine 6; refer to the patch matrix below. The patch is installed by user root by unpacking the file(s) in the directory where the original package has been installed: # cd # gzip -dc / | tar xvpf - After installing the patch, you should correct the file permissions if your Sun Grid Engine installation is installed as an "admin user" system: # cd # util/setfileperm.sh Files to be deleted ------------------- The following files of the original packages are obsolete and should to be deleted after the installation of the patch: dbwriter/database/oracle/privileges.sql dbwriter/database/oracle/setup.sql dbwriter/database/oracle/view.sql dbwriter/database/postgres/privileges.sql dbwriter/database/postgres/setup.sql dbwriter/database/postgres/view.sql dbwriter/lib/pg73jdbc2.jar Patch requirements and patch matrix for N1 Grid Engine 6 packages ----------------------------------------------------------------- The patches below update a N1 Grid Engine 6 distribution to N1 Grid Engine 6 Update 1. The "-help" output of most commands will print a version string "N1GE 6.0u1" after applying the patch. All packages of a N1 Grid Engine 6 distribution must have the same patch level. Refer to the patch matrix below which updates the distribution to most recent patch level. It is not supported to mix different patch levels in a single Grid Engine cluster. Also, make sure to update the "common" and "arco" packages. 1. Patches for Packages in Sun pkgadd format -------------------------------------------- Package name* OS* Architecture* Patch-Id ----------------------------------------------------------------- SUNWsgee Solaris, Sparc, 32bit sol-sparc 118094-01 SUNWsgeex Solaris, Sparc, 64bit sol-sparc64 118130-01 SUNWsgeex Solaris x86 sol-x86 118131-01 SUNWsgeec all common 118132-01 SUNWsgeea all arco 118133-01 *Package Name = see pkginfo(1) *OS = Operating system *Architecture = N1 Grid Engine binary architecture string or "common" = architecture independent packages "arco" = Accounting and Reproting console 2. Patches for packages in tar.gz format ---------------------------------------- OS* Architecture Patch-Id ----------------------------------------------------- Solaris, Sparc, 32bit sol-sparc 118082-01 Solaris, Sparc, 64bit sol-sparc64 118083-01 Solaris, x86 sol-x86 118084-01 Linux kernel2.4/2.6, x86 lx24-x86 118085-01 Linux kernel2.4/2.6, AMD64 lx24-amd64 118086-01 IBM AIX 4.3 aix43 118087-01 IBM AIX 5.1 aix51 118088-01 Apple MAC OS/X darwin 118089-01 HP HP-UX 11 hp11 118090-01 SGI Irix 6.5 irix65 118091-01 all common 118092-01 all arco 118093-01 Special Install Instructions: ----------------------------- This patch for the Accounting and Reporting Console (ARCo) should should be installed with the corresponding binary patches and patches for the "common" package. See the patch matrix above and the patch installation instructions in the README files of the binary patches and "common" patch for more information. Stopping the Accounting and Reporting Console --------------------------------------------- 1. Stop the Sun Web Console /usr/sbin/smcwebserver stop 2. Stop the dbwriter daemon /dbwriter/bin/sgedbwriter stop Patch installation ------------------ The patch now should be installed as outlined in the "Patch Installation" section above Required steps after patch installation --------------------------------------- After patch installation, the database needs to be updated to make the fix for bugs 5073716 and 5078872 effective. Execute the update script: /dbwriter/updatedb.sh New functionality delivered with this patch ------------------------------------------- 1. Installation improvments --------------------------- The installation of ARCo has been improved. During the installation of the dbwriter the version of the database model will be checked and updated. The manual execution of the supplied SQL scripts is not longer necessary. This obsoletes the following steps in the N1GE6 Installation guide: - page 92 step 4 and 6 - page 93 steps 4, 5 and 6 2. New features --------------- 5085393: Pivot Tables can now be exported in PDF documents. 5069875: The late binding mechanism for advanced queries is now implemented. The syntax for the late bindings in advanced queries is: LATEBINDING{ ;; } must be a valid column of the query a SQL operator (e.g. = < > in .. ) default value (e.g. 'localhost' ) Examples: --------- select hostname from sge_host where LATEBINDING{hostname, like, 'a%'} select hostname from sge_host where LATEBINDING{hostname, in, ('localhost', 'foo.bar') } README -- Last modified date: Thursday, August 19, 2004