1.PX job didn't run and only sequence jobs ran!
In the sceneraio i mentioned in a daily basis sequence job run and then PX jobs run but this time something wrong was going on because the majority of PX jobs didnt run only the Sequence jobs ran
Id appreciate your help in advance
Search found 17 matches
- Tue Aug 14, 2012 2:25 pm
- Forum: General
- Topic: Parallel job is not running
- Replies: 6
- Views: 2780
- Mon Aug 13, 2012 5:12 pm
- Forum: General
- Topic: Parallel job is not running
- Replies: 6
- Views: 2780
Parallel job is not running
Good evening Im a beginner with datastage and i need your help please with this scenario In a produccion system in a project A there are hundred of jobs, and when the processes starts ad midnight, everthing seem to be all right since those proesses are monitored throuh a thirdy party schedule tool l...
- Thu May 17, 2012 11:38 am
- Forum: General
- Topic: books for learning IBM infosphere datastage and Teradata SQL
- Replies: 2
- Views: 4022
books for learning IBM infosphere datastage and Teradata SQL
Good afternoon, in the company I work for in a production system has been implemented IBM Infosphere Datstage jobs and by means of Teradata manager can I see some code about Teradata SQL. honestly im new and im kind of lost, so Id appreciate your help if you can help me naming a good material to buy...
- Mon Jan 02, 2012 6:37 pm
- Forum: General
- Topic: explanation for the teradata sql code
- Replies: 2
- Views: 1646
explanation for the teradata sql code
Good afternon : Im new at Teradata and Could anybody explain to me what this query does ? i dont understand the sentence CREATE MULTISET TABLE RCC_DATA.TMP_AboMovM_AcctSubs USING _spVV4 (DATE), _spVV3 (DATE)LOCKING TABLE DWH_DATA.ACCOUNT_SUBSCRIPTION ACCESS CREATE MULTISET TABLE RCC_DATA.TMP_AboMovM...
- Tue Dec 20, 2011 1:50 pm
- Forum: General
- Topic: Understanding the expression USING _spVV0 (DATE)LOCKING TABL
- Replies: 1
- Views: 1150
Understanding the expression USING _spVV0 (DATE)LOCKING TABL
Understanding the expression USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS Good evening Im new at Teradata but in in Teradata Manager Tool in the explain tab i stumbled with the expression: USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS I tried to find out exactly what it means the ab...
- Fri Nov 04, 2011 11:09 am
- Forum: General
- Topic: can i start running a datastage job from the point it fail
- Replies: 1
- Views: 1523
can i start running a datastage job from the point it fail
Good afternoon I need your help please: Let me describe briefly the scenario to understand better my concern: In a Datastage application there are 1 sequential job (controlling job) and about 5 parallel jobs named p1, p2.. to p5. The dataflow for execution is this: sqn1 - p1 -p2 -p3 -p4- p5 - sqn en...
- Sun Jul 31, 2011 4:55 pm
- Forum: General
- Topic: cannot find entries in .odbc.ini file to acces oracle DB
- Replies: 3
- Views: 3344
cannot find entries in .odbc.ini file to acces oracle DB
Good afternoon In Datastage as ETL tool i can connect to differeny RDBS and checkup its configuration by means of .odbc.ini file But checking out this file i can see entries for relevant information to acces the DB like Database, LogonI, Password just for only SQLSEVER database servers (Windowws Ser...
- Tue Jul 26, 2011 2:16 pm
- Forum: General
- Topic: Datasource Connection jobs
- Replies: 1
- Views: 1192
Datasource Connection jobs
Good morning, in a Production System There are hundred of jobs extracting data from heterogenius and operational source RDBS like Oracle, SqlServer In Designer i click on each parallel job and it shows me by means of environment variabales the Database source connection. But the problem is that in a...
- Fri Jul 22, 2011 9:20 am
- Forum: General
- Topic: how to Identify whhich job is connecting to a specific data
- Replies: 0
- Views: 1033
how to Identify whhich job is connecting to a specific data
Im a dummy about Teradata and i have a question in an Production system there are hundreds of process that extracts information from heterogenous and operational database system, thors are RDBS like oracle, sqlserver, sybase etc. In Director Program graphically shows me which tables are accessing be...
- Tue Apr 19, 2011 10:57 am
- Forum: General
- Topic: select command using BTEQ is not returning all fields
- Replies: 4
- Views: 2714
- Mon Apr 18, 2011 9:33 am
- Forum: General
- Topic: select command using BTEQ is not returning all fields
- Replies: 4
- Views: 2714
select command using BTEQ is not returning all fields
Good morning: i need your help: i've got 2 questions: the first one is: i use bteq to connect to Teradata and i want to select the first 5 records of a table but returned just 2 columns. select top 5 * from DWH_LOG.procesos where nom_proceso = 'wedo_sqntbalanceexpire'; *** Query completed. One row f...
- Fri Mar 25, 2011 11:42 am
- Forum: General
- Topic: Teradata]User identification is not authorized error
- Replies: 0
- Views: 2006
Teradata]User identification is not authorized error
Good afternoon I need yor help because i havent been able to Connect to Tearadata using ds command shell: connect Teradata_Pro Enter username for connecting to 'Teradata_Pro' DBMS [dsadm]: dsadm Enter password for dsadm: SQLConnect error: Status = -1 SQLState = S1000 Natcode = -3004 [ODBC:-3004] [IB...
- Thu Mar 24, 2011 2:20 pm
- Forum: General
- Topic: Can i used DMLsentences in DS engine shell ?
- Replies: 4
- Views: 2325
- Thu Mar 24, 2011 1:39 pm
- Forum: General
- Topic: Can i used DMLsentences in DS engine shell ?
- Replies: 4
- Views: 2325
Can i used DMLsentences in DS engine shell ?
good afternoon. Now that i could connect to a Teradadata database using the information provided in the 3 mains files, i tried to run some selet staments but failed. for instance: select P.pARTY_sTART_dT, count(*) SQL+from DWH_DATA.INDIVIDUAL_NAME_HIST INH SQL+inner join DWH_DATA.PARTY P SQL+on INH....
- Tue Mar 15, 2011 7:25 pm
- Forum: General
- Topic: connect to datasources issue
- Replies: 4
- Views: 2893
connect to datasources issue
The scenario is: all the datastages jobs run in a one server i.e 10.80.16.40 (unix server) but the teradata databases server are located in 10.80.4.20 So Under this environment and according what you have explain to me in the above message, in datastage there is not a "interactive" way to ...