Representing a number in spelled out format
This is easy enough to write. Here’s the pseudocode: Top level: …If the number is zero ……Return “zero” …Call level 2 with trunc(number/1000000000000), “trillion” …Call level 2 with mod(trunc(number/1000000000),1000), “billion” …Call level 2 with mod(trunc(number/1000000),1000), “million” …Call level 2 with mod(trunc(number/1000),1000), “thousand” …Call level 2 with mod(number,1000), “” Level 2: …localNumber = number …If localNumber>=100 [...]
View Answer
| May 14, 2007 4:42 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
This is easy enough to write. Here’s the pseudocode: Top level: …If the number is zero ……Return “zero” …Call level 2 with trunc(number/1000000000000), “trillion” …Call level 2 with mod(trunc(number/1000000000),1000), “billion” …Call level 2 with mod(trunc(number/1000000),1000), “million” …Call level 2 with mod(trunc(number/1000),1000), “thousand” …Call level 2 with mod(number,1000), “” Level 2: …localNumber = number …If localNumber>=100 [...]
View Answer
| May 14, 2007 4:42 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Question on LoadAll Subfile.
Hi Rama The short answer is you can’t. The maximum size of a subfile is 9,999 records and that’s imposed by the operating system. The only way to exceed the 9,999 record limit is to use a single page subfile where your program handles the page up and page down. You then need to use [...]
View Answer
| May 7, 2007 5:01 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi Rama The short answer is you can’t. The maximum size of a subfile is 9,999 records and that’s imposed by the operating system. The only way to exceed the 9,999 record limit is to use a single page subfile where your program handles the page up and page down. You then need to use [...]
View Answer
| May 7, 2007 5:01 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
DNS Packet Drops
You will need to supply more information than that. Your subject field says “DNS Packet Drops”, but your email itself mentions “connectivity”. I say this because most DNS traffic is UDP, and therefore connectionless, and because you only describe the W2003 server as a DHCP server for the 2Wire router. If you write back (to [...]
View Answer
| May 4, 2007 1:00 PM
Availability, Bandwidth, Cabling, DHCP, DNS, Hardware, Hubs, Microsoft Windows, NetBIOS, Network monitoring, Networking, Networking services, Performance management, Ping, Routers, Switches, TCP
You will need to supply more information than that. Your subject field says “DNS Packet Drops”, but your email itself mentions “connectivity”. I say this because most DNS traffic is UDP, and therefore connectionless, and because you only describe the W2003 server as a DHCP server for the 2Wire router. If you write back (to [...]
View Answer
| May 4, 2007 1:00 PM
Availability, Bandwidth, Cabling, DHCP, DNS, Hardware, Hubs, Microsoft Windows, NetBIOS, Network monitoring, Networking, Networking services, Performance management, Ping, Routers, Switches, TCP
Access internal web server with domain name
There are several factors, depending on how you have things set up. If your internal clients can access the web in general, then it’s just a matter of adding the web server address to the DNS. This will depend to some extent on whether your internal domain name and external domain name are set up. [...]
View Answer
| May 4, 2007 12:50 PM
Desktops, DHCP, DNS, Management, Microsoft Windows, Networking services, OS, Security, Servers, SQL Server
There are several factors, depending on how you have things set up. If your internal clients can access the web in general, then it’s just a matter of adding the web server address to the DNS. This will depend to some extent on whether your internal domain name and external domain name are set up. [...]
View Answer
| May 4, 2007 12:50 PM
Desktops, DHCP, DNS, Management, Microsoft Windows, Networking services, OS, Security, Servers, SQL Server
Strange keyboard problem after network logon.
Only general advice… 1) Have you put a sniffer on the port to see if there is any traffic that might correspond? 2) Get the utilities regmon, filemon, and process monitor from microsoft technet/sysinternals (or just www.sysinternals.com) and monitor all activity through that problem. Anyone who has read many of my posts will know that [...]
View Answer
| May 2, 2007 4:15 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Only general advice… 1) Have you put a sniffer on the port to see if there is any traffic that might correspond? 2) Get the utilities regmon, filemon, and process monitor from microsoft technet/sysinternals (or just www.sysinternals.com) and monitor all activity through that problem. Anyone who has read many of my posts will know that [...]
View Answer
| May 2, 2007 4:15 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Laptop Won’t Read SD Card
I believe that the 6-in-1 media reader that you have installed in this notebook does not support a 2 GB media. I think it tops out at 1 GB. Can you read media of 1 GB or less on your notebook? Can this card be read in some other reader? I had customer with HP/Compaq [...]
View Answer
| May 2, 2007 9:28 AM
Hardware
I believe that the 6-in-1 media reader that you have installed in this notebook does not support a 2 GB media. I think it tops out at 1 GB. Can you read media of 1 GB or less on your notebook? Can this card be read in some other reader? I had customer with HP/Compaq [...]
View Answer
| May 2, 2007 9:28 AM
Hardware
SUBNETTING
Start finding the subnet. 192.168.100.32 255.255.255.224, the first address is 192.168.100.32, the number of addr. in the subnet is .255 subtrackted with .224 equals 31, 31 added to .32 equals .63 So the first addr is .32 and the last is .63 which means you have 32 ip addr. in the subnet, but you can [...]
View Answer
| May 2, 2007 5:34 AM
Cabling, Cisco, Hardware, Hubs, Networking, Routers, Switches
Start finding the subnet. 192.168.100.32 255.255.255.224, the first address is 192.168.100.32, the number of addr. in the subnet is .255 subtrackted with .224 equals 31, 31 added to .32 equals .63 So the first addr is .32 and the last is .63 which means you have 32 ip addr. in the subnet, but you can [...]
View Answer
| May 2, 2007 5:34 AM
Cabling, Cisco, Hardware, Hubs, Networking, Routers, Switches
CONTROL-M Performance Degradation
The first things I’d recommend checking are memory usage and disk usage – both normal files, and the swap file. If you are running it in a distributed environment, then I’d also recommend monitoring network traffic to see if there might be a bottleneck there. Good luck, Bob
View Answer
| May 1, 2007 1:16 AM
Basis, DataCenter, SAP, SAP APO
The first things I’d recommend checking are memory usage and disk usage – both normal files, and the swap file. If you are running it in a distributed environment, then I’d also recommend monitoring network traffic to see if there might be a bottleneck there. Good luck, Bob
View Answer
| May 1, 2007 1:16 AM
Basis, DataCenter, SAP, SAP APO
Passwords
I’ve done this successfully on PCs, I’ve never heard, or seen a way to successfully display an AS/400 password. IBM has locked this down well. Don’t be completely discourage. To obtain the user profile information and a ton of additional user profile information try the following… DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIBRARY/MYFILE)OUTMBR(*FIRST *ADD) Once the file is [...]
View Answer
| April 30, 2007 7:18 PM
DataCenter, Security
I’ve done this successfully on PCs, I’ve never heard, or seen a way to successfully display an AS/400 password. IBM has locked this down well. Don’t be completely discourage. To obtain the user profile information and a ton of additional user profile information try the following… DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(MYLIBRARY/MYFILE)OUTMBR(*FIRST *ADD) Once the file is [...]
View Answer
| April 30, 2007 7:18 PM
DataCenter, Security
Remote Printing Problem
make sure that job separators = 0 in output queue description
View Answer
| April 26, 2007 5:21 PM
AS/400, DataCenter, Hardware, Interoperability, Networking, Printers, Printing, Software, Tech support
make sure that job separators = 0 in output queue description
View Answer
| April 26, 2007 5:21 PM
AS/400, DataCenter, Hardware, Interoperability, Networking, Printers, Printing, Software, Tech support
Lost Global Catalogue
you will have to do an authorative restore to AD. Hopefully your 2 weeks worth of tapes either have not been overwritten or you can have the data extracted from the tape via a data recovery team. DO you have any other GC’s in your environment plus how did users work for the 2 weeks [...]
View Answer
| April 25, 2007 8:32 AM
Active Directory, Desktops, DHCP, DNS, General Directories, Lotus Domino, Management, Microsoft Windows, Networking services, OS, Security, Servers, SQL Server, Tech support
you will have to do an authorative restore to AD. Hopefully your 2 weeks worth of tapes either have not been overwritten or you can have the data extracted from the tape via a data recovery team. DO you have any other GC’s in your environment plus how did users work for the 2 weeks [...]
View Answer
| April 25, 2007 8:32 AM
Active Directory, Desktops, DHCP, DNS, General Directories, Lotus Domino, Management, Microsoft Windows, Networking services, OS, Security, Servers, SQL Server, Tech support
Locked down Terminal Server 2003
What steps did you take to lock the system down?
View Answer
| April 20, 2007 11:29 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
What steps did you take to lock the system down?
View Answer
| April 20, 2007 11:29 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Upload to AS400 DB file
Loading external data to an AS/400 file is always a multi-step process, which is true with any database. Excel treats each cell independently. DBs are strict about field content and type. There are two primary ways to do a load to an as/400 physical file. Both ways first involve having the target file already created. [...]
View Answer
| April 17, 2007 9:33 PM
Application development, AS/400, DataCenter
Loading external data to an AS/400 file is always a multi-step process, which is true with any database. Excel treats each cell independently. DBs are strict about field content and type. There are two primary ways to do a load to an as/400 physical file. Both ways first involve having the target file already created. [...]
View Answer
| April 17, 2007 9:33 PM
Application development, AS/400, DataCenter
Service Program, Activation Group
Hi Rama Service programs, binding directories and activation groups are mainly to do with ILE programs as opposed to OPM programs, so that’s probably the best place to start. In the “good old days” you would write a program in RPG, CL, COBOL, etc and compile it as a single entity which could be called [...]
View Answer
| April 16, 2007 10:01 AM
AS/400, CLP, DataCenter, RPG, RPGLE
Hi Rama Service programs, binding directories and activation groups are mainly to do with ILE programs as opposed to OPM programs, so that’s probably the best place to start. In the “good old days” you would write a program in RPG, CL, COBOL, etc and compile it as a single entity which could be called [...]
View Answer
| April 16, 2007 10:01 AM
AS/400, CLP, DataCenter, RPG, RPGLE
ALDON
It’s been a while since I used Aldon, and I may be getting it confused with Turnover, but I seem to recall that Aldon/CMS warned you that an object was already checked out and gave you the option to proceed and check it out anyway. The first person to check it back in had their [...]
View Answer
| April 16, 2007 7:46 AM
Application development, AS/400, DataCenter, RPG, RPGLE, Security
It’s been a while since I used Aldon, and I may be getting it confused with Turnover, but I seem to recall that Aldon/CMS warned you that an object was already checked out and gave you the option to proceed and check it out anyway. The first person to check it back in had their [...]
View Answer
| April 16, 2007 7:46 AM
Application development, AS/400, DataCenter, RPG, RPGLE, Security
Terminal Session DST
Some questions: 1) Are you in the same time zone? 2) In which direction (forward or backward) is the error? 3) Where does (or do) the discrepancy show up? (file time stamps, transaction-unique time stamps, etc.) 4) Is the time discrepancy tied to any particular application that you can identify? 5) Are there ANY apps [...]
View Answer
| April 12, 2007 6:23 PM
DataCenter
Some questions: 1) Are you in the same time zone? 2) In which direction (forward or backward) is the error? 3) Where does (or do) the discrepancy show up? (file time stamps, transaction-unique time stamps, etc.) 4) Is the time discrepancy tied to any particular application that you can identify? 5) Are there ANY apps [...]
View Answer
| April 12, 2007 6:23 PM
DataCenter
media recovery
best is to create a link betwwen c: and S: Is db in archivelogmode? Was db in restricted mode? Did you enter the recovery command ie “recover database;” to actually recover. Initsid.ora locations need changing. Hard to diagnose further. Keep me in the loop please.
View Answer
| April 10, 2007 3:29 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
best is to create a link betwwen c: and S: Is db in archivelogmode? Was db in restricted mode? Did you enter the recovery command ie “recover database;” to actually recover. Initsid.ora locations need changing. Hard to diagnose further. Keep me in the loop please.
View Answer
| April 10, 2007 3:29 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Connecting Samba to Active Directory
You have to go into the domain security policy. The specifics are covered in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;555038 This is actually based on the idea that the only other OS that is compatible with the Microsoft version of Kerberos is the latest Mac OS and Microsoft by default leaves the Kerberos Signing set to Required.
View Answer
| April 5, 2007 12:17 AM
Active Directory, Desktops, General Directories, Linux, Lotus Domino, Management, Microsoft Windows, OS, Security, Servers, SQL Server
You have to go into the domain security policy. The specifics are covered in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;555038 This is actually based on the idea that the only other OS that is compatible with the Microsoft version of Kerberos is the latest Mac OS and Microsoft by default leaves the Kerberos Signing set to Required.
View Answer
| April 5, 2007 12:17 AM
Active Directory, Desktops, General Directories, Linux, Lotus Domino, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Connecting Samba to Active Directory
You have to go into the domain security policy. The specifics are covered in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;555038 This is actually based on the idea that the only other OS that is compatible with the Microsoft version of Kerberos is the latest Mac OS and Microsoft by default leaves the Kerberos Signing set to Required.
View Answer
| April 5, 2007 12:17 AM
Active Directory, Desktops, General Directories, Linux, Lotus Domino, Management, Microsoft Windows, OS, Security, Servers, SQL Server
You have to go into the domain security policy. The specifics are covered in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;555038 This is actually based on the idea that the only other OS that is compatible with the Microsoft version of Kerberos is the latest Mac OS and Microsoft by default leaves the Kerberos Signing set to Required.
View Answer
| April 5, 2007 12:17 AM
Active Directory, Desktops, General Directories, Linux, Lotus Domino, Management, Microsoft Windows, OS, Security, Servers, SQL Server
server temporary freezing
During such a failure, can you still ping the server and what is the CPU usage,free system pages, available work items/server items, etc., etc. If you can’t ping it than it’s a network, nic, or cpu issue, relatively easy to fix. If it’s not CPU then you’ll have to look at the other items and [...]
View Answer
| April 4, 2007 11:05 AM
DataCenter, Desktops, Hardware, Management, Microsoft Windows, Networking, OS, Security, Servers, Software, SQL Server, Storage, Tech support
During such a failure, can you still ping the server and what is the CPU usage,free system pages, available work items/server items, etc., etc. If you can’t ping it than it’s a network, nic, or cpu issue, relatively easy to fix. If it’s not CPU then you’ll have to look at the other items and [...]
View Answer
| April 4, 2007 11:05 AM
DataCenter, Desktops, Hardware, Management, Microsoft Windows, Networking, OS, Security, Servers, Software, SQL Server, Storage, Tech support
