Original message: By: mary
>I am trying to establish automated data transfer from DB2 to MS SQL. I have established
>a
WET file and a Windows BAT file that appears to execute but no data transfer appears
>to
take place. Can anyone help?
>
>--------------------------------------------------------------------------
>
>SQL_BATCH.bat
>"C:\Program Files\Synametrics Technologies\WinSQL\winsql.exe" -xNPT_PRDRL_MVS_LPAR_D.wet
>
/gc:\NPT_PRDRL_MVS_LPAR_D_debug.txt /oc:\NPT_PRDRL_MVS_LPAR_D_error.txt
>/A
>
>
-------------------------------------------------------------------------
>WET File(ID and pwd removed
>
>
>
>odbc
> 49
> *******
> ************
> NPT
> *******
> ************
> CP DB
> PRDRL_MVS_LPAR_D
> dbo
>
>
> "MVS_SYSTEM_ID",
"LPAR_NAME", "PROCESSOR_TYPE", "CPU_SERIAL_NO", "PRSM_FLAGS", "LPAR_FLAGS",
>"PROCESSOR_FLAGS", "RECORD_LEVEL", "FROM_LPAR_NO", "LPAR_NO", "CPU_MODEL_NO", "PHYS_PROCESSORS",
>"LOGICAL_PROCESSORS",
"DEDICATED_PROC_IND", "NONDED_PROCESSORS", "LPAR_WEIGHT", "LPAR_WEIGHT_TOT",
>"DISPATCH_INTERVAL", "MEASURED_SEC", "CPU_DISPATCH_SEC", "CPU_EFF_DISP_SEC", "CPU_WAIT_SEC",
>"COMPLEX_SEC",
"LPROC_SEC", "DEDICAT_PROC_LPAR", "CAPACITY_LIMIT_MSU", "NUM_CONSUMED_MSU",
>"WLM_CAPPING_PCT", "CENTRAL_STOR_FRAME", "EXPAND_STOR_FRAME", "PHY_PROCESSORS_CP",
>"PHY_PROCESSORS_ICF",
"LPROC_CP_SHARED", "LPROC_ICF_SHARED", "LP_ONLINE_SEC", "COUNT_SHR",
>"WEIGHT_ACTUAL", "PHYS_PROC_LPAR", "MIPS_PER_LPAR", "MIPS_PER_LOG_CP", "CPU_BUSY_MIPS",
>"PHY_PROC_SPP_IFA",
"PHY_PROC_SPP_IFL", "PHY_PROC_SPP_ICF", "LOGICAL_PROC_TOT", "DEDICAT_PROCESSORS",
>"PHY_PROC_SPP_IIP")
values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
>?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?,
>?, ?)]]>
>
>
>
> DATE
> 1
>
>
>
> PERIOD_NAME
> 1
>
>
>
> MVS_SYSTEM_ID
> 1
>
>
>
> LPAR_NAME
> 1
>
>
>
> PROCESSOR_TYPE
> 1
>
>
>
> CPU_SERIAL_NO
> 1
>
>
>
> PRSM_FLAGS
> 1
>
>
>
> LPAR_FLAGS
> 1
>
>
>
> PROCESSOR_FLAGS
> 1
>
>
>
> RECORD_LEVEL
> 1
>
>
>
> FROM_LPAR_NO
> 1
>
>
>
> LPAR_NO
> 1
>
>
>
> CPU_MODEL_NO
> 1
>
>
>
> PHYS_PROCESSORS
> 1
>
>
>
> LOGICAL_PROCESSORS
> 1
>
>
>
> DEDICATED_PROC_IND
> 1
>
>
>
> NONDED_PROCESSORS
> 1
>
>
>
> LPAR_WEIGHT
> 1
>
>
>
> LPAR_WEIGHT_TOT
> 1
>
>
>
> DISPATCH_INTERVAL
> 1
>
>
>
> MEASURED_SEC
> 1
>
>
>
> CPU_DISPATCH_SEC
> 1
>
>
>
> CPU_EFF_DISP_SEC
> 1
>
>
>
> CPU_WAIT_SEC
> 1
>
>
>
> COMPLEX_SEC
> 1
>
>
>
> LPROC_SEC
> 1
>
>
>
> DEDICAT_PROC_LPAR
> 1
>
>
>
> CAPACITY_LIMIT_MSU
> 1
>
>
>
> NUM_CONSUMED_MSU
> 1
>
>
>
> WLM_CAPPING_PCT
> 1
>
>
>
> CENTRAL_STOR_FRAME
> 1
>
>
>
> EXPAND_STOR_FRAME
> 1
>
>
>
> PHY_PROCESSORS_CP
> 1
>
>
>
> PHY_PROCESSORS_ICF
> 1
>
>
>
> LPROC_CP_SHARED
> 1
>
>
>
> LPROC_ICF_SHARED
> 1
>
>
>
> LP_ONLINE_SEC
> 1
>
>
>
> COUNT_SHR
> 1
>
>
>
> WEIGHT_ACTUAL
> 1
>
>
>
> PHYS_PROC_LPAR
> 1
>
>
>
> MIPS_PER_LPAR
> 1
>
>
>
> MIPS_PER_LOG_CP
> 1
>
>
>
> CPU_BUSY_MIPS
> 1
>
>
>
> PHY_PROC_SPP_IFA
> 1
>
>
>
> PHY_PROC_SPP_IFL
> 1
>
>
>
> PHY_PROC_SPP_ICF
> 1
>
>
>
> LOGICAL_PROC_TOT
> 1
>
>
>
> DEDICAT_PROCESSORS
> 1
>
>
>
> PHY_PROC_SPP_IIP
> 1
>
>
>
>
>
>
>-------------------------------------------------------------------------
>
>Serial Number: ************************
>WinSQL Version: 7.0.85.597
>WinSQL Edition: Professional
>DBMS Name: Microsoft SQL Server
>DBMS Version: 09.00.3042
>Driver Name: SQLSRV32.DLL
>Driver Version: 03.85.1117
>Driver Vendor: SQL Server
>WinSQL Plugin: C:\Program Files\Synametrics Technologies\WinSQL\wsxMimer.xml
>ODBC
Version: 03.52
>OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
>
>Log
>
---
>11/10/2008 7:30:09 AM; New data transfer started
>11/10/2008 7:30:27 AM; Transfer complete.
>11/10/2008 7:30:29 AM; New data transfer started
>11/10/2008 7:30:39 AM; Transfer complete.
>11/10/2008 7:30:41 AM; New data transfer started
>11/10/2008 7:30:42 AM; Transfer complete.
>11/10/2008 7:30:44 AM; New data transfer started
>11/10/2008 7:30:46 AM; Transfer complete.
>11/10/2008 7:30:48 AM; New data transfer started
>11/10/2008 7:30:48 AM; Transfer complete.
>11/10/2008 7:30:50 AM; New data transfer started
>11/10/2008 7:30:59 AM; Transfer complete.
>11/10/2008 7:31:01 AM; New data transfer started
>11/10/2008 7:31:06 AM; Transfer complete.
>11/10/2008 7:31:08 AM; New data transfer started
>11/10/2008 7:31:30 AM; Transfer complete.
>11/10/2008 7:31:33 AM; New data transfer started
>11/10/2008 7:31:34 AM; Transfer complete.
>11/10/2008 7:31:35 AM; New data transfer started
>11/10/2008 7:31:37 AM; Transfer complete.
>11/10/2008 7:31:39 AM; New data transfer started
>11/10/2008 7:31:39 AM; Transfer complete.
>11/10/2008 7:31:41 AM; New data transfer started
>11/10/2008 7:31:43 AM; Transfer complete.
>11/10/2008 7:31:44 AM; New data transfer started
>11/10/2008 7:31:45 AM; Transfer complete.
>11/10/2008 7:31:46 AM; New data transfer started
>11/10/2008 7:31:47 AM; Transfer complete.
>11/10/2008 7:31:49 AM; New data transfer started
>11/10/2008 7:31:49 AM; Transfer complete.
>11/10/2008 7:31:51 AM; New data transfer started
>11/10/2008 7:31:58 AM; Warning: SQL Error State:01517, Native Error Code: 0, ODBC
>Error:
[IBM][CLI Driver][DB2/AIX64] SQLSTATE 01517: A character that could not be
>converted was replaced with a substitute character.
>
>11/10/2008 7:32:02 AM; Warning: SQL Error State:01517, Native Error Code: 0, ODBC
>Error:
[IBM][CLI Driver][DB2/AIX64] SQLSTATE 01517: A character that could not be
>converted was replaced with a substitute character.
>
>11/10/2008 7:32:08 AM; Warning: SQL Error State:01517, Native Error Code: 0, ODBC
>Error:
[IBM][CLI Driver][DB2/AIX64] SQLSTATE 01517: A character that could not be
>converted was replaced with a substitute character.
>
>11/10/2008 7:32:13 AM; Warning: SQL Error State:01517, Native Error Code: 0, ODBC
>Error:
[IBM][CLI Driver][DB2/AIX64] SQLSTATE 01517: A character that could not be
>converted was replaced with a substitute character.
>
>11/10/2008 7:32:16 AM; Transfer complete.
