Journalling in AS400

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP


Journalling in AS400



I used dspjrn command to take the journals for a file in as400. In resultant journal, all decimal fields has become zeros, even if there is a value for those fields in the file. What could be the reason?





(Very uninformed guess) Maybe the file was not encoded in EBCDIC.
– Joop Eggen
4 hours ago





Please show an example of what you are seeing in the journal compared to the data actually in the file. Include all of the entry data
– jmarkmurphy
55 mins ago




1 Answer
1



I can think of two possibilities



1) You're looking at an "after image" for a delete transaction
2) The journal is configured to minimize entry data.



For #1, look at the "before" image if available, or look for the "after" image of the prior insert/update.



For #2, Look at the Minimize entry data setting show via Work with Journal Attributes (WRKJRNA)



The available options as shown here Create Journal (CRTJRN) - MINENTDTA parameter



Minimize entry specific data (MINENTDTA) Specifies which object types
allow journal entries to have minimized entry specific data.



Journal receivers using the *FLDBDY option to minimize the entry
specific data cannot be saved and restored to any release prior to
V5R4M0 nor can they be replicated to any remote journal on a system at
a release prior to V5R4M0. See the Journal management topic collection
in the IBM i Information Center at
http://www.ibm.com/systems/i/infocenter/ for restrictions and usage of
journal entries with minimized entry specific data.



*NONE No object type allows a journal entry with minimized entry specific data. Journal entries for all journaled objects will be
deposited in the journal with complete entry specific data.
*FILE Journaled files may have journal entries deposited with minimized entry specific data. The minimizing will not occur on field
boundaries. Therefore, the entry specific data may not be viewable and
may not be used for auditing purposes. This value cannot be specified
if *FLDBDY is specified.
*FLDBDY Journaled files may have journal entries deposited with minimized entry specific data. The minimizing for journaled files will
occur on field boundaries. Therefore, the entry specific data will be
viewable and may be used for auditing purposes
*DTAARA Journaled data areas may have journal entries deposited with minimized entry specific data.






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

Makefile test if variable is not empty

Makefile test if variable is not empty In a makefile I'm trying to I've created this simplified makefile to demonstrate my problem. Neither make a or make b executes the body of the if, I don't understand why not. make a make b .PHONY: a b a: $(eval MY_VAR = $(shell echo whatever)) @echo MY_VAR is $(MY_VAR) $(info $(MY_VAR)) ifneq ($(strip $(MY_VAR)),) @echo "should be executed" endif @echo done b: $(eval MY_VAR = $(shell echo '')) @echo MY_VAR is $(MY_VAR) $(info $(MY_VAR)) ifneq ($(strip $(MY_VAR)),) @echo "should not be executed" endif @echo done I'm using $ make --version GNU Make 3.81 There are several problems, and misunderstandings. Your MY_VAR is a make variable, set it without a <tab> to its value, and no need to $(eval ...) . MY_VAR:=$(shell echo whatever) is enough. No <tab> before $(info ...) neither, this is make – Zelnes ...
Read more

Will Oldham

Image
"Palace Music" redirects here. For the racehorse, see Palace Music (horse). Bonnie 'Prince' Billy Will Oldham, June 6, 2009 Background information Birth name William Oldham Also known as Palace Brothers Palace Music Bonnie 'Prince' Billy Born ( 1970-12-24 ) December 24, 1970 (age 47) Louisville, Kentucky, United States Genres Folk alternative country country freak folk [1] Years active 1993–present Labels Drag City, Domino, Spunk Associated acts Dawn McCarthy, The Cairo Gang, Mekons, Matt Sweeney, Mick Turner, Tortoise, Trembling Bells, Harem Scarem, The Picket Line, Alex Neilson, Björk, Slint Website www.bonnieprincebilly.com Will Oldham (born December 24, 1970), better known by the stage name Bonnie 'Prince' Billy , is an American singer-songwriter and actor. From 1993 to 1997, he performed and recorded under variations of the Palace name, including the Palace Brothers, Palace Songs, and Palace Music. After releasing material under his own name,...
Read more

'Series' object is not callable Error / Statsmodels illegal variable name

Image
Clash Royale CLAN TAG #URR8PPP 'Series' object is not callable Error / Statsmodels illegal variable name Update: You can download my dataset here. I am running a simple OLS regression with statsmodels and pandas dataframe as following: import statsmodels.formula.api as sm import pandas as pd df=pd.read_csv("exp.csv") #df is a dataframe that I have containing many variable names such as AAPL, SPY, INF, etc. for column in df: result=sm.ols(formula="SPY"+" ~ "+column, data=df).fit() However, one of the column name in df is INF . I guess maybe INF is a reserved word for pasty, the code gives me the following error: INF INF Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/home/ap248/.local/easybuild/software/2017/Core/miniconda2/4.3.27/lib/python2.7/site-packages/statsmodels/base/model.py", line 155, in from_formula missing=missing) File "/home/ap248/.local/easybuild/softw...
Read more