- List of fixes
P103429
- Download location
Download from the following location: http://www.ibm.com/eserver/support/fixes/
- Product notifications:
To receive information about product solution and patch updates
automatically, subscribe to product notifications on the My
notifications page http://www.ibm.com/support/mynotifications/
on the IBM Support website (http://support.ibm.com). You can edit
your subscription settings to choose the types of information you
want to get notification about, for example, security bulletins,
fixes, troubleshooting, and product enhancements or documentation
changes.
- Products or components affected
N/A
- System requirements
- Installation and configuration
- 6.1 Before installation
- Log on to the IBM Spectrum LSF Application Center server
host as root.
- Set your IBM Spectrum LSF Application Center
environment.
For csh or tcsh:
% source /opt/ibm/lsfsuite/ext/cshrc.platform
For sh, ksh, or bash:
$ . /opt/ibm/lsfsuite/ext/profile.platform
- Determine the location of your existing IBM Spectrum LSF
Application Center installation.
#rpm -q --queryformat "%{INSTPREFIXES}\n"
lsf-appcenter
- Check and record the version and build number of your
existing installation of IBM Spectrum LSF Application
Center in case you need to roll back the fix.
pmcadmin -V
- Stop all IBM Spectrum LSF Application Center services.
perfadmin stop all
pmcadmin stop
- Back up your existing installation.
For example:
#cp -rfp /opt/ibm /opt/ibm.bak
- 6.2 Installation steps for IBM Spectrum LSF
Application Center V10.2.0.9.
The following steps assume that IBM Spectrum LSF
Application Center is installed in /opt/ibm.
Replace with your actual installation directory.
Note: This patch is only for LSF Application Center
V10.2.0.9. If you are using other versions, you must first
migrate to V10.2.0.9 before applying this Fix Pack.
- As root, log on to your IBM Spectrum LSF Application
Center 10.2 host.
- Open mysql and navigate to database 'pac'.
- Run following two SQLs.
ALTER VIEW LSF_LIVE_JOB_DETAIL_VIEW as
select insert_seq as
insert_seq, job_id as job_id, job_array_index as
job_array_index,
null as job_name,
cluster_name as cluster_name,
user_name as
user_name, submit_time_gmt as create_time_gmt,
queue as queue_name,
priority as jobPriority, from_host as from_host,
command as command,
mem as mem, swap as swap ,nthreads as nthreads,pgidstr
as pgidstr,pidstr as pidstr ,
in_file as in_files
,out_file as out_files ,project_name as project_name,
pend_reasons as
pend_reasons ,cwd as cwd,application as application
,num_processors as num_processors ,
submit_time as
submit_time,askhoststr as askhoststr,bpost_msg as
ext_status,
end_time as end_time,
end_time_gmt as end_time_gmt, start_time as start_time,
start_time_gmt as start_time_gmt,
job_status as
job_status_str, duration as duration,
path as path,
graphic_session_id as graphic_session_id, graphic_host as
graphic_host,
application_name as
application_name, exec_hoststr as exec_hosts,
from_host_cluster as from_host_cluster,
execcwd as exec_cwd,
path_alias as path_alias, job_group as group_name,
num_slots as num_slots,
notification as
notification, description as description, workload_type as
workload_type, runtime as runtime, runlimit as runlimit,
0 as pend, 0 as run,
0 as susp, 0 as exited, 0 as done, job_name_full as
job_name_full, exit_status as exit_status, path_removable
as path_removable,
share_user_list as
share_user_list, res_req as res_req, suspend_time as
suspend_time, prev_job_status as prev_job_status,
pendlimit as pendlimit,
0 as min_index, null
as FLOW_CURRENT_VERSION_STATE
from LSF_LIVE_JOB
where WORKLOAD_TYPE='JOB';
ALTER VIEW LSF_FINISH_JOB_DETAIL_VIEW as
select
insert_seq as insert_seq, job_id as job_id,
job_array_index as job_array_index,
null as
job_name, cluster_name as cluster_name,
user_name as
user_name, submit_time_gmt as create_time_gmt,
queue as
queue_name, priority as jobPriority, from_host as
from_host,
command as
command, mem as mem, swap as swap ,nthreads as
nthreads,pgidstr as pgidstr,pidstr as pidstr ,
in_file as
in_files ,out_file as out_files ,project_name as
project_name,
pend_reasons as
pend_reasons ,cwd as cwd,application as application
,num_processors as num_processors ,
submit_time as
submit_time,askhoststr as askhoststr,bpost_msg as
ext_status,
end_time as
end_time, end_time_gmt as end_time_gmt, start_time as
start_time, start_time_gmt as start_time_gmt,
job_status as
job_status_str, duration as duration,
path as path,
graphic_session_id as graphic_session_id, graphic_host as
graphic_host,
application_name as application_name, exec_hoststr as
exec_hosts, from_host_cluster as from_host_cluster,
execcwd as
exec_cwd, path_alias as path_alias, job_group as
group_name, num_slots as num_slots,
notification as
notification, description as description, workload_type as
workload_type, runtime as runtime, runlimit as runlimit,
0 as pend, 0 as
run, 0 as susp, 0 as exited, 0 as done, job_name_full as
job_name_full, exit_status as exit_status, path_removable
as path_removable,
share_user_list
as share_user_list, res_req as res_req, suspend_time as
suspend_time, prev_job_status as prev_job_status,
pendlimit as pendlimit,
0 as min_index,
null as FLOW_CURRENT_VERSION_STATE
from
LSF_FINISH_JOB
where
WORKLOAD_TYPE='JOB';
- Uninstallation
- 7.1 Before uninstallation
- 7.2 Roll back the fix
The following steps assume that IBM Spectrum LSF
Application Center is installed in the /opt/ibm directory.
Replace this with your actual installation directory.
- As root, log on to your IBM Spectrum LSF Application
Center 10.2 host.
- Open mysql and navigate to database 'pac'.
- Run following two SQLs.
ALTER VIEW LSF_LIVE_JOB_DETAIL_VIEW as
select insert_seq as
insert_seq, job_id as job_id, job_array_index as
job_array_index,
null as job_name,
cluster_name as cluster_name,
user_name as
user_name, submit_time_gmt as create_time_gmt,
queue as queue_name,
priority as jobPriority, from_host as from_host,
command as command,
mem as mem, swap as swap ,nthreads as nthreads,pgidstr
as pgidstr,pidstr as pidstr ,
in_file as in_files
,out_file as out_files ,project_name as project_name,
pend_reasons as
pend_reasons ,cwd as cwd,application as application
,num_processors as num_processors ,
submit_time as
submit_time,askhoststr as askhoststr,bpost_msg as
ext_status,
end_time as end_time,
end_time_gmt as end_time_gmt, start_time as start_time,
start_time_gmt as start_time_gmt,
job_status as
job_status_str, duration as duration,
path as path,
graphic_session_id as graphic_session_id, graphic_host as
graphic_host,
application_name as
application_name, exec_hoststr as exec_hosts,
from_host_cluster as from_host_cluster,
execcwd as exec_cwd,
path_alias as path_alias, job_group as group_name,
num_slots as num_slots,
notification as
notification, description as description, workload_type as
workload_type, runtime as runtime, runlimit as runlimit,
0 as pend, 0 as run,
0 as susp, 0 as exited, 0 as done, job_name_full as
job_name_full, exit_status as exit_status, path_removable
as path_removable,
share_user_list as
share_user_list, res_req as res_req, suspend_time as
suspend_time, prev_job_status as prev_job_status,
pendlimit as pendlimit,
0 as min_index
from LSF_LIVE_JOB
where WORKLOAD_TYPE='JOB';
ALTER VIEW LSF_FINISH_JOB_DETAIL_VIEW as
select
insert_seq as insert_seq, job_id as job_id,
job_array_index as job_array_index,
null as
job_name, cluster_name as cluster_name,
user_name as
user_name, submit_time_gmt as create_time_gmt,
queue as
queue_name, priority as jobPriority, from_host as
from_host,
command as
command, mem as mem, swap as swap ,nthreads as
nthreads,pgidstr as pgidstr,pidstr as pidstr ,
in_file as
in_files ,out_file as out_files ,project_name as
project_name,
pend_reasons as
pend_reasons ,cwd as cwd,application as application
,num_processors as num_processors ,
submit_time as
submit_time,askhoststr as askhoststr,bpost_msg as
ext_status,
end_time as
end_time, end_time_gmt as end_time_gmt, start_time as
start_time, start_time_gmt as start_time_gmt,
job_status as
job_status_str, duration as duration,
path as path,
graphic_session_id as graphic_session_id, graphic_host as
graphic_host,
application_name as application_name, exec_hoststr as
exec_hosts, from_host_cluster as from_host_cluster,
execcwd as
exec_cwd, path_alias as path_alias, job_group as
group_name, num_slots as num_slots,
notification as
notification, description as description, workload_type as
workload_type, runtime as runtime, runlimit as runlimit,
0 as pend, 0 as
run, 0 as susp, 0 as exited, 0 as done, job_name_full as
job_name_full, exit_status as exit_status, path_removable
as path_removable,
share_user_list
as share_user_list, res_req as res_req, suspend_time as
suspend_time, prev_job_status as prev_job_status,
pendlimit as pendlimit,
0 as min_index
from
LSF_FINISH_JOB
where
WORKLOAD_TYPE='JOB';
- List of files
N/A
- Copyright and trademark information
©Copyright IBM Corporation 2020
U.S. Government Users Restricted Rights - Use, duplication or
disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
IBM®, the IBM logo and ibm.com® are trademarks of International
Business Machines Corp., registered in many jurisdictions
worldwide. Other product and service names might be trademarks of
IBM or other companies. A current list of IBM trademarks is
available on the Web at "Copyright and trademark information" at http://www.ibm.com/legal/copytrade.shtml