Author Topic: changing to single table strategy deletes (empy) old table on creating new one  (Read 63 times)

davidshe

  • Newbie
  • *
  • Posts: 5
    • View Profile
Hello,

We should add some fields to an application group and that will create new segment tables, as we experienced.
In the meantime, we changed the strategy from "maximum number of rows" to "single table"
At the moment we did an ARSLOAD, a new segment table was created, but the current table is gone.
This only seems to happen when the current table is empty, and not when the current table contains documents.

Example:
Current table is BBA3.
We added a field to the application group and loaded a document with ARSLOAD.
In the joblog, we see that BBA3 was copied (1 record, however it was empty) and deleted (many files BBA3_##).
This happened at the moment we added a new field to the application group, according to the timestamp.
BBA4 was created at the moment we did the ARSLOAD.
BBA4 only contained 1 document, because BBA3 was empty.

All our other tables with the new "single table" strategy still contained documents.
These were not deleted when new segment tables were created.
Is this the way it works: deleting empty ones and leave the other ones as is?

We have to do the same changes in production soon and want to be sure the combination "single table" and adding new fields to the AG (creating new tables) will not have side-effects with deleted data.

Thanks,
Henri

(What happened to this forum? Are topics gone from the iSeries forum?)
« Last Edit: September 10, 2021, 08:38:36 AM by davidshe »

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2072
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
I don't think this is unusual behaviour.  If the table was empty, CMOD cleaned it up.

As for the topics in the forum, they're still there.  Check to make sure you're not 'hiding' the topics you've already read by using the "Show unread posts since last visit" link in the top left corner of the page.  You can double-check by clicking this direct link to the iSeries forum:  http://www.odusergroup.org/forums/index.php/board,12.0.html

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

davidshe

  • Newbie
  • *
  • Posts: 5
    • View Profile
Thanks Justin.

And I only see 3 topics from 2021 in this iSeries forum, of which 2 on today by me, but I guess that's all :D

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2072
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Hi David, no, there's about 100 posts in the iSeries forum.  Not sure why you're nor seeing them. 

Try this link to see all the posts you haven't already read:

http://www.odusergroup.org/forums/index.php?action=unread

Otherwise, send me a DM or eMail and we'll try and figure it out.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR