What are the IM tables for?

Yahoo Archive
1
If you're SQL:



select 'Table Name'=UPper(convert(char(25),t.TABLE_NAME)),

'Record Count'=max(i.rows)

from sysindexes i, INFORMATION_SCHEMA.TABLES t

where t.TABLE_NAME = object_name(i.id)

and t.TABLE_TYPE = 'BASE TABLE'

group by t.TABLE_SCHEMA, t.TABLE_NAME

order by 2 desc







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marco Vissuet
Sent: Wednesday, October 24, 2012 10:26 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: What are the IM tables for?





how did you make a query to see the table sizes?

Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
mvissuet@... <mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@... <mailto:marcov%40pacificcontours.com> >
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of zhandra8829
Sent: Wednesday, October 24, 2012 6:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: What are the IM tables for?

Yes, we are using multi-company but not with Sonic anymore. I think now it's
integrated after 9.05.607.

I think I will ask Epicor if this is a normal size for the intermediary
files.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "Vic Drecchio" <vic.drecchio@...
<mailto:vic.drecchio@...%3cmailto:vic.drecchio@...>
<mailto:vic.drecchio@...>> wrote:
>
> Do you have the multi-company module? They're intermediary tables used
with
> Sonic, I believe.? Been a while, but I know the tables are only *usually*
> used when you have Multicompany
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>] On
Behalf Of
> zhandra8829
> Sent: Wednesday, October 24, 2012 5:35 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] What are the IM tables for?
>
>
>
>
>
> I made a query this morning to check on table sizes (our db is growing
> exponentially)... and I found this:
>
> TABLE SIZE IN GB
> IMJobMtl 9,38
> TranGLC 6,24
> ReplicationLog 4,12
> PartTran 2,32
> IMVendPart 1,73
> GLJrnDtl 1,06
>
> What are the IM tables for? The transaction table makes sense but I am
also
> curious about the ReplicationLog.
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5351 - Release Date: 10/24/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5351 - Release Date: 10/24/12

[Non-text portions of this message have been removed]
2
I made a query this morning to check on table sizes (our db is growing exponentially)... and I found this:

TABLE SIZE IN GB
IMJobMtl 9,38
TranGLC 6,24
ReplicationLog 4,12
PartTran 2,32
IMVendPart 1,73
GLJrnDtl 1,06


What are the IM tables for? The transaction table makes sense but I am also curious about the ReplicationLog.
3
I was told they are some kind of temporary table, Epicor recently gave me a patch called Clear_IM_Tables. I'd call them and ask about it.




________________________________
From: zhandra8829 <zhandra8829@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 24, 2012 5:35 AM
Subject: [Vantage] What are the IM tables for?

I made a query this morning to check on table sizes (our db is growing exponentially)... and I found this:

TABLEÂ Â Â Â Â SIZE IN GB
IMJobMtl   9,38
TranGLCÂ Â Â Â Â Â Â 6,24
ReplicationLog   4,12
PartTran   2,32
IMVendPart   1,73
GLJrnDtl   1,06


What are the IM tables for? The transaction table makes sense but I am also curious about the ReplicationLog.




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
4
Are you running SQL? I run progress and these tables are empty.

As for the Replication Log, It stores records for changed items for all
files that you have in an active replication profile.

Once these records have been replicated to the replication server, they
are supposed to be deleted automatically.

If you are not running replication, this should be empty.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Wednesday, October 24, 2012 9:06 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] What are the IM tables for?





I was told they are some kind of temporary table, Epicor recently gave
me a patch called Clear_IM_Tables. I'd call them and ask about it.

________________________________
From: zhandra8829 <zhandra8829@...
<mailto:zhandra8829%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, October 24, 2012 5:35 AM
Subject: [Vantage] What are the IM tables for?

I made a query this morning to check on table sizes (our db is growing
exponentially)... and I found this:

TABLE SIZE IN GB
IMJobMtl 9,38
TranGLC 6,24
ReplicationLog 4,12
PartTran 2,32
IMVendPart 1,73
GLJrnDtl 1,06

What are the IM tables for? The transaction table makes sense but I am
also curious about the ReplicationLog.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
Do you have the multi-company module? They're intermediary tables used with
Sonic, I believe.? Been a while, but I know the tables are only *usually*
used when you have Multicompany



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
zhandra8829
Sent: Wednesday, October 24, 2012 5:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] What are the IM tables for?





I made a query this morning to check on table sizes (our db is growing
exponentially)... and I found this:

TABLE SIZE IN GB
IMJobMtl 9,38
TranGLC 6,24
ReplicationLog 4,12
PartTran 2,32
IMVendPart 1,73
GLJrnDtl 1,06

What are the IM tables for? The transaction table makes sense but I am also
curious about the ReplicationLog.



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12

[Non-text portions of this message have been removed]
6
Yes, we are using multi-company but not with Sonic anymore. I think now it's integrated after 9.05.607.

I think I will ask Epicor if this is a normal size for the intermediary files.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Do you have the multi-company module? They're intermediary tables used with
> Sonic, I believe.? Been a while, but I know the tables are only *usually*
> used when you have Multicompany
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> zhandra8829
> Sent: Wednesday, October 24, 2012 5:35 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] What are the IM tables for?
>
>
>
>
>
> I made a query this morning to check on table sizes (our db is growing
> exponentially)... and I found this:
>
> TABLE SIZE IN GB
> IMJobMtl 9,38
> TranGLC 6,24
> ReplicationLog 4,12
> PartTran 2,32
> IMVendPart 1,73
> GLJrnDtl 1,06
>
> What are the IM tables for? The transaction table makes sense but I am also
> curious about the ReplicationLog.
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12
>
> [Non-text portions of this message have been removed]
>
7
how did you make a query to see the table sizes?


Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of zhandra8829
Sent: Wednesday, October 24, 2012 6:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: What are the IM tables for?



Yes, we are using multi-company but not with Sonic anymore. I think now it's integrated after 9.05.607.

I think I will ask Epicor if this is a normal size for the intermediary files.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Vic Drecchio" <vic.drecchio@...<mailto:vic.drecchio@...>> wrote:
>
> Do you have the multi-company module? They're intermediary tables used with
> Sonic, I believe.? Been a while, but I know the tables are only *usually*
> used when you have Multicompany
>
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> zhandra8829
> Sent: Wednesday, October 24, 2012 5:35 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] What are the IM tables for?
>
>
>
>
>
> I made a query this morning to check on table sizes (our db is growing
> exponentially)... and I found this:
>
> TABLE SIZE IN GB
> IMJobMtl 9,38
> TranGLC 6,24
> ReplicationLog 4,12
> PartTran 2,32
> IMVendPart 1,73
> GLJrnDtl 1,06
>
> What are the IM tables for? The transaction table makes sense but I am also
> curious about the ReplicationLog.
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com<http://www.avg.com>
> Version: 2012.0.2221 / Virus Database: 2441/5349 - Release Date: 10/23/12
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]