Who's On?

	Membership:
	Latest: DaptonConsultancyServices
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5206

	People Online:
	Visitors: 411
	Members: 0
	Total: 411

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Will CTP run dbreorg

5 Replies

0 Subscribed to this topic

28 Subscribed to this forum

Sort:

Author

Messages

Ari

Veteran Member

Posts: 49

New Poster

Engaged Reader

Avid Reader

7/12/2013 4:07 PM

Does anyone know how to tell if a CTP will run dbreorg before they run the activate process?

I have run the preview process and it tells me this is where dbreorg will run, but that does not mean the activate process will actually run dbreorg.

This is important to know because on Windows we need to shut down Websphere application servers if dbreorg is going to be run. Of course this means getting everyone out of Lawson.

Thanks in advance for any help.

Kevin Cubillas

Basic Member

Posts: 9

New Poster

Engaged Reader

Avid Reader

7/12/2013 4:18 PM

Before the activate process you can run a dbreorg -lcs to see if the dbreorg process is necessary for the CTP you are working on. It will tell you what will be done by the dbreorg. If it returns a message telling you there are any changes, then you know that this particular CTP isn't going to run it. But if it is going to run it, then you are right in shutting down WAS as that will lock the dictionary.

Ari

Veteran Member

Posts: 49

New Poster

Engaged Reader

Avid Reader

7/12/2013 4:28 PM

Is this done after the update process is run?

I ask this because I would like to know in advance of running the update process so I can prepare the system and get enough warning to users that the system will be unavailable at a certain time.

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

7/12/2013 4:31 PM

If you run in preview mode, then look at your actual preview.log file, it should tell you:
Database patches - None If dbreorg will NOT run, or other information if it will.

TJ Mann

Veteran Member

Posts: 44

New Poster

7/12/2013 4:42 PM

readme file should tell you which table is being dbreorg. i normally search dbreorg in readme file when i download.

CindyW

Veteran Member

Posts: 169

7/15/2013 7:40 PM

We don't apply CTP's to our production system when users are on it. We take it down and apply them after hours.