Teradata Forums / Marketing Tips and CRM Best Practices / Teradata

Collect Statistic on IOS tables

Ince — Fri, 09 May 2008 02:54:32 GMT

HiOn the WHERE CLAUSE, do I mention all the tables that I need to collect statistics on?Refer to the script provided on the TCRM maintenance guideline below/**/*----------------------------------------------------------------------------Description:This SQL will generate a Collect Statistics script for all of the columnsof each index in dbc.Indices.Instructions:1. Replace @YOURDATABASENAME w/ the correct DatabaseName2. Modify the "where" clause as necessary to target specific tables3. Execute this SQL and capture the resulting "Collect Stats" scripts4. Execute the resulting Collect Stats script as necessaryRequirements:- Select access to DBC database----------------------------------------------------------------------------*/select (case Min_Poswhen 1 then 'Collect Statistics on ' ||trim(upper(DatabaseName)) || '.' ||trim(upper(TableName)) || ' INDEX ('else ' ,' end) ||trim(upper(ColumnName)) ||(case Max_Poswhen 1 then ');'else '' end)from(selectDatabaseName,TableName,ColumnName,IndexNumber,ColumnPosition,rank() over (partition by DatabaseName, TableName, IndexNumber order by ColumnPosition)Min_Pos,rank() over (partition by DatabaseName, TableName, IndexNumber order by ColumnPositiondesc) Max_Posfrom dbc.Indiceswhere DatabaseName in('@YOURDATABASENAME')and TableName not like all ('IOSV%', 'IOS1%' , 'IOS2%', 'IOS3%', 'IOS4%', 'IOS5%')) xxxorder bydatabasename, tablename, indexnumber, columnposition;/*----------------------------------------------------------------------------Description:This SQL will generate a Collect Statistics script for individual columnsof index fields.Instructions:1. Replace @YOURDATABASENAME w/ the correct DatabaseName2. Modify the "where" clause as necessary to target specific tables3. Execute this SQL and capture the resulting "Collect Stats" scripts4. Execute the resulting Collect Stats script as necessaryRequirements:- Select access to DBC database----------------------------------------------------------------------------*/select'Collect Statistics on ' ||trim(upper(a.TableName)) ||' Column ' ||trim(upper(ColumnName)) ||';' ansfromdbc.indices awhere12.3 Periodic Maintenance Tasks12-63a.DatabaseName = '@YOURDATABASENAME' and-- Modify the TableName where clause to target specific tablesa.TableName like any ('IOS%','WCM%') anda.TableName not like all ('IOSV%', 'IOS1%' , 'IOS2%', 'IOS3%', 'IOS4%', 'IOS5%')order byTableName, ColumnPosition;**/

IOS table statistics

Ryan Murphy — Mon, 05 Nov 2007 21:41:20 GMT

Today I discovered that our IOS_ tables have no statistics defined, and I believe this may be contributing to a significant system performance degradation we're experiencing. Is anyone aware of any best practices documentation covering IOS table statistics? The issue concerns only the IOS_ tables, like IOS_ECAMP and IOS_ECAMP_X_SEG. Our IOS1_[BBBBXXXXXXXX] tables created by segmentation processing do have fresh stats.Thank you,Ryan

Big Batch Running long

Ince — Thu, 08 May 2008 05:57:38 GMT

HiOur big batch have been automatically scheduled to run everyday from 5pm.Mostly it runs fine during the week,but runs long over the weekend.We do our weekly back ups on weekend, and release all the held jobs to run after completing the back ups,but the biggest problem is that it runs for almost 14hours until we kill it.Normally it runs for 30 minutes.Please advice

how tos of CRM ios schd jobs

wannabet — Mon, 14 Apr 2008 13:30:59 GMT

Does anyone have a script that can be used to purge old CRM job executions form the IOS_SCHD_JOBS, IOS_SCHD_TASK, and IOS_SCHD_TASKS tables. Our environment is getting pretty crowded after over a year of testing and production job executions. So crowded that when my users login to CRM they hang at the processing completed jobs step of the login.

Buffers not downloading

Kika — Tue, 08 Apr 2008 04:08:07 GMT

Hi All, our CRM application is not downloading the buffers. we cannot check the setup in metadata as we are unable to log on. if we check in task manager it says Not responding for all component(CPS,RPS, taskBroker) when we restart the services they are not coming up. below is the error in the logs. what could be the problem..970.131 The following error was encountered in a metadata query: Division ID = 0Application ID = 9Section ID = 900Query ID = 11000[NCR][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like a name or a 'ROWID' keyword between '(' and '@'. 12.970.128 EODBC Database Error: SubError: 0 ErrorCode: -1 NativeErrorCode: -3707 Message: [NCR][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like a name or a 'ROWID' keyword between '(' and '@'. CREATE MULTISET TABLE ModelImportTable ( VarFld1 Float ) UNIQUE PRIMARY INDEX (@IndexFields)thanks

CRMIOS Tables and Journaling

Robby — Wed, 11 Apr 2007 15:46:23 GMT

The DBA's would like to turn off Fallback and Journaling on tables in the CRMIOS Database. Specifically, IOS_ECAMP*, IOS_SCHD*, IOS_TBL* as well as others.

Since I came into this job when CRM was already up and going, I am assuming that these are system tables and they shipped as-is with Journaling turned on.

Is there a problem with letting the DBAs turnoff the Journaling on the CRM IOS tables?

EDW Metrics Dashboard

Sam_989898 — Wed, 19 Mar 2008 06:52:41 GMT

Hi - I am looking for some EDW Metrics or sample Dashboards or presentations which can show the value EDW brings to the organization. I appreciate if you have something available to share with meThanks in advanceRam

TCRM Error in TSegTableCreate.BUILDSQL

Krishna Seethamraju — Wed, 20 Feb 2008 14:52:27 GMT

Hi All,I am getting the following error in TCRM. Could you please guide me as to what the issue could be?Error in TSegTableCreate.BUILDSQL : 9.10.10560 Error in TAdHocSqlGen.Run - Part IIITQueryServerRelativeDate.getHardcodedDateFormulaString: The date origin you selected for your floating dates is not setup in the CRM Metadata.Origin date selected: "0

Intelligent cross-selling and up-selling

Charm City CRMer — Thu, 05 Apr 2007 16:07:12 GMT

Hi All,

I have 3 discussion questions that I'd like to throw out to the group.

1) How do you leverage your inbound channel and customer analytics to drive intelligent cross-sell and up-sell initiatives, ensuring the best opportunity is presented to each customer?
2) How much of this process is being done in a real-time environment and how do you derive the business case to justify the IT investment for real-time?
3) Can you share some examples specific to your company/industry?

Adding user functions at TRM environment

Fabio — Wed, 16 Jan 2008 11:37:41 GMT

Hello,I would like to know if someone have already tried to add some user function at TCRM 5.2 or TRM 6.0 environments, to be made available as part of the solution to the users. In Java programming, it is called sometimes as "Add-ins" or "Add-ons" features.Example: For some reason, an user may decide to exclude from the segment an specific person or group of persons, belonging to a specific geographic region, from the current campaign. We would like to add a menu item called "Cancel lead groups" to provide user with this functionality, being this developed by ourselves.Thanks in advanced.

Channel failure - Number of unsent leads

judy — Tue, 30 Oct 2007 21:05:24 GMT

If TCRM channel process fails we'd like to be able to log which communications are affected and the estimated number of leads that have not been sent for each of the communications as a result. Has anybody got any advice on the best way of doing this?

CRM Taskbroker / RPS Services Not found

FJ — Fri, 11 May 2007 02:20:57 GMT

Hi,

(Note:I am doing installation on windows XP)

When i choose to install CRM Online / Offline servers separately.then after

installation of offline server i do get the Taskbroker.exe and RPS.exe but

couldnt find their respective servics.So both of these applications do get

stuck.I know tht offline server should be installed on Win Server 2000 but

could anyone find me the solution so that i can configure it in win XP.

regards,

FJ

TCRM Chinese Help Files

judy — Wed, 05 Sep 2007 03:33:21 GMT

I'm working with a Chinese version of TCRM. Although we have been given some documentation translated from English to Chinese we have been told that there have not been full Chinese Help files developed for TCRM. Does anyone know if there are Chinese Help files available or any plans to develop Help files in Chinese?

Segmentation Module Error

FJ — Mon, 04 Jun 2007 03:14:49 GMT

Hi,

When i create a single-step communication and specify a segment in the segmentation module it gives me following error:

Memory: 25300 Virtual Memory: 18024 PID: 5972 05/21/2007 2:42:45 PM

CPS Form -
CPS Form - 3.10.68 Run Error:
Base CPS
CPS Manager -CPS SERVER=1
Base CPS
CPS Manager -3.10.83 Find Next Segment Error:
Base CPS
Base CPS Database:
CPS Find Next Segment Reset Segment Error:
Base CPS
Base CPS Database: Reset SQL Error: 12.970.131 The following error was encountered in a metadata query:
Division ID = 0
Application ID = 9
Section ID = 10
Query ID = 1003
[NCR][ODBC Teradata Driver][Teradata RDBMS] Column LOCID not found in TEAM2DR.IOS1_BBBBWQPDBBB3T.
12.970.128 EODBC Database Error:
SubError: 0
ErrorCode: -1
NativeErrorCode: -5628
Message: [NCR][ODBC Teradata Driver][Teradata RDBMS] Column LOCID not found in TEAM2DR.IOS1_BBBBWQPDBBB3T.
The offending query was written to file - C:\CIOS\errlog\0x9x10x1003_5976_14t42t39t839.err By Machine - WPKFJ250001-7IX User Name - SYSTEM

Note: This error occures when i create a segment through the GUI of segmentation module.

TCRM Migration

wannabGURU — Thu, 23 Aug 2007 05:56:08 GMT

I recently upgraded my IOS from v5.01.00.00 to v 5.02.00.04. When i create a single step communication and enter the segment tab the following exception appears :

CRM application error : 12.960.80
The following field was not found in the TDataArray: SEED_CAMP_QTY_IND.

I ignored the error, created a segment and when i validated it, it reports that no segments are created. Everytime i revisit the segmentation tab i get the same error.

Please help me out!

2007 Annual Teradata CRM User Group Meeting at Partners Conference, Las Vegas

Carol Barker — Fri, 10 Aug 2007 11:10:19 GMT

MARK YOUR CALENDARS TO ATTEND this year's annual Teradata CRM User Group meeting at the PARTNERS Conference in Las Vegas, Nevada. This year's session will showcase innovative CRM implementations from around the world as winners of our first annual Teradata Marketing Leadership Awards program will take the stage to share highlights of their winning submissions. (to learn more about Teradata Marketing Leadership Awards, visit: www.teradata.com/marketingleadershipawards/2007

Teradata CRM User Group Session
Thursday, October 11, 2007 - 12:30 p.m. - 3:30 p.m.
Location: Mandalay Bay Resort - Meeting Room - Palm D

The Teradata CRM User Group Session is designed to help you expand your knowledge of CRM best practices by supplying you with practical references and techniques for maximizing your return from your Teradata CRM software. You will discover new ideas that you can immediately put to use!

For more information on the Partners conference please visit: http://www.teradata.com/teradata-partners/

And, for more information about Teradata User Groups, please visit: www.teradata.com/cmusergroup

If you're interested in attending, please rsvp to carol.barker@teradata.com

Task Broker's Available Servers Location Problem

Usman Ali — Wed, 08 Aug 2007 04:53:16 GMT

Hi,

I am getting a problem regarding Task Broker's Available Servers Locations in 'Task Server Connections' tab of task broker service properties. Previously it was working fine but then my IP got changed and it still has old 'machine name' (IP) associated with the server names and that’s why their status is 'Inactive' because it can't find it on that IP. I have tried 'Load Servers' and restarting task broker service but that didn't help.
Can anyone tell me how to refresh the location of these servers in Task Broker to the new IP/Machine Name?

Thanks in advance

Regards,
Usman Ali

TCRM 5.2 and Teradata V2R6.2 with Linux

DeAnna — Tue, 10 Apr 2007 14:03:09 GMT

Is anyone out there running TCRM 5.2 with Teradata V2R6.2 with Linux?

ANNOUNCING - FIRST ANNUAL TERADATA CRM Awards Program

Carol Barker — Tue, 01 May 2007 15:51:48 GMT

Attention all TCRM Users!
Announcing the first annual Teradata Marketing Leadership Awards program! This is a competition amongst TCRM users (all versions) designed to honor and showcase organizations that have demonstrated innovative and creative uses of the TCRM application.

The Marketing Leadership Award winners will present their winning submissions at the Teradata Partners CRM User Group meeting in October 2007 in Las Vegas.

There are four categories in which to compete:
*CRM Innovation
*Transforming the Organization
*Customer Strategy
*Rising Star (for newer users of the application)

To find out more and to download the application form, please go to the following web-site:
http://www.teradata.com/marketingleadershipawards/2007

Good luck!

Managing Control Groups within TCRM Application

Rupert at BA — Mon, 05 Feb 2007 05:48:20 GMT

I am very interested to hear other customers using TCRM manage control groups within their communication strategy and campaign plans.

I know that within individual communications it is very easy to set up controls and identify them within the contact history.

However I would like to be able to identify and manage Universal Controls (a fallow group). This group would allow you to assess the true value of all your communications and your relationship with customers via all the channels used, plus maybe a value to a loyalty scheme. Currently I have set up these groups using recurring communications which in ensure that the control has sample of new customers added every month. However, one of the problems is that I would like this group to be churned every so often, plus end users of the application are always having to remember to suppress the group in every communication.

I would also like to be able to set up a Campaign Control which is suppressed from a series of communications which are part of a program against one campaign. So you may have a big launch communication and then a series of follow up communications such as reminders, chasers, qualifiers. I would like to be able to have a group of customers which we ring fenced across the campaign. So at the end of it we can measure total contribution. Does anybody manage groups across campaigns like this and how do they do it within the TCRM application.

Are Follow Ups necessary in Comm. Plans?

chicken & telephone ice cream — Wed, 14 Mar 2007 13:01:43 GMT

Hi,

I was wondering if we can go straight from a Timeout to another Step, instead of going through a Follow Up. IMHO Is there a legacy reason for using Follow Ups? AFAIK I can connect non-terminating Timeouts directly to another step. However, Teradata folks during our setup seem to always use Follow Ups. So, there must be a reason, right?

Thanks,

-- Johnny

CRM - Online Middle Tier

cgard — Thu, 15 Mar 2007 14:03:53 GMT

Has anyone experienced any performance issues this week after the daylight saving time happened? We have seen performance issues on this middle tier server twice this week and I am just checking to see if others have seen similar issues.

Legends Report

kafrynrich — Mon, 12 Mar 2007 10:08:39 GMT

I have a manual report that was created to help show where the database fields are in the legends mapping. I have gotten behind on it since legends and columns are changed and added frequently. Does any one have SQL that they use for a report that is similar to this or do you have any suggestions on a better way to keep up with this report?

Here are the columns that I use and a small sample (I had to pst it this way so that it would show correctly in the posting page):

Columns:
Module
Tab
Table / View
TCRM Segmentation Selection
SQL Field added through TCRM
Category Definition
Time Interval
Field Reference for Time Interval

Data Row 1:
Customer
Absolute
I0023B_ADR
State
ST_PVN_CD
Household
Current
NA

Data Row 2:
Store Location
Region/District
i0050C_LCT
District
DIT_NBR
Store Activity
Year
CAL_DT

Thanks,
Kathryn

Choosing a date range with only the date and month, i.e., without the year

chicken & telephone ice cream — Thu, 15 Feb 2007 15:47:50 GMT

Hi,

When choosing your segment in a communication in the TCRM 5 GUI, is it possible to choose a date range with only the date and month specified, i.e., without specifying the year?

I am talking about the feature that lets you choose between a floating duration and a fixed range.

Thanks.

Process and Resource Alignment

Charm City CRMer — Fri, 26 Jan 2007 11:13:37 GMT

While working on a financial customer's implementation, I discovered they combined the advanced analytics team with the campaign management team. How are other organizations set up? Is this unique for the financial services industry? What are some of the benefits you've found by sharing the resources?

integrating web data into TCRM

tuttlr — Fri, 26 Jan 2007 11:21:56 GMT

It seems that not many organizations have begun adding web browsing behavior data into their data warehouse. Although almost everyone adds web sales data, browsing behavior is an excellent source of behavior data that can be used for campaign targeting and segmentation. Has anyone been successful in applying web based legends to TCRM as targeting attributes? How difficult was it to setup?

Automated Refeshing of CRM Legends

Robby — Tue, 16 Jan 2007 15:20:57 GMT

We currently have over 500 Legends in our CRM Application and we manually refresh Legends as needed using the CRM Metadata application.

Does anyone have a way to automate such a refresh?

Welcome to the Marketing Tips and CRM Best Practices User Discussion Forum!

Carol Barker — Thu, 18 Jan 2007 14:31:34 GMT

This site is intended for CRM practioners, analysts, strategists - anyone with an interest in CRM around the world wanting to share tips and best practices that all users both technical and business will find useful.

This forum is for you, our TCRM customers and we welcome any suggestions for improvement. Keep it alive by posting your thoughts and ideas!

This site will be monitored to ensure your questions and posts will be answered.

Talk to you online soon!

targeting in CRM TERADATA

master251 — Tue, 21 Nov 2006 03:56:17 GMT

I have a rather complex question about the use of the targeting in CRM TERADATA. If I want to make the targeting on a client relationship. For example: For example, is it possible to target the 35 years old customers having a 28 years old wife?. Is it possible? Can i go up in the customer hierarchy to target the spouse?
Thank you

How can I track the use of legends?

murprhp — Mon, 02 Oct 2006 17:34:35 GMT

We have many legends available, and I would like to determine which ones are being referenced in campaigns and how often. Is there a simple way to do this in the GUI, or a query anyone has already written to obtain this information.

Thanks,
Ryan