Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Feb 2004 @ 02:42:33 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   TDQM Implementation
 
From:   Arvind Ballari

Hi All,

I am trying to test TDQM Scheduler option on the Teradata Demo Software on my laptop and getting the following error message

 1|SREXE|000948|ServerC:SetDbCntxt|Logon       |00000|000|04-02-11 17:52:10
DB Error: Function=DbmsC:Logon, Stmt#=0, Code=3002, Info=0
Invalid logon account.

and also I have enabled the trace option of the TDQM and got the following from the trace.

*************************************************************************
*************************************************************************
******************************************
21175008: comm DLL attach process = 948
21175008: shm base ptr = 006a0000(x)
21175008: heap ptr = 006a0000(x)
21175008: global ptr = 006a0030(x)
21175018: server DLL attach process = 948
21175018: shm base ptr = 00830000(x)
21175018: heap ptr = 00830000(x)
21175018: host ptr = 00830030(x)
21175018: qmdexec:main
21175018: 101127 0
21175018: job id = 101127
21175018: exec now = 0
21175018: req id = 64275
21175018: min time = 175100
21175018: max time = 175100
21175018: QmsDb:Logon : Teraprd1/dbqrymgr,
21175248: ContextC:Init
21175248: ContextC:Complete
21175248: check rules ...
21175248: -----
21175248: ReqstC:ProcQuery
21175248: QmsDb:ChangeDfltDb : DBC
21175268: stmt : SEL COUNT(*) FROM DBC.ACCOUNTS
21175268: len = 30
21175268: last stmt = 1
21175268: parser path : C:\Program Files\NCR\Teradata DQM\server\
21175288: parser status = 0
21175288: node type : QMParStmt
21175288: adding db : DBC
21175288: adding obj : ACCOUNTS
21175288: node type : QMParQuery
21175288: query type : SELECT
21175288: node type : QMParOption
21175288: node type : QMParItemDesc
21175288: node type : QMParCountStar
21175288: parsed last stmt as SEL = 1
21175288: parsed last stmt as MAC = 0
21175288: ReqstC:ProcOneQry
21175288: PerformQA : Explain SELECT COUNT(*)  FROM DBC.ACCOUNTS     ;
21175328:   1) First, we lock DBC.ACCOUNTS for access.
21175328:   2) Next, we do an all-AMPs SUM step to aggregate from DBC.ACCOUNTS by
21175328:      way of an all-rows scan with no residual conditions.  Aggregate
21175328: UpdateTableOps = 2
21175328: UpdateTableOps : ACCOUNTS
21175328:      Intermediate Results are computed globally, then placed in Spool 3.
21175328: AssocSpoolObj = 3
21175328: AssocSpoolObj : ACCOUNTS
21175328:      The size of Spool 3 is estimated with high confidence to be 1 row.
21175328: rows = 1
21175328:      The estimated time for this step is 0.04 seconds.
21175328: time = 1
21175328:   3) We do an all-AMPs RETRIEVE step from Spool 3 (Last Use) by way of
21175328: FindSpoolObj = 3
21175328:      an all-rows scan into Spool 1 (group_amps), which is built locally
21175328: AssocSpoolObj = 1
21175328: AssocSpoolObj : ACCOUNTS
21175328:      on the AMPs.  The size of Spool 1 is estimated with high
21175328:      confidence to be 1 row.  The estimated time for this step is 0.03
21175328: rows = 1
21175328:      seconds.
21175328: time = 1
21175328:   4) Finally, we send out an END TRANSACTION step to all AMPs involved
21175328:      in processing the request.
21175328:   -> The contents of Spool 1 are sent back to the user as the result of
21175328:      statement 1.
21175328: last rows = 1
21175328: max rows = 1
21175328: cum time = 2
21175328: estimated time = 2
21175328: total est time = 2
21175328: UserC:CheckRestrs : SA03052C
21175328: GroupC:CheckRestrs : DBA
21175328: ReqC:Find&CheckObj : ACCOUNTS
21175328: ReqC:Find&CheckObj : db not restricted
21175328: QmsDb:ChangeDfltDb : dbqrymgr
21175358: vote=53000,stat=0,obj=0,usr=0,val=0,lim=0,fr=0,to=0,req=104,sch=021175358: new min time = 175100
21175358: parsed sql : SELECT COUNT(*)  FROM DBC.ACCOUNTS     ;
21175358: QmdDb:UpdJobStatus = 4
21175468: LOG: QmdDb:AddUpdEntry : CheckResponse : DB Error: Function=DbmsC:CheckResponse, Stmt#=1,
 Code=2802, Info=0Duplicate row error in dbqrymgr.sched_updates.
21175468: LOG: qmdexec:main : UpdateJobStatus : 2
21175468: QmsDb:Logoff
21175508: user logon : Teraprd1/SA03052C,
21175538: user logon error = 99999
21175538: LOG: ServerC:SetDbCntxt : Logon : DB Error: Function=DbmsC:Logon, Stmt#=0, Code=3002, Info=0
Invalid logon account.
21175538: LOG: qmdexec:main : UserLogon : 99999
21175538: qmdexec:FailJob = 6
21175538: QmsDb:Logon : Teraprd1/dbqrymgr,
21176500: QmdDb:UpdJobStatus = 6
21176500: DbErrorMsg.MsgText  : DB Error: Function=DbmsC:Logon, Stmt#=0, Code=3002, Info=0
Invalid logon account.
21176640: QmsDb:Logoff
21176660: server DLL detach process = 948
21176660: comm DLL detach process = 948

*************************************************************************
*************************************************************************
******************************************

When I looked up in the DBC.EventLog, This is what it shows up

 LogonDate    LogonTime   UserName   SessionNo   LogonSource                                                                Event
 2004-02-11   174943      SA03052C   1029        (TCP-IP) 0D4D 127.0.0.1 TERAPRD1   3400  ADMINISTRATOR  TDQMREQP  01 LSS   Logoff
 2004-02-11   174943      SA03052C   1029        (TCP-IP) 0D4D 127.0.0.1 TERAPRD1   3400  ADMINISTRATOR  TDQMREQP           logon
 2004-02-11   175210      SA03052C   1032        (TCP-IP) 0D54 127.0.0.1 TERAPRD1    948  ADMINISTRATOR  TDQMJOB  01 LSS    Bad Account

I would appreciate if someone can help me out to fix this.


Thank You

Arvind



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016