RPG Programming Standards
If you send me an email charliebrowne99@gmail.com I will return a standards document /////////////////////////////// We have this doc to explain our standards but it’s a little bit old. http://www.wminformatica.com/PDFs/TPNORMAS-ing.PDF It was made before /Free… Regards, Wilson
View Answer
| September 23, 2009 9:42 PM
AS/400, CL, Documentation, IBM, RPG, standards and methodology
If you send me an email charliebrowne99@gmail.com I will return a standards document /////////////////////////////// We have this doc to explain our standards but it’s a little bit old. http://www.wminformatica.com/PDFs/TPNORMAS-ing.PDF It was made before /Free… Regards, Wilson
View Answer
| September 23, 2009 9:42 PM
AS/400, CL, Documentation, IBM, RPG, standards and methodology
Damaged Object unable to remove
What are the errors received when you try to delete the object with DLTF, OPSNAV & PDM? For a work around, try creating a lib starting with ‘Z’ (so it will be the last library) then use MOVOBJ on the damaged object to the ‘Z’ library. It will be the only object in the library [...]
View Answer
| September 23, 2009 9:16 PM
IBM 810, OS/400, OS/400 Damaged Object
What are the errors received when you try to delete the object with DLTF, OPSNAV & PDM? For a work around, try creating a lib starting with ‘Z’ (so it will be the last library) then use MOVOBJ on the damaged object to the ‘Z’ library. It will be the only object in the library [...]
View Answer
| September 23, 2009 9:16 PM
IBM 810, OS/400, OS/400 Damaged Object
Nominate a member for our latest Panasonic flatscreen giveaway
Please nominate your fellow community members below in the “Discussion” section. Thanks! —————————- We solve problems as a team — this process doesn’t feel team friendly Phil ————————— Wouldn’t you like to reward your team members for their contributions/support ? Recognizing other’s value is very team friendly from my point of view. ————————– Hi Phil, [...]
View Answer
| September 23, 2009 5:36 PM
AS/400, Contests, Data Center, Exchange, Flatscreen, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Panasonic, Security, SQL Server, Storage, Virtualization, VoIP
Please nominate your fellow community members below in the “Discussion” section. Thanks! —————————- We solve problems as a team — this process doesn’t feel team friendly Phil ————————— Wouldn’t you like to reward your team members for their contributions/support ? Recognizing other’s value is very team friendly from my point of view. ————————– Hi Phil, [...]
View Answer
| September 23, 2009 5:36 PM
AS/400, Contests, Data Center, Exchange, Flatscreen, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Panasonic, Security, SQL Server, Storage, Virtualization, VoIP
Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?
the short answer is YES. the longer answer includes having TNSNAMES set properly on your mainframe and of course and DBLINKS needed and the network in place. I have worked with an application system with a similar setup. Good luck
View Answer
| September 23, 2009 4:55 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
the short answer is YES. the longer answer includes having TNSNAMES set properly on your mainframe and of course and DBLINKS needed and the network in place. I have worked with an application system with a similar setup. Good luck
View Answer
| September 23, 2009 4:55 PM
COBOL, DB2, Mainframe, Oracle, SQL, Unix
db2 os/390 v8 utility unload template parms
UNIT=(SYSDA,10) means that up to 10 volumes will be searched for additional space if needed. So, if the template does not support it I guess you cannot use it. However, I would think your SMS would be setup by storage groups and the searching of additional volumes should be automagic. To test if SMS is [...]
View Answer
| September 23, 2009 4:50 PM
DB2, DB2 8.x, DSNTIAUL, OS/390
UNIT=(SYSDA,10) means that up to 10 volumes will be searched for additional space if needed. So, if the template does not support it I guess you cannot use it. However, I would think your SMS would be setup by storage groups and the searching of additional volumes should be automagic. To test if SMS is [...]
View Answer
| September 23, 2009 4:50 PM
DB2, DB2 8.x, DSNTIAUL, OS/390
Running Vmware on Intel or AMD Laptop
I assume that you are talking about running VMware Workstation or VMware Server on your laptop? If so that’ll be fine. My laptop has much worse specs than that and works fine.
View Answer
| September 23, 2009 2:36 AM
Hardware, Intel Core 2 Duo, VMware
I assume that you are talking about running VMware Workstation or VMware Server on your laptop? If so that’ll be fine. My laptop has much worse specs than that and works fine.
View Answer
| September 23, 2009 2:36 AM
Hardware, Intel Core 2 Duo, VMware
Dell PowerEdge 2800, 5 physical Maxtor’s, 1 RAID 5. RAID controller or hdd failure?
Just because it was safely packaged doesn’t mean that it wasn’t mishandled or something hasn’t come disconnected. There’s a chance the system has lost its configuration due to a CMOS battery failure.
View Answer
| September 22, 2009 5:20 PM
Dell PowerEdge 2800, LSI Logic PERC, RAID 5, RAID controllers
Just because it was safely packaged doesn’t mean that it wasn’t mishandled or something hasn’t come disconnected. There’s a chance the system has lost its configuration due to a CMOS battery failure.
View Answer
| September 22, 2009 5:20 PM
Dell PowerEdge 2800, LSI Logic PERC, RAID 5, RAID controllers
Green data center: Advice on topology; resources
BrunsPak (http://www.bruns-pak.com/) has made a number of presentations at the computer user’s group SHARE (www.share.org) on data center design. You might check SHARE meeting proceedings or contact BrunsPak for help. BrunsPak has a number of papers on their web site as well.
View Answer
| September 22, 2009 5:03 PM
Data center design, Data Center management, Data Center Topology, Green data center
BrunsPak (http://www.bruns-pak.com/) has made a number of presentations at the computer user’s group SHARE (www.share.org) on data center design. You might check SHARE meeting proceedings or contact BrunsPak for help. BrunsPak has a number of papers on their web site as well.
View Answer
| September 22, 2009 5:03 PM
Data center design, Data Center management, Data Center Topology, Green data center
DSNTEP2 output problem
Hi Jonty, Don’t use tep2. Use DSNTIAUL with the SQL parameter. No header rows will be created. just select * from table ========================= a little clarification… TEP2 is not SPUFI in batch. TEP2 is an entirely different program. SPUFI is only used via ISPF. DSNTEP2 is a sample program supplied with DB2 that we all [...]
View Answer
| September 22, 2009 4:30 PM
DB2, DSNTEP2, JCL, REXX, SQL
Hi Jonty, Don’t use tep2. Use DSNTIAUL with the SQL parameter. No header rows will be created. just select * from table ========================= a little clarification… TEP2 is not SPUFI in batch. TEP2 is an entirely different program. SPUFI is only used via ISPF. DSNTEP2 is a sample program supplied with DB2 that we all [...]
View Answer
| September 22, 2009 4:30 PM
DB2, DSNTEP2, JCL, REXX, SQL
DB2 Select on a large number of rows/
you say “using SQL embedded in a JCL” which leads me to think something like DSNTEP2. So the answer is that I am unaware of anyway to do this with a file. HOWEVER, you could use a DB2 table. SELECT A.FELD1, A.FIELD2, B.FIELD1, B.FIELD2 FROM tableA A, tableB B where A.acc = b.acc AND a.acc [...]
View Answer
| September 22, 2009 2:11 PM
DB2, JCL, SQL
you say “using SQL embedded in a JCL” which leads me to think something like DSNTEP2. So the answer is that I am unaware of anyway to do this with a file. HOWEVER, you could use a DB2 table. SELECT A.FELD1, A.FIELD2, B.FIELD1, B.FIELD2 FROM tableA A, tableB B where A.acc = b.acc AND a.acc [...]
View Answer
| September 22, 2009 2:11 PM
DB2, JCL, SQL
Extracting data from a DB2 table using IKJEFT01
IKJEFT01 is TSO. I think you may need a little more understanding of NULL. Anything outside of DB2 would not comprehend NULL values as defined in DB2. When DB2 shows a value as NULL, it is based upon an indicator (the null indicator). There actually is data of some kind in the column. After all, [...]
View Answer
| September 22, 2009 2:04 PM
DB2, DB2 Table, IKJEFT01, SQL Query
IKJEFT01 is TSO. I think you may need a little more understanding of NULL. Anything outside of DB2 would not comprehend NULL values as defined in DB2. When DB2 shows a value as NULL, it is based upon an indicator (the null indicator). There actually is data of some kind in the column. After all, [...]
View Answer
| September 22, 2009 2:04 PM
DB2, DB2 Table, IKJEFT01, SQL Query
using two way radios in data centers.
Servers don’t use radio frequencies. Two way radios shouldn’t interfere with servers at all. ********************************************************************* As Mrdenny said servers do not use radio frequencies. If there is any wireless equipment being used you might want to check and see if there will be any interference. Accourding to <a href=”http://en.wikipedia.org/wiki/Family_Radio_Service”>This site</a> Most of the common walkie [...]
View Answer
| September 22, 2009 12:33 AM
Data center operations, Server Frequencies
Servers don’t use radio frequencies. Two way radios shouldn’t interfere with servers at all. ********************************************************************* As Mrdenny said servers do not use radio frequencies. If there is any wireless equipment being used you might want to check and see if there will be any interference. Accourding to <a href=”http://en.wikipedia.org/wiki/Family_Radio_Service”>This site</a> Most of the common walkie [...]
View Answer
| September 22, 2009 12:33 AM
Data center operations, Server Frequencies
How can I link 4 desk top units, 4 printers, 2 faxes into a network?
Sure it can. You’ll need a home/small office router from Frys, Best Buy, etc. You’ll probably need a network switch, as most small routers only have 4 network ports on them. Connect the cable/DSL modem to the uplink of the router. Connect one port of the network switch to one of the LAN ports on [...]
View Answer
| September 20, 2009 7:40 PM
Mac OS, Mac OS X, Network connectivity, Network Topology, Tiger
Sure it can. You’ll need a home/small office router from Frys, Best Buy, etc. You’ll probably need a network switch, as most small routers only have 4 network ports on them. Connect the cable/DSL modem to the uplink of the router. Connect one port of the network switch to one of the LAN ports on [...]
View Answer
| September 20, 2009 7:40 PM
Mac OS, Mac OS X, Network connectivity, Network Topology, Tiger
Can I get tech support if I run Solaris on Hyper-V?
Solaris isnt’ a current suporte Guest OS under Hyper-V AFAICT see <a href=”http://www.microsoft.com/windowsserver2008/en/us/hyperv-supported-guest-os.aspx”>http://www.microsoft.com/windowsserver2008/en/us/hyperv-supported-guest-os.aspx</a>
View Answer
| September 19, 2009 1:25 AM
Hyper-V, Microsoft virtualization, Solaris, Solaris on Hyper-V
Solaris isnt’ a current suporte Guest OS under Hyper-V AFAICT see <a href=”http://www.microsoft.com/windowsserver2008/en/us/hyperv-supported-guest-os.aspx”>http://www.microsoft.com/windowsserver2008/en/us/hyperv-supported-guest-os.aspx</a>
View Answer
| September 19, 2009 1:25 AM
Hyper-V, Microsoft virtualization, Solaris, Solaris on Hyper-V
rollover cable
It depends on the switch. Serial to RJ45 is standard for Cisco switches.
View Answer
| September 18, 2009 10:59 PM
Cable networks, Cables, Network switches
It depends on the switch. Serial to RJ45 is standard for Cisco switches.
View Answer
| September 18, 2009 10:59 PM
Cable networks, Cables, Network switches
Complete System Backup SQL Server
You didn’t provide any information about how you are backing up the systems. If you are doing a backup within SQL via a SQL Agent Job, then you are backing up the SQL Server. If you are backing up the database, using the SQL module of a backup software package like Commvault, NetBackup, etc then [...]
View Answer
| September 18, 2009 7:59 AM
Activant Solutions, Backup, Dell servers, Prophet 21, SQL Server 2008, Terminal Server
You didn’t provide any information about how you are backing up the systems. If you are doing a backup within SQL via a SQL Agent Job, then you are backing up the SQL Server. If you are backing up the database, using the SQL module of a backup software package like Commvault, NetBackup, etc then [...]
View Answer
| September 18, 2009 7:59 AM
Activant Solutions, Backup, Dell servers, Prophet 21, SQL Server 2008, Terminal Server
Is Hyper-V able to utilize the new features in Intel 5500 series CPUs?
Yes, we leverage SLAT, and the enhancements of the new Intel Chips.
View Answer
| September 16, 2009 1:26 PM
CPU, Hyper-V, Intel, Intel 5500, Microsoft virtualization
Yes, we leverage SLAT, and the enhancements of the new Intel Chips.
View Answer
| September 16, 2009 1:26 PM
CPU, Hyper-V, Intel, Intel 5500, Microsoft virtualization
S/36 RPG program using a Data Area
In th S36 proc can you, before you call the RPG36 program, can you do an allocate object of the *Dtaara, then Release it after the program ends? Or, in the quick program that you wrote, add an additional parm. Then call it twice instead of just once. The first time it does the Lock [...]
View Answer
| September 15, 2009 5:27 PM
AS/400, RPG, RPG IV, S36E
In th S36 proc can you, before you call the RPG36 program, can you do an allocate object of the *Dtaara, then Release it after the program ends? Or, in the quick program that you wrote, add an additional parm. Then call it twice instead of just once. The first time it does the Lock [...]
View Answer
| September 15, 2009 5:27 PM
AS/400, RPG, RPG IV, S36E
What is CTC and ATC and refreshing the RACF?
Without more information and context about where they’re being used, it’s tough to give you a precise definition for these acronyms. For example, CTC could stand for <a href=”http://whatis.techtarget.com/definition/0,,sid9_gci922490,00.html”>Community Technology Center</a> or <a href=”http://searchunifiedcommunications.techtarget.com/sDefinition/0,,sid186_gci1288542,00.html”>Click to Call</a>. RACF most likely stands for an IBM product, Resource Access Control Facility
View Answer
| September 15, 2009 4:29 PM
Acronyms, RACF, Resource Access Control Facility
Without more information and context about where they’re being used, it’s tough to give you a precise definition for these acronyms. For example, CTC could stand for <a href=”http://whatis.techtarget.com/definition/0,,sid9_gci922490,00.html”>Community Technology Center</a> or <a href=”http://searchunifiedcommunications.techtarget.com/sDefinition/0,,sid186_gci1288542,00.html”>Click to Call</a>. RACF most likely stands for an IBM product, Resource Access Control Facility
View Answer
| September 15, 2009 4:29 PM
Acronyms, RACF, Resource Access Control Facility
Is there a way to edit my firewall rules in one place?
When you say server , what is it actually ?? a web server or application server or ?? you can always reroute the traffic , but ensure that the target doesn’t becomes a bottleneck.. I would still wait for more information before i can comment further..
View Answer
| September 15, 2009 4:23 PM
Firewall configuration, firewall rules, Firewalls, Network security, Network traffic, Networking, Routing and switching, Servers
When you say server , what is it actually ?? a web server or application server or ?? you can always reroute the traffic , but ensure that the target doesn’t becomes a bottleneck.. I would still wait for more information before i can comment further..
View Answer
| September 15, 2009 4:23 PM
Firewall configuration, firewall rules, Firewalls, Network security, Network traffic, Networking, Routing and switching, Servers
