Virus scanning the iSeries IFS
There are a couple of ways to scan the IFS for Viruses. One is to use Trend Micro www.trendmicro.com. I think it more for Domino for iSeries though. The other is to use a PC or NT server with Norton’s or other flavor of antivirus. Map a drive to the IFS and scan the drive. [...]
View Answer
| February 7, 2006 10:40 AM
Application security, backdoors, Compliance, configuration, CRM, Current threats, Database, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Spyware, Trojans, Viruses, VPN, vulnerability management, Wireless, worms
There are a couple of ways to scan the IFS for Viruses. One is to use Trend Micro www.trendmicro.com. I think it more for Domino for iSeries though. The other is to use a PC or NT server with Norton’s or other flavor of antivirus. Map a drive to the IFS and scan the drive. [...]
View Answer
| February 7, 2006 10:40 AM
Application security, backdoors, Compliance, configuration, CRM, Current threats, Database, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Spyware, Trojans, Viruses, VPN, vulnerability management, Wireless, worms
Oracle Sql Tuning
This linke will provide some useful informaton: http://asktom.oracle.com/pls/ask/f?p=4950:8:8488073385483584370::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:8764517459743
View Answer
| February 3, 2006 2:39 PM
Database, DB2, Oracle, Windows
This linke will provide some useful informaton: http://asktom.oracle.com/pls/ask/f?p=4950:8:8488073385483584370::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:8764517459743
View Answer
| February 3, 2006 2:39 PM
Database, DB2, Oracle, Windows
List of Values in a SP Parameter
Is there a way you could write the value list to a temporary table every time you call the SP? Then you wouldn’t have to pass the value list, but call it in you WHERE clause like: WHERE Field1 in (Select * from table_temp)
View Answer
| February 3, 2006 11:37 AM
Application development, Crystal Reports, DB2 Universal Database
Is there a way you could write the value list to a temporary table every time you call the SP? Then you wouldn’t have to pass the value list, but call it in you WHERE clause like: WHERE Field1 in (Select * from table_temp)
View Answer
| February 3, 2006 11:37 AM
Application development, Crystal Reports, DB2 Universal Database
Syncronize DB2 email dist list with Lotus Domino v6.5
Have a look at DECS and Lotus Script / Java, you can find a solution over there. Also you can look at LECS for DB2 connectors, it is downloadable from the Lotus forum, then you can use the classes to access DB2 and get to your data, If you are good with Script then I [...]
View Answer
| February 2, 2006 7:26 AM
DB2 Universal Database, Lotus Domino
Have a look at DECS and Lotus Script / Java, you can find a solution over there. Also you can look at LECS for DB2 connectors, it is downloadable from the Lotus forum, then you can use the classes to access DB2 and get to your data, If you are good with Script then I [...]
View Answer
| February 2, 2006 7:26 AM
DB2 Universal Database, Lotus Domino
A copy tool??
If everything is on files you can use CPYF or SQL, for example. I am not sure what you excatly you are looking for. You copy all your production environment, or just selected data from it ? Is the second environment on another system ? Beni
View Answer
| February 1, 2006 6:23 AM
Application development, AS/400, DataCenter, DB2 Universal Database, RPG
If everything is on files you can use CPYF or SQL, for example. I am not sure what you excatly you are looking for. You copy all your production environment, or just selected data from it ? Is the second environment on another system ? Beni
View Answer
| February 1, 2006 6:23 AM
Application development, AS/400, DataCenter, DB2 Universal Database, RPG
In VPN Which protocol to be used……??
It is hard to tell you exactly what to do based on your exact needs. check here to get simple information using cisco management interface. http://www.cisco.com/en/US/products/hw/vpndevc/ps2284/products_configuration_guide_chapter09186a00803ee03b.html cheers
View Answer
| January 31, 2006 7:17 AM
Access control, Application security, Availability, backdoors, Bandwidth, Biometrics, Browsers, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
It is hard to tell you exactly what to do based on your exact needs. check here to get simple information using cisco management interface. http://www.cisco.com/en/US/products/hw/vpndevc/ps2284/products_configuration_guide_chapter09186a00803ee03b.html cheers
View Answer
| January 31, 2006 7:17 AM
Access control, Application security, Availability, backdoors, Bandwidth, Biometrics, Browsers, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Exam question Antivirus – VPN – related
Ah, right up my alley – and I do thank you for being up front about this being an assignment. We’ve had other folks who have tried to get us to do their homework for them. The key thing you have to understand is some terminology which is often bandied about without distinction. The distinction [...]
View Answer
| January 26, 2006 11:38 PM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Interoperability, Intrusion management, Network security, Networking, Secure Coding, Security, Servers, Software, Spyware, SSL/TLS, Tech support, Trojans, Viruses, VPN, Web security, Wireless, worms
Ah, right up my alley – and I do thank you for being up front about this being an assignment. We’ve had other folks who have tried to get us to do their homework for them. The key thing you have to understand is some terminology which is often bandied about without distinction. The distinction [...]
View Answer
| January 26, 2006 11:38 PM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Interoperability, Intrusion management, Network security, Networking, Secure Coding, Security, Servers, Software, Spyware, SSL/TLS, Tech support, Trojans, Viruses, VPN, Web security, Wireless, worms
Oracle boolean data type questions
> 1) From a comparison perspective, which provides better performance? Comparison > of a number (1,0) or string (Y/N) It won’t make a difference. > 2) Which method takes up less storage? They both take 1 byte. > 3) Results will be mapped into a J2EE data structure supporting a boolean datatype. > Which method [...]
View Answer
| January 26, 2006 6:35 PM
Database, DB2, Oracle
> 1) From a comparison perspective, which provides better performance? Comparison > of a number (1,0) or string (Y/N) It won’t make a difference. > 2) Which method takes up less storage? They both take 1 byte. > 3) Results will be mapped into a J2EE data structure supporting a boolean datatype. > Which method [...]
View Answer
| January 26, 2006 6:35 PM
Database, DB2, Oracle
AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …
We manage several DBs of the size you are discussing. Although the intel based platforms are OK, for the size and performance you are mentioning for the DW, we run all of ours on Sun systems. We use V880s for this application. A V400 series might do the trick with only 200 to 400 users. [...]
View Answer
| January 25, 2006 9:01 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
We manage several DBs of the size you are discussing. Although the intel based platforms are OK, for the size and performance you are mentioning for the DW, we run all of ours on Sun systems. We use V880s for this application. A V400 series might do the trick with only 200 to 400 users. [...]
View Answer
| January 25, 2006 9:01 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Move from DB2/400 flat-file system to Oracle
On then 400, you can use RTVSQL to retrieve the DDL of each object you want, then you can analyse this DDL. I don’t know anything in Oracle. RTVSQL source is at http://jplamontre.free.fr/AS400/RTVSQL.htm
View Answer
| January 23, 2006 3:41 PM
DB2 Universal Database
On then 400, you can use RTVSQL to retrieve the DDL of each object you want, then you can analyse this DDL. I don’t know anything in Oracle. RTVSQL source is at http://jplamontre.free.fr/AS400/RTVSQL.htm
View Answer
| January 23, 2006 3:41 PM
DB2 Universal Database
Problems copying from a PF to a XML file using CPYTOIMPF
what is sometimes different ? provide samples at least. What are file attributes (particularly CCSIDS) of in & out files ?
View Answer
| January 23, 2006 3:37 PM
DB2 Universal Database
what is sometimes different ? provide samples at least. What are file attributes (particularly CCSIDS) of in & out files ?
View Answer
| January 23, 2006 3:37 PM
DB2 Universal Database
OVRDBF in Java
Make sure that your override is at the same invocation level as your program. I know in CL that makes a difference.
View Answer
| January 23, 2006 3:05 PM
Application development, AS/400, CLP, DB2 Universal Database, Java
Make sure that your override is at the same invocation level as your program. I know in CL that makes a difference.
View Answer
| January 23, 2006 3:05 PM
Application development, AS/400, CLP, DB2 Universal Database, Java
Query Regarding Crystal Reports
If you are running Crystal Reports client you can export to what they call Record Style (Column with Spaces) format. File — Export — Select the export format. It is worded a little differantly depending on the version of Crystal Reports. Just look for it. This may not be an option depending on how you [...]
View Answer
| January 21, 2006 10:49 AM
Business/IT alignment, Database, DB2, Development, Oracle
If you are running Crystal Reports client you can export to what they call Record Style (Column with Spaces) format. File — Export — Select the export format. It is worded a little differantly depending on the version of Crystal Reports. Just look for it. This may not be an option depending on how you [...]
View Answer
| January 21, 2006 10:49 AM
Business/IT alignment, Database, DB2, Development, Oracle
Selecting and inserting library names
I inserted the following into a CLLE program. You then can use the eseq and substitute the variable for the SQL statement you just created: CHGVAR VAR(&SQLSTMT) VALUE(‘CREATE TABLE + QTEMP/INTHDR (MIQHFT CHAR (6 ) NOT NULL + WITH DEFAULT, MIQUID CHAR (8 ) NOT NULL + WITH DEFAULT)’) ESQL SQLSTM(&SQLSTMT)
View Answer
| January 20, 2006 2:35 PM
DB2 Universal Database
I inserted the following into a CLLE program. You then can use the eseq and substitute the variable for the SQL statement you just created: CHGVAR VAR(&SQLSTMT) VALUE(‘CREATE TABLE + QTEMP/INTHDR (MIQHFT CHAR (6 ) NOT NULL + WITH DEFAULT, MIQUID CHAR (8 ) NOT NULL + WITH DEFAULT)’) ESQL SQLSTM(&SQLSTMT)
View Answer
| January 20, 2006 2:35 PM
DB2 Universal Database
Is there an IBM Tool to Rebind Plans/Collections
Unless I misunderstood, it is easy. Just run this job step to rebind all packages in a collection: //BATCHDSN EXEC PGM=IKJEFT1B,PARM=’DSN S(DB2P)’ //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * REBIND PACKAGE(collection.*.(*)) The first * means “all packages”, the second “all versions” within this collection. In fact, you can replace collection by * as [...]
View Answer
| January 20, 2006 7:07 AM
390, Database, DB2, Mainframe, Oracle
Unless I misunderstood, it is easy. Just run this job step to rebind all packages in a collection: //BATCHDSN EXEC PGM=IKJEFT1B,PARM=’DSN S(DB2P)’ //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * REBIND PACKAGE(collection.*.(*)) The first * means “all packages”, the second “all versions” within this collection. In fact, you can replace collection by * as [...]
View Answer
| January 20, 2006 7:07 AM
390, Database, DB2, Mainframe, Oracle
Data Extraction into SQL Server Database from Cache ODBC Database
It sounds like the query is not correct. You should query against the base tables and not the view. I expect you are joining the view to some number of tables and returning one or more rows from the child tables resulting in the views rows being returned multiple times. Use Right and Left joins [...]
View Answer
| January 17, 2006 10:11 AM
Data analysis, Data warehousing applications, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
It sounds like the query is not correct. You should query against the base tables and not the view. I expect you are joining the view to some number of tables and returning one or more rows from the child tables resulting in the views rows being returned multiple times. Use Right and Left joins [...]
View Answer
| January 17, 2006 10:11 AM
Data analysis, Data warehousing applications, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Oracle Developer 6i and 9i database connection problems
Unless you’ve read some official Oracle document that said it should work, it sounds like they have finally broken the backward compatibility. Perhaps you should consider that you’ve gotten your money’s worth, at this point, and it’s time to upgrade? Seems odd that they’d break it on a minor revision, but it might have been [...]
View Answer
| January 13, 2006 10:44 AM
Database, DB2, Oracle
Unless you’ve read some official Oracle document that said it should work, it sounds like they have finally broken the backward compatibility. Perhaps you should consider that you’ve gotten your money’s worth, at this point, and it’s time to upgrade? Seems odd that they’d break it on a minor revision, but it might have been [...]
View Answer
| January 13, 2006 10:44 AM
Database, DB2, Oracle
iSeries and PHP
A good resource for php on the iSeries is http://www.i5php.net
View Answer
| January 13, 2006 10:35 AM
Application development, AS/400, DB2 Universal Database, Networking
A good resource for php on the iSeries is http://www.i5php.net
View Answer
| January 13, 2006 10:35 AM
Application development, AS/400, DB2 Universal Database, Networking
Partitioning a large financial table
RDBMS used? version? if that’s using Oracle financials there are partitioning schemes in the Apps that Oracle recommend using because of the way the applications access the data cheers
View Answer
| January 13, 2006 8:33 AM
Database, DB2, Oracle
RDBMS used? version? if that’s using Oracle financials there are partitioning schemes in the Apps that Oracle recommend using because of the way the applications access the data cheers
View Answer
| January 13, 2006 8:33 AM
Database, DB2, Oracle
Deleting old userids
You could run a wmi script that pulls it directly from Active Directory. As I found out, however, it’s not as easy as just pulling it off your DC, so giving you a script to copy/paste to your system isn’t going to work. You can go to the following page to see how the scripting [...]
View Answer
| January 11, 2006 10:32 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, provisioning, Secure Coding, Security, Security tokens, Single sign-on, VPN, Wireless
You could run a wmi script that pulls it directly from Active Directory. As I found out, however, it’s not as easy as just pulling it off your DC, so giving you a script to copy/paste to your system isn’t going to work. You can go to the following page to see how the scripting [...]
View Answer
| January 11, 2006 10:32 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, provisioning, Secure Coding, Security, Security tokens, Single sign-on, VPN, Wireless
