Troubleshooting
Problem
Symptom
731 dbutil:run_sql_file GLAW034V: Start to execute SQL file: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/sql/izoa_tables_list.sql.739 dbutil:run_sql_file GLAW036V: Execute SQL file finished: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/sql/izoa_tables_list.sql.740 pgmutil:runCommand GLAW023V: Run python command: dbutil.runsql /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/sql/izoa_procedure_create.sql java_driver_class=com.ibm.db2.jcc.DB2Driver zos=xxx.xxx.xxx.xxx dbalias=none dbsid=L203D2L1 port=9700 user=IZOAADM pwd=***742 dbutil:run_sql_file GLAW034V: Start to execute SQL file: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/sql/izoa_procedure_create.sql.746 dbutil:execute_sql GLAW061W: Already exist: IZOAADM.DELETE_UNNEEDED_ROW;PROCEDURE, create operation is failed.747 dbutil:run_sql_file GLAW063I: The path of log file is /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/log/sql/izoa_procedure_create.sql.log.749 dbutil:run_sql_file GLAW036V: Execute SQL file finished: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/sql/izoa_procedure_create.sql.749 featurerun:database_operation GLAW012I: database-create-db of mlbase: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1 finished.750 featurerun:database_operation GLAW012I: database-create-tables of mlbase: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1 finished.759 pgmutil:runCommand GLAW023V: Run python command: submit.submit_job /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/jcl/mlbase_IZOALOC.jcl zos=xxx.xxx.xxx.xxx user=IZOAUSR pwd=***98 submit:submit_job GLAW045V: Start to submit job: /usr/lpp/IBM/zoa/metml_4.1.0.0_inst1/jcl/mlbase_IZOALOC.jcl.No other messages are produced and the script does not end.Cause
The FTP Server started with JESINTERFACELEVEL set to 1 and this prevents the script from receiving the RC=0 from job IZOALOC.
According the documentation:
https://www.ibm.com/docs/en/zos/2.4.0?topic=protocol-jesinterfacelevel-ftp-server-statement
this statement defaults to 1 if not specified.
Resolving The Problem
Specify "JESINTERFACELEVEL 2" in your TCP.DATA member.
The FTP.DATA configuration data set is optional. The FTP daemon searches for this data set during initialization.
The FTP server search order is:
- A data set specified by the //SYSFTPD DD statement
- ftpserve_job_name.FTP.DATA
- /etc/ftp.data
- SYS1.TCPPARMS(FTPDATA)
- hlq.FTP.DATA data set
Refer to the following documentation for further details:
https://www.ibm.com/docs/en/zos/2.4.0?topic=protocol-ftp-configuration-statements-in-ftpdata
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
19 May 2021
UID
ibm16453651