Table TIDYCSHP

Does anyone know what this table is? No activity since 2007:
wma10adv> select substr(time_stamp,1,4), count(*) from tidycshp group by substr(time_stamp,1,4);

SUBS COUNT(*)
---- ----------
3845
2002 437063
2003 549501
2004 436920
2005 482421
2006 467147
2007 148946

7 rows selected.

wma10adv> select segment_id, count(*) from tidycshp group by segment_id;

SEGMENT_ COUNT(*)
-------- ----------
YCSAD 680936
YCSAH 288092
YCSAL 646861
YCSAP 84424
YCSAX 451105
YCSTE 374425

6 rows selected.

Thanks,
Eric

YCSHP is part of COBOL batch Financial Integration

Hi,

YCSHP is part of "FI Connect" COBOL batch. The programs and their tables all begin with "tiby".

This product was discontinued by Ventyx after PassPort version 9 I believe.

Regards

Delete YCSHP table?

Is there a preference or setting that I can check to determine if we are using this app? We upgraded from v6 and v8 to v10 July '07. Currently we are archiving and the 6.5GB allocated for YCSHP would be a prize table to drop.

Thanks,
Eric

So does that mean I can drop

So does that mean I can drop those tables? Is there any preferences /settings that I can check to ensure that we are not using it? The reason I ask is that we are doing an archive and YCSHP is allocated at 6.5GB. We upgraded from v6 & v8 to v10 July '07.

Thanks,
Eric

Need to find out about PassPort interfaces

Hi,

You'll need to find out for certain if PassPort is interfacing with other applications and how it's being done. The timestamp seems to indicate that YCSHP hasn't been used since 2007, but you need to be careful. A good indication of if the COBOL batch is still in use is to check all of the load (Unix bin) directories for load modules beginning with TIBY*.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.