AS400 System Value Settings Help?
In our AS400 environment there are several individuals who has *SECADM and *ALLOBJ authority due to some reason, we are trying to investigate few incidents of system value settings which were changed but we don’t who did it, any help or workaround which can lead us to the right path?
Answer Question
| March 8, 2011 2:56 PM
AS/400, AS/400 administration, AS/400 system administration, AS/400 System Values, Audit and compliance
In our AS400 environment there are several individuals who has *SECADM and *ALLOBJ authority due to some reason, we are trying to investigate few incidents of system value settings which were changed but we don’t who did it, any help or workaround which can lead us to the right path?
Answer Question
| March 8, 2011 2:56 PM
AS/400, AS/400 administration, AS/400 system administration, AS/400 System Values, Audit and compliance
What is ovrdbf?
Hi all , Actually I know OVRDBF is used to override database file . After OVRDBF we have to use OPENQRY command But My question is , What purrpose this OVRDBF file created and After creation it will accessible to all the programs at a single time , Means can we access OVRDBF file in [...]
Answer Question
| March 3, 2011 12:28 PM
AS400/OPNQRYF, CLP, OPNQRY, OVRDBF
Hi all , Actually I know OVRDBF is used to override database file . After OVRDBF we have to use OPENQRY command But My question is , What purrpose this OVRDBF file created and After creation it will accessible to all the programs at a single time , Means can we access OVRDBF file in [...]
Answer Question
| March 3, 2011 12:28 PM
AS400/OPNQRYF, CLP, OPNQRY, OVRDBF
Error in job spool – Forecast release DP to SNP
Hi Everyone, I am facing error logs in the batch job which releases forecast from DP to SNP Forecast release job – Weekly – Through background job Forecast category – FA Error 1: – Characteristic combination appears on batch job log with an error that “GMC does not exist ” Even though it exist in [...]
Answer Question
| February 9, 2011 6:13 AM
AS/400 batch jobs, Batch jobs, SAP and data management, SAP error messages, SAP errors
Hi Everyone, I am facing error logs in the batch job which releases forecast from DP to SNP Forecast release job – Weekly – Through background job Forecast category – FA Error 1: – Characteristic combination appears on batch job log with an error that “GMC does not exist ” Even though it exist in [...]
Answer Question
| February 9, 2011 6:13 AM
AS/400 batch jobs, Batch jobs, SAP and data management, SAP error messages, SAP errors
While calling a command via a CL program exposes my command line.
While calling a command via a CL program exposes my command line. Is it possible to hide the command line while executing the command via cl. I need to do this as iam executing the cl with adopted authority.
Answer Question
| February 15, 2011 5:39 AM
AS/400, AS/400 commands, CL Commands, CL Program, CL programming, iSeries
While calling a command via a CL program exposes my command line. Is it possible to hide the command line while executing the command via cl. I need to do this as iam executing the cl with adopted authority.
Answer Question
| February 15, 2011 5:39 AM
AS/400, AS/400 commands, CL Commands, CL Program, CL programming, iSeries
AS400 DB2
How do I access the data in a journal receiver?
Answer Question
| February 9, 2011 9:17 PM
AS/400, AS/400 database, DB2, iSeries, Journal Receivers
How do I access the data in a journal receiver?
Answer Question
| February 9, 2011 9:17 PM
AS/400, AS/400 database, DB2, iSeries, Journal Receivers
Enabling telnet or SSH access into Active Directory
Can I enable telnet or SSH access into an Active Directory server running Windows Server 2008? Can I run normal Active Directory command line commands remotely?
Answer Question
| February 9, 2011 9:11 PM
Active Directory, Active Directory 2008, Command Line Processor, SSH, SSH Configuration, Windows Server 2008
Can I enable telnet or SSH access into an Active Directory server running Windows Server 2008? Can I run normal Active Directory command line commands remotely?
Answer Question
| February 9, 2011 9:11 PM
Active Directory, Active Directory 2008, Command Line Processor, SSH, SSH Configuration, Windows Server 2008
packed & zoned both are used for numeric data types in rpg but if packed occupies 1 byte and zoned occupied 2 bytes then why don’t we use packed?
packed & zoned both are used for numeric data types in rpg/400 but if packed occupies 1 byte and zoned occupies 2 bytes then why don’t we use packed always considering system storage capacity?
Answer Question
| February 8, 2011 5:34 PM
AS/400, RPG Data Fields, RPG/400, Storage capacity planning
packed & zoned both are used for numeric data types in rpg/400 but if packed occupies 1 byte and zoned occupies 2 bytes then why don’t we use packed always considering system storage capacity?
Answer Question
| February 8, 2011 5:34 PM
AS/400, RPG Data Fields, RPG/400, Storage capacity planning
AS/400 backup running twice as long
This week both the SAVCHG and the full sys backup ran twice as long. There were no locked objects or other jobs running and no significant increase is disk capacity used. Any ideas what might cause this or how to even determine why? I did review the log and found no errors. thanks
Answer Question
| November 2, 2011 5:08 PM
AS/400 backup, AS/400 performance, Backup and Recovery, System backups
This week both the SAVCHG and the full sys backup ran twice as long. There were no locked objects or other jobs running and no significant increase is disk capacity used. Any ideas what might cause this or how to even determine why? I did review the log and found no errors. thanks
Answer Question
| November 2, 2011 5:08 PM
AS/400 backup, AS/400 performance, Backup and Recovery, System backups
Executing the savlib command twice
It has been propose to have a hot tape backup in our tape library in a reserved slot. we have 22 available slots the 23rd is reserved for the cleaning cartridge. Slots 1 – 7 are used daily. What they want is to execute a second save library command to let say slot 21. This [...]
Answer Question
| February 15, 2011 2:48 PM
Automated Tape Library, iSeries, SAVLIB, Tape Backups
It has been propose to have a hot tape backup in our tape library in a reserved slot. we have 22 available slots the 23rd is reserved for the cleaning cartridge. Slots 1 – 7 are used daily. What they want is to execute a second save library command to let say slot 21. This [...]
Answer Question
| February 15, 2011 2:48 PM
Automated Tape Library, iSeries, SAVLIB, Tape Backups
Data report from iSeries to a CSV format need page breaks and colors
Hi, I have to send report to our clients in CSV format using data from iSeries. In iSeries I used a text file having one field of 1000 char and used commas as field separators. Is there any way I can send a code for page break once required? Can I do some thing to [...]
Answer Question
| February 10, 2011 2:39 PM
CSV, CSV file format, iSeries
Hi, I have to send report to our clients in CSV format using data from iSeries. In iSeries I used a text file having one field of 1000 char and used commas as field separators. Is there any way I can send a code for page break once required? Can I do some thing to [...]
Answer Question
| February 10, 2011 2:39 PM
CSV, CSV file format, iSeries
iSeries Exit Point for ALL file member changes
I’m looking for an exit point that lets me capture changes to files (not the data in the files). I want to know when the following occur, regardless of the source of the change (ODBC / FTP / Cmd /CL / SEU / PDM / Navigator / SQL / …) member added / renamed / deleted [...]
Answer Question
| February 8, 2011 1:40 PM
AS/400 Exit Points, iSeries administration, iSeries database, V5R4
I’m looking for an exit point that lets me capture changes to files (not the data in the files). I want to know when the following occur, regardless of the source of the change (ODBC / FTP / Cmd /CL / SEU / PDM / Navigator / SQL / …) member added / renamed / deleted [...]
Answer Question
| February 8, 2011 1:40 PM
AS/400 Exit Points, iSeries administration, iSeries database, V5R4
Reducing percentage of temporary addresses in WRKSYSSTS
Hi , Is there is way to reduce % temp addresses in WRKSYSSTS . Is there will be any system issue if this grows ? How we can control it ? Has any one encountred more than 50% of it currently my system is having this status for it . % CPU used . . . [...]
Answer Question
| February 11, 2011 12:28 PM
AS/400 administration, AS/400 system administration, WRKSYSSTS
Hi , Is there is way to reduce % temp addresses in WRKSYSSTS . Is there will be any system issue if this grows ? How we can control it ? Has any one encountred more than 50% of it currently my system is having this status for it . % CPU used . . . [...]
Answer Question
| February 11, 2011 12:28 PM
AS/400 administration, AS/400 system administration, WRKSYSSTS
Finding active disconnected sessions in AS/400
Is there any way to find the Disconnceted session which are still Active on the AS/400 server. I mean the Session is disconneted on the PC (like closing 5250 Display emulator) but the JOB is still runing on the server.
Answer Question
| February 10, 2011 11:28 AM
AS/400 Active Jobs, AS/400 administration, AS/400 sessions, AS/400 user administration
Is there any way to find the Disconnceted session which are still Active on the AS/400 server. I mean the Session is disconneted on the PC (like closing 5250 Display emulator) but the JOB is still runing on the server.
Answer Question
| February 10, 2011 11:28 AM
AS/400 Active Jobs, AS/400 administration, AS/400 sessions, AS/400 user administration
AS400 Query – div by zero
Hi I have a query as follows:- I want to define the following:- Field Column Heading Len Dec PERCENT (t01.amtdol/t02.pvsddl)*100 When I run the query it displays the above field but it converts the percent to +++++++ if the result is zero I need to write this to a database but obviously it won’t because [...]
Answer Question
| February 11, 2011 9:59 AM
AS/400 administration, AS/400 queries, AS/400 Query
Hi I have a query as follows:- I want to define the following:- Field Column Heading Len Dec PERCENT (t01.amtdol/t02.pvsddl)*100 When I run the query it displays the above field but it converts the percent to +++++++ if the result is zero I need to write this to a database but obviously it won’t because [...]
Answer Question
| February 11, 2011 9:59 AM
AS/400 administration, AS/400 queries, AS/400 Query
V5R4 message alarm not working in Windows 7
I have just upgraded to Windows 7. Now when someone sends a message or when RPG performs the display keyword ALARM, no sound comes from the PC. I am on V5R4.
Answer Question
| February 8, 2011 11:00 PM
iSeries, V5R4, Windows 7
I have just upgraded to Windows 7. Now when someone sends a message or when RPG performs the display keyword ALARM, no sound comes from the PC. I am on V5R4.
Answer Question
| February 8, 2011 11:00 PM
iSeries, V5R4, Windows 7
What are your favorite cloud security blogs?
You told us what your favorite IT blogs are, now we want to get a little more specific. Do you have any security blogs or cloud security blogs that you go to for the latest threats and solutions? Share your pick by Wednesday, February 9, 2011, and we’ll give you 50 knowledge points!
Answer Question
| December 30, 2011 8:43 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
You told us what your favorite IT blogs are, now we want to get a little more specific. Do you have any security blogs or cloud security blogs that you go to for the latest threats and solutions? Share your pick by Wednesday, February 9, 2011, and we’ll give you 50 knowledge points!
Answer Question
| December 30, 2011 8:43 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: Drupal’s Building Blocks
Today’s free IT book is an essential addition to any developer’s library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels, all by answering one of five questions and posting the link to your answer in the discussion area below. A particular IP range cannot access internet through ISA [...]
Answer Question
| February 7, 2011 3:35 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Today’s free IT book is an essential addition to any developer’s library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels, all by answering one of five questions and posting the link to your answer in the discussion area below. A particular IP range cannot access internet through ISA [...]
Answer Question
| February 7, 2011 3:35 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Subfile Limit
Hi I am doing an inquiry on the GL and because of our normal monthend date 21/12/10 – 05/02/11, it come up with a message of “number of subfile records has reached the allowable size limit” How can I chage this? On the subfile I have SFLSIZ(0240)
Answer Question
| February 15, 2011 7:36 AM
AS/400 Subfiles, Subfile Control, Subfile Size
Hi I am doing an inquiry on the GL and because of our normal monthend date 21/12/10 – 05/02/11, it come up with a message of “number of subfile records has reached the allowable size limit” How can I chage this? On the subfile I have SFLSIZ(0240)
Answer Question
| February 15, 2011 7:36 AM
AS/400 Subfiles, Subfile Control, Subfile Size
Help with AS/400 array
hi evryone, i’m a beginner with Java and i try this: try{ AS400Array txtarr =new AS400Array(AS400PackedDecimal(55,0),100); parmList[0] = new ProgramParameter(txtarr.toBytes(new BigDecimal(0)),55); ProgramCall pgm = new ProgramCall(sistem,”/qsys.lib/xxx.lib/….pgm”,parmList); in my RPG program i have this: D numcli s 55 0 dim(100) C parm numclie i need get this array from rpg, how can i make this happening, i [...]
Answer Question
| April 8, 2011 9:02 PM
AS/400, iSeries RPG programming, Java, Java classes, RPG ILE, RPG IV, V5R4
hi evryone, i’m a beginner with Java and i try this: try{ AS400Array txtarr =new AS400Array(AS400PackedDecimal(55,0),100); parmList[0] = new ProgramParameter(txtarr.toBytes(new BigDecimal(0)),55); ProgramCall pgm = new ProgramCall(sistem,”/qsys.lib/xxx.lib/….pgm”,parmList); in my RPG program i have this: D numcli s 55 0 dim(100) C parm numclie i need get this array from rpg, how can i make this happening, i [...]
Answer Question
| April 8, 2011 9:02 PM
AS/400, iSeries RPG programming, Java, Java classes, RPG ILE, RPG IV, V5R4
copying archive tapes from jaguar to LTO5
For a migration project I have to copy 1500 jaguar tapes to LTO5. This is a one time activity so I need a connect a robot with LTO5 drives only a limited time (2 years). What LTO5 robots do support BRMS ? I’ve been looking at Quantum Scalar i500 but Quantum say they aren’t compliant [...]
Answer Question
| June 13, 2012 12:05 PM
BRMS, BRMS Backup, Data migration, LTO5, Tape Backups
For a migration project I have to copy 1500 jaguar tapes to LTO5. This is a one time activity so I need a connect a robot with LTO5 drives only a limited time (2 years). What LTO5 robots do support BRMS ? I’ve been looking at Quantum Scalar i500 but Quantum say they aren’t compliant [...]
Answer Question
| June 13, 2012 12:05 PM
BRMS, BRMS Backup, Data migration, LTO5, Tape Backups
